Software engineering and business solutions blog featuring SaaS reviews, automation tools, and business insurance guides. Buyer-intent content designed to drive high-quality traffic and conversions.
Tuesday, March 12, 2013
T-SQL Library - Check if Column Exists Alter Table
Composing T-SQL to run over and over to check into source control for column change....
IF NOT EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'tbl_Provider_Concerns'
AND COLUMN_NAME = 'concern_status_id')
BEGIN
ALTER TABLE tbl_Provider_Concerns
ADD concern_status_id INT
END
ALTER TABLE tbl_Provider_Concerns
ADD CONSTRAINT FK_Status
FOREIGN KEY(concern_status_id)
REFERENCES tbl_Provider_Concern_Status(concern_status_id)
Subscribe to:
Post Comments (Atom)
Best Hypervisor for Home Lab: A Comprehensive Overview
Best Hypervisor for Home Lab Introduction to Hypervisors in Home Labs Hypervisors are a critical component in virtualization technol...
-
How to clear SharePoint People Picker suggestion cache If you have been SharePoint Site owner long enough, you would have definitely ...
-
Getting the following error (Figure 1): Server Error in '/' Application. ID4014: A SecurityTokenHandler is not registered to ...
-
The problem was that the remote connection needed to utilize Named Pipes, but in order to utilize Named Pipes both the machine hosting the i...
No comments:
Post a Comment