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   
 

CTE DML

This script is an example explaining how to write DML using CTE.  Read more...
By kbhanu15 2014/07/23 | Source: SQLServerCentral.com | Category: dml
Rating: |  Discuss |   Briefcase | 1,357 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: SQLServerCentral.com | Category: rows
Rating: |  Discuss |   Briefcase | 1,106 reads

OUTPUT - 1

By bitbucket-25253 2013/02/27 | Category: dml
Rating: (not yet rated) |  Discuss |   Briefcase | 2,040 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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,681 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: SQLServerCentral.com | Category: ddl
Rating: |  Discuss |   Briefcase | 2,103 reads

DML Triggers

By Prashant Pandey 2007/12/12 | Category: triggers
Rating: (not yet rated) |  Discuss |   Briefcase | 3,420 reads
   Items 1 to 7 of 7   
 
Tags
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)