Viewing 15 posts - 781 through 795 (of 812 total)
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.
--...
April 16, 2009 at 3:13 am
-- try to use this for replication:
set identity_insert my_table on
April 2, 2009 at 4:04 am
-- 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...
April 2, 2009 at 2:45 am
--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...
March 20, 2009 at 2:07 am
-- 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...
March 11, 2009 at 3:19 am
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
Viewing 15 posts - 781 through 795 (of 812 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy