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

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

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:

Please, try this one:

exec sp_MSdependencies N'[dbo].[mysp_elab]', null, 1053183

Third parameter is 1053183, that means only table named in the sp.

Without parms, it returns all dipendencies: table used in the sp and...

If you do not use dynamic sql in your sp, you have the sysdepends table with all dependencies between objects.

Here you are:

SELECT object_name(id) as sp,object_name(depid) as dep_obj FROM sysdepends

WHERE...