Browse by Tags

• NULLIF
• Nulls
• Productivity
• Shortcut
• SQL Server 2005
• Tips and Tricks
• trick

• Return Null If A Value Is A Certain Value

  You need to return NULL only if the value of your data is a certain value. How do you do this? There are three different ways. NULLIF DECLARE @1 char (1) SELECT @1 = 'D' SELECT NULLIF (@1 ,'D' ) REPLACE This should not really be used, I just added it Read More... Posted Tuesday, November 06, 2007 2:28 PM by Denis Gobo | 7 Comments Filed under: Tip, SQL Server 2008, sqL Server 2000, SQL Server 2005, trick, NULLIF, Nulls

• Increase Your Productivity With Query Analyzer/SQL Server Management Studio

  Drag And Drop Column Names In Query Analyzer you can save a lot of time by using this trick instead of typing all the column names of a table Hit F8, this will open Object Browser Navigate to DatabaseName/TableName/Columns Click on the column folder and Read More... Posted Monday, September 24, 2007 12:52 PM by Denis Gobo | 5 Comments Filed under: Tip, SQL Server 2008, sqL Server 2000, SQL Server 2005, Shortcut, Tips and Tricks, Productivity