Browse by Tags
All Tags »
SQL (
RSS)
Sorry, but there are no more tags available to filter with.
Here's an easy way to check if a temp table exists, before trying to create it (ie. for reusable scripts) from Simon Sabin's post : IF object_id ( 'tempdb..#MyTempTable' ) IS NOT NULL BEGIN DROP TABLE #MyTempTable END CREATE TABLE #MyTempTable ( ID int...
By entering SQLCMD mode in a SQL Server Management Studio query window, you can do some very handy things without needing to jump back out to the command prompt. Commands can be run just like at the command prompt, by prefixing the line with "!!" a la...
I'm going to try to force myself to write at least a little blurb daily, but we'll see just how long that lasts. Anyway, today's odd bit of SQL -- I needed to get a list of all items in a table that had no corresponding child records via a self join....
More Posts