DATETIME SELECT SELECT INTO DATE PAD STRING DYNAMIC SQL CURSOR MONEY FORMAT PERCENT STORED PROCEDURE SQL SERVER AGENT JOB OPTIMIZATION WHILE LOOP OVER PARTITION BY UPDATE
 
 
SITE SEARCH SQLUSA.com VIDEOS
 
 
SQL E/BOOKS   WORLD, USA & SQL NEWS   FORMAT
SCRIPTS SQL 2005 SQL 2008 ARTICLES

Microsoft SQL Server 2005
Database Design Best Practices

 

How to data compare two tables using EXCEPT?

How to work around error 468?

How to create drugs table for an online pharmacy?

How to calculate workdays in a period?

How to use YYYYMMDD DATE-only string?

How to import XML data into a table?

How to apply table variables in sql database?

How to apply RIGHT JOIN to include count zero items in GROUP BY?

How to find filegroup location of indexes?

How to apply COMMIT TRANSACTION?

How to use the IDENTITY_INSERT switch?

How to maintain computed column with a trigger?

How to configure a computed column?

How to build a trigger on columns?

How to find all primary keys in the database?

How to use synonyms in the database?

How to use DEFAULT VALUES for table INSERT?

How to use the NewSequentialID function

How to use sp_tableoption?

How to create and apply an indexed view?

How to exceed the 8000 bytes row length limit?

How to find all tables where a column occurs?

How to create the Order and OrderDetail tables?

How to create a supplier table?

Exam Prep 70-461
SQL 2016 DESIGN & PROGRAMMING
 
 
 
DATETIME SELECT SELECT INTO DATE PAD STRING DYNAMIC SQL CURSOR MONEY FORMAT PERCENT STORED PROCEDURE SQL SERVER AGENT JOB OPTIMIZATION WHILE LOOP OVER PARTITION BY UPDATE