While you are working in Query window, if you want to delete the current row, you have to highlight entire row and press delete key. Another alternate is to use SHIFT+DEL key. The cursor can be at any position and the entire row will be deleted

When you copy or cut texts they are stored in the memory in the Clipboard ring. Pressing CTRL+V will give you the recently copied/cut message. If you want to have the history of the copies and get whichever you want out of them, use CTRL+SHIFT+V. This work

In IE, when you open multiple tabs in the single window, you can copy urls of all opened tabs using below steps In the menu 1 Go to Tools-->Internet options 2 In the General tab, click the button labelled Use current. It will display all urls an

Aggregate functions always return at least a row. So using aggregate function to check for the existance of data is not good method. See the results returned from these queries [code] declare @t table(i int) if exists(select i from @t) select 'yes'

The WRITETEXT statement is used to update a column of datatypes text, ntext and image. However it will not fire INSERT or UPDATE triggers

Microsoft announced that SQL Server ODBC Driver for Linux will be available along with next version of SQL Server 2012 at Pass Summit 2011.

You should note the behaviour in the expressions used in the ORDER BY Clause [code]select 1 as a, 2 as b order by GETDATE()[/code] The following code throws an error Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the nvarchar v

Run this code and see the pattern matching in the result [code]select 987654321987654321987654321987654321*3.0, 987654321987654321987654321987654321*9.0 [/code]

From, SQL Server help file, "An UPDATE, INSERT, or DELETE statement that has an OUTPUT clause will return rows to the client even if the statement encounters errors and is rolled back. The result should not be used if any error occurs when you run the s

You may be aware of the Code Snippet intoduced in SQL Server Denali as i posted for the same here, http://beyondrelational.com/blogs/paresh/archive/2011/06/06/code-snippets-in-sql-server-denali.aspx. We can also create Custom Code Snippet in SQL Server