Ray's Asp.net Blog
Answers and code snippets from ASP.NET projects (Webforms/MVC/Classic ASP)
Pages
Event registration app with QR/Paypal
Home
Tuesday, January 31, 2012
How to check if column existed by a simple way in MS SQL?
IF
COL_LENGTH
(
'TableName'
,
'ColumnName'
)
IS
NULL
BEGIN
exec
sp_executesql
@SQLStatement
END
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment