I...

It does nothing! 😎

Correct answer is 1-25:

exec sp_helptext sp_addmessage

in the output search for @severity and you'll find this piece of code that is the law.

--...

Bah?

-- try to use this for replication:

set identity_insert my_table on

-- what about IDENTITY??

SET NOCOUNT ON

-- Just a simple test table

IF (OBJECT_ID('tempdb..#my_tab') IS NOT NULL)

DROP TABLE #my_tab

CREATE TABLE #my_tab (id INT NOT NULL IDENTITY(1000,1), any_date DATETIME)

-- Create...

???????????????

--for a list of store proc/func/view/etc. and getting the body of proc/func/view/etc. run this query

--copy the resultset and paste it in a new querywindow, then run it.

set nocount on

select 'exec...

-- This proc print a statement to copy data from one table to another with same structure. e.g. transfering data between servers (production to develop)

-- I use it in...

Thanks! Some times sql behave in unexpected manner.

The correct answer is only ONE:

2009-02-01 00:00:00:000, 2009-01-31 00:01:01:000, 2009-01-31 21:59:58:347

I do not know why there was a multiple choise.

The author of QotD.

Iggy (2/8/2009)

---

Whilst I totally understand it's a valid identifier, I just want to understand, does that query create a table with the name "#", or does it create a temporary...

Obvious!

Version for Sql 2000: 😀

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

--PART OF THE MACRO CODE EXECUTION BY CHRIS MORTON

--CONTACT CBMORTON@GMAIL.COM

--2009-01-05

--20/01/2009 Carlo Romagnano - specify table names and @SQLScript speficy $T as...

Linson.Daniel (1/12/2009)

---

Carlos,

First of all, great SP there...but let me tell you why mine is quite different from yours.

1. Here my aim was to script the table s data in insert...