Skip to main content

Posts

Featured

Some Shortcuts in SSMS Query Editor

List of Shortcuts which you can use while using SSMS Query editor. 1) Ctrl+Shift+Q -> Pops up the Query Builder 2) Highlight and Press Alt+ F1 Brings all the structural details for which an equivalent replacement is sp_help 3) sp_helptext 'SPName' for scripting out the code contents of a Procedure. 4) Ctrl+K, then Ctrl+C to comment lines 5) Ctrl+K, then Ctrl+U to uncomment lines

Latest Posts

Few SSRS Issues and Workarounds I encountered

Converting non-ansi *= or =* to SQL 92 type / ansi joins

Did you know that ISNULL function can take Query as a parameter ?

System Table Queries (2000)

Passing DataTable into a StoredProcedure

List of all Procedures and dependant Tables that are updated using linked server

Query to get a list of foreign key constraints for a table

Keep a check on your IDENTITY columns in SQL Server

About Data Profiling Task in SSIS 2008

My feedback for SQL Server 2008 February CTP-6.