Viewing 15 posts - 766 through 780 (of 789 total)
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...
January 20, 2009 at 1:08 am
Linson.Daniel (1/12/2009)
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...
January 12, 2009 at 10:02 am
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...
January 12, 2009 at 12:54 am
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...
January 3, 2009 at 2:23 am
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...
January 2, 2009 at 2:54 am
I hate UNICODE. It uses a lot memory uselessly. It brings applications to BAD performance. :angry:
January 2, 2009 at 1:30 am
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...
January 2, 2009 at 1:23 am
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...
December 30, 2008 at 12:47 am
From now, every time you'll write a joined query, you'll think to Elthon JOIN.
In confidence, I prefer Freddy Mercury e his band The QUEEN.
December 29, 2008 at 10:02 am
GilaMonster (10/14/2008)
Hence there's an implicit Order by 1 ASC on the statement.
Also the DISTINCT clause and the GROUP BY perform an implicit ORDER BY for all cols, but "IMPLICIT" is...
October 14, 2008 at 2:26 am
Viewing 15 posts - 766 through 780 (of 789 total)