Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tag DML Rss

   Items 1 to 7 of 7   


This script is an example explaining how to write DML using CTE.  Read more...
By kbhanu15 2014/07/23 | Source: | Category: dml
Rating: |  Discuss |   Briefcase | 1,471 reads

Generate row constructors for existing data

Takes a given table and generates a UNION ALL'd set of rows from the table. Useful for copying small amounts of data without the need for SSIS or import/export wizard  Read more...
By Gabe Tower 2013/11/14 | Source: | Category: rows
Rating: |  Discuss |   Briefcase | 1,121 reads


By bitbucket-25253 2013/02/27 | Category: dml
Rating: (not yet rated) |  Discuss |   Briefcase | 2,051 reads

Stairway to T-SQL Level 2: History of Structured Query Language (SQL)

Let’s step back in time and discuss the history of Structured Query Language, or what most SQL Server professionals just shorten to SQL. Fasten your seatbelts, crank up the time machine and travel back in time to follow the history of SQL and Microsoft SQL Server from its early years to where they are today.  Read more...
By Gregory Larsen 2011/10/21 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 9,156 reads

Stairway to T-SQL DML

This Stairway will provide you with a basic understanding of how to work with data from SQL Server tables, using SQL Server’s Transact-SQL (T-SQL) dialect. DML is the Data Manipulation Language, and is the aspect of the language dealing with the data. It includes the statements SELECT, INSERT, UPDATE and DELETE. This Stairway will as also provide some history of the SQL language and some general concepts about set theory. Each level will build upon the prior level, so by the time you are finished you will have a good understanding of how to select and modify data from SQL Server.   Read more...

Update 2 databases with 1 script

This script will allow you to update 2 databases with the same names, but different schemas/software/database versions.  Read more...
By Rich Yarger 2011/03/14 | Source: | Category: ddl
Rating: |  Discuss |   Briefcase | 2,112 reads

DML Triggers

By Prashant Pandey 2007/12/12 | Category: triggers
Rating: (not yet rated) |  Discuss |   Briefcase | 3,425 reads
   Items 1 to 7 of 7   
t-sql (3)    
stairway series (2)    
copy (1)    
cte (1)    
ddl (1)    
export (1)    
history (1)    
howto (1)    
import (1)    
inserts (1)    
integration services (ssis) (1)    
move data (1)    
row constructors (1)    
rows (1)    
sql server 2005 (1)    
triggers (1)