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
Home »
General
SQL SERVER – Insert Data From One Table to Another Table
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
Differences between User Defined Functions and Stored Procedures
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
To find all the tables that have an identity column
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.
To find tables without clustered Indexes or Heaps
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.