Tagged with sql

Prompt SQL: Intellisense for SQL

I just wanted to blog a link to a cool tool that someone posted a link to on the MSWebDev list. It’s called prompt sql and provides an intellisense style dropdown menu to SQL Query analyser and the SQL editors in VS.NET.
Published in SQL server on Wednesday, October 12th, 2005

Saving a single value from a query to a variable in Transact SQL

You wouldn’t believe how difficult this was to find, but it’s easy when you know how.. :) DECLARE @MyVariable int SELECT @MyVariable = MyColumn FROM TABLE;
Published in SQL server on Wednesday, November 3rd, 2004