-- 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...

I use this one that is fast and do not use cursor. In SSMS I put it in hotkey ctrl+3. When I select the table I press ctrl+3 and I...

Last idea: follow the rule of KISS (Keep It Simple & Stupid) write store procedure formatting it with the following rule: every command that reference a table should be on...

sysdepends lists tables only if they are in the same database and the sp is created after the table. To update syspedends please ALTER PROCEDURE and then run exec sp_MSdependencies...

I hate UNICODE. It uses a lot memory uselessly. It brings applications to BAD performance. :angry: