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

Posted by GrumpyOldDBA on SQL Blogcasts See other posts from SQL Blogcasts or by GrumpyOldDBA
Published on Mon, 17 May 2010 19:12:04 GMT Indexed on 2010/05/17 20:21 UTC
Read the original article Hit count: 340

Filed under:
|
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...(read more)

© SQL Blogcasts or respective owner

Related posts about Code Tuning

Related posts about best practice