dcsimg
Login | Register   
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


Tip of the Day
Language: SQL
Expertise: Beginner
May 29, 2003

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


Changing the Column Name Through StoredProcedure Dynamically

Here's the syntax for the stored procedure:

CREATE PROCEDURE [dbo].[RenameColumn] @tblname as varchar(50), @oldcolname
as varchar(50), @newcolname as varchar(50)
AS
declare  @tblColname varchar(100)
set @tblColname =  @tblname +'.' + @oldcolname

BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
EXECUTE sp_rename   @tblColname   , @newcolname,'COLUMN'
COMMIT

GO
Then, execute this:

exec RenameColumn 'SFDIDs','CompanyID','CID'
Here SFDIDS is the table name
CompanyID is the Old column Name
CID is the new column Name
Gopala Krishna
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date