Using Raise Error in SQL Server Error Handling
When developing codes in SQL Server using Tsql, one has to use error handling mechanism, SQL Server has its own Error Handling mechanism where @@Error is used to trap the errors and we can get
SQL SERVER – Insert Data From One Table to Another Table There are two different ways to implement inserting data from one table to another table. 1 : INSERT INTO SELECT
First lets look at the two briefly and why they are useful. Stored Procedures can contain a single SQL statement or a group of SQL statements with data flow control l
I find the below query useful in identifying all the tables that have an identity column in it. SELECT SCHEMA_NAME(schema_id) AS schema_name , t.name AS table_name , c.
The always find the below query useful in identifying tables without clustered Indexes or Heaps SELECT SCHEMA_NAME(t.schema_id) AS schema_name, t.name AS table_name FROM sys.