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 HEADLINES NEWS
SQL E/BOOKS  SQL 2012 PROGRAMMING  DOWNLOADS
SCRIPTS SQL 2005 SQL 2008 ARTICLES
SQL JOBS TWITTER FORMAT VIDEOS

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
Exam 70-461
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