Here is the script to rename an SQL column,
EXEC sp_rename @objname = 'table_name.old_column_name', @newname = 'new_column_name', @objtype = 'COLUMN'
Parser Error Message: Could not load type
Swine Flw
Comments powered by Disqus.
Today I just got went though this, this helps you to execute a string in SQL. This is how you can execute a string in SQL, Declare @query Varchar(500) Set @query = ‘Select * From Employees’ Exec...
Its been very long since I have written any technical post. So here I am, with small example of how to insert data from XML into SQL. This is extremely helpful if you want to insert multiple record...
Since I am looking for a job change and this is the question I’m being asked in all of my interviews, I am sharing this with everyone hoping this will help you guys. The most common type of questi...