CREATE PROCEDURE [dbo].[AssessList]
@fn varchar(20),@fnNew varchar(20)
set @sql='if exists(select * from syscolumns where id=object_id(N''Assess'') and name=N'''+@fn+''')
sp_rename ''Assess.['+@fn+'']','''+@fnNew +''',''column'''
exec (@sql)
@fn varchar(20),@fnNew varchar(20)
set @sql='if exists(select * from syscolumns where id=object_id(N''Assess'') and name=N'''+@fn+''')
sp_rename ''Assess.['+@fn+'']','''+@fnNew +''',''column'''
exec (@sql)
@fn varchar(20),@fnNew varchar(20)
as
declare @sql nvarchar(4000)
set @sql='if exists(select * from syscolumns where id=object_id(N''Assess'') and name=N'''+@fn+''')
exec sp_rename ''Assess.'+@fn+''','''+@fnNew +''',''column'''
exec (@sql)
@fn varchar(20),@fnNew varchar(20)
set @sql='if exists(select * from syscolumns where id=object_id(N''Assess'') and name=N'''+@fn+''')
sp_rename ''Assess.['+@fn+']'','''+@fnNew +''',''column'''
exec (@sql)
set @sql='if exists(select * from syscolumns where id=object_id(N''Assess'') and name=N'''+@fn+''')
sp_rename ''Assess.'+@fn+''','''+@fnNew +''',''column'''
Line 2: Incorrect syntax near 'sp_rename'.
@fn varchar(20),@fnNew varchar(20)
AS
Declare @sql Varchar(8000)
set @sql='if exists(select * from syscolumns where id=object_id(N''Assess'') and name=N'''+@fn+''')
exec sp_rename ''Assess.'+@fn+''','''+@fnNew +''',''column'''
exec (@sql)
GO