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
Home » Archives for Admin_vb »
Admin_vb
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
Recursive and Non-Recursive Common Table Expression
The Common Table Expression (CTE) is a temporary named result set that you can reference within a SELECT, INSERT, UPDATE, DELETE statements. You can also use a CTE in a CREATE VIEW statement, as part
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.