Wednesday, September 19, 2007 - Posts

TSQL to check whether the table has a column with the specified name?
19 September 07 03:51 PM | SQL Master | 2 Comments   
Within SQL Server 2005: if Exists( select * from sys.columns where Name = N '<ColumnName>' and Object_ID = Object_ID ( N '<TableName>' ) ) begin --write your own code print relevant code columns for existence end else begin --write your own Read More...