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: 369
Filed under:
Code Tuning
|best practice
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
