Just when you thought it was safe..........

One of my duties is to handle software releases to our Production system, as is my want I always run my eye down any schema changes, this new object stood out for a number of reasons.

I may add this to my interview questions:

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO

IF NOT EXISTS(SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='dbo' AND TABLE_NAME='MSPaymentForExtraction')
BEGIN

CREATE TABLE [dbo].[MSPaymentForExtraction]([MSPaymentID] [int] NOT NULL IDENTITY (1,1) NOT FOR REPLICATION
) ON [PRIMARY]

END

GO
.csharpcode, .csharpcode pre { font-size: small; color: black; font-family: consolas, "Courier New", courier, monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode pre { margin: 0em; } .csharpcode .rem { color: #008000; } .csharpcode .kwrd { color: #0000ff; } .csharpcode .str { color: #006080; } .csharpcode .op { color: #0000c0; } .csharpcode .preproc { color: #cc6633; } .csharpcode .asp { background-color: #ffff00; } .csharpcode .html { color: #800000; } .csharpcode .attr { color: #ff0000; } .csharpcode .alt { background-color: #f4f4f4; width: 100%; margin: 0em; } .csharpcode .lnum { color: #606060; }
Published 17 May 2010 20:12 by GrumpyOldDBA

Comments

# Twitter Trackbacks for Just when you thought it was safe.......... - Grumpy Old DBA [sqlblogcasts.com] on Topsy.com

Pingback from  Twitter Trackbacks for                 Just when you thought it was safe.......... - Grumpy Old DBA         [sqlblogcasts.com]        on Topsy.com

# So which null equals this null, that null? maybe this null, or is it this null?

16 June 2010 21:16 by Grumpy Old DBA

Tuning takes many routes and I get into some interesting situations and often make some exciting finds