ето дает меня ошибка

declare @sql varchar(1000),@col varchar(20)='Name',@TableName varchar(100)='customers'
select @sql='insert into ' + @TableName + '('+@col+')'+'values(' + rtrim(cast(@col as nchar(20))) + ')'
exec  (@sql)

Msg 207, Level 16, State 1, Line 27
Invalid column name 'Name'.

print @sql

insert into customers(Name)values(Name)

create Procedure [dbo].[crud_operation]
	@TableName VarChar(100),
	@id int=null,
	@action int,@COL1 NVARCHAR(20)=null,@COL2 NVARCHAR(20)=null,@cval1 nvarchar(20)=null,@cval2 nvarchar(20)=null
AS

Declare @SQL VarChar(1000)
----simple select--
 
SELECT @SQL = case
 when (@action = 0 and @id is null) then  'SELECT * FROM ' + @TableName
 when (@action=0 and  @id is not null) then 'SELECT * FROM ' + @TableName +' '+ N'where id=' + rtrim(cast (@id as nchar(2)))
 else '' end 
print @sql
Exec ( @SQL)

exec dbo.crud_operation @TableName='customers',@action=0,@id=2

2	hbhb	mn nmnm

alter Procedure [dbo].[crud_operation]
	@TableName VarChar(100),
	@id int=null,
	@action int,@COL1 NVARCHAR(20)=null,@COL2 NVARCHAR(20)=null,@cval1 nvarchar(20)=null,@cval2 nvarchar(20)=null
AS

Declare @SQL VarChar(1000)
----simple select--
 
SELECT @SQL = case
 when (@action = 0 and @id is null) then  'SELECT * FROM ' + @TableName
 when (@action=0 and  @id is not null) then 'SELECT * FROM ' + @TableName +' '+ N'where id=' + rtrim(cast (@id as nchar(2)))
 when (@action=1 and @COL1 is not null and @COL2 is null) then 'insert into ' + @TableName + ' ' +'('+@COL1+')' + ' ' + 'select '+ ''''+@cval1+''''
 when (@action=1 and @COL1 is not null and @COL2 is not null) then
 'insert into ' + @TableName + '('+@COL1+','+@COL2 + ')' + ' ' + 'select '+ ''''+@cval1+'''' +','+''''+@cval2+''''
 else '' end 
print @sql
Exec ( @SQL)


insert into customers(Name,Country) select 'x','az'

(1 row(s) affected)

SELECT DATA_TYPE 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE 
     TABLE_NAME = 'customers' AND 
     COLUMN_NAME = 'Name'

DATA_TYPE
nvarchar

ALTER Procedure [dbo].[crud_operation]
	@TableName VarChar(100),
	@id int=null,
	@action int,@COL1 NVARCHAR(20)=null,@COL2 NVARCHAR(20)=null,@cval1 nvarchar(20)=null,@cval2 nvarchar(20)=null
AS

Declare @SQL VarChar(1000)
----simple select--
 
SELECT @SQL = case
 when (@action = 0 and @id is null) then  'SELECT * FROM ' + @TableName
 when (@action=0 and  @id is not null) then 'SELECT * FROM ' + @TableName +' '+ N'where id=' + rtrim(cast (@id as int))
----insert----
 when (@action=1 and @COL1 is not null and @COL2 is null) then 'insert into ' + @TableName + ' ' +'('+@COL1+')' + ' ' + 'select '+ ''''+@cval1+''''
 when (@action=1 and @COL1 is not null and @COL2 is not null) then
 'insert into ' + @TableName + '('+@COL1+','+@COL2 + ')' + ' ' + 'select '+ ''''+@cval1+'''' +','+''''+@cval2+''''
----delete----
   when(@action=2 and @id is not null) then
 'delete from ' + @TableName + ' ' + N'where id='+ rtrim(cast(@id as int))
----update ---
when (@action=3 and @id is not null and (@COL1 is not null and @COL2 is null))
   then 'update ' + @TableName + ' set ' +  @COL1 + '=' + @cval1 +' where id=' + rtrim(cast(@id as int)) 

else '' end
print @sql
Exec ( @SQL)

exec crud_operation @TableName='emin',@action=3,@id=1,@COL1='phone',@cval1='5'

exec crud_operation @TableName='emin',@action=3,@id=1,@COL1='phone',@cval1=5

update emin set phone=5 where id=1

(1 row(s) affected)
update emin set phone=5 where id=1

(1 row(s) affected)

[SRC PLSQL]
@COL1 NVARCHAR(20)=null,@COL2 NVARCHAR(20)=null,

и

@cval1 nvarchar(20)=null,@cval2 nvarchar(20)=null

when (@action=1 and @COL1 is not null and @COL2 is not null)

then
 'insert into ' + @TableName + '('+@COL1+','+@COL2 + ')' + ' ' + 'select '+ ''''+@cval1+'''' +','+''''+@cval2+''''

declare @test table (col1 nvarchar(max),col2 nvarchar(max)) 
declare @sql nvarchar(max),@tablename nvarchar(max)='nasa',@id nvarchar(max)='1',
@parm nvarchar(100)='3'
insert into @test(col1,col2)
values
('col1','00'),('col2','00'),('col3','00')
select * from @test

set @sql= 'update '  + QUOTENAME( @tablename) + NCHAR(10)+'set'+NCHAR(10)+
STUFF( (select ','+quotename(col1) +'='+ '''' + col2 +'''' + nchar(10) from @test for xml path('')),1,1,'')  
  SET @sql = @sql + N'WHERE ID =' + @parm;             
  
print @sql
exec (@sql)

@parm nvarchar(100)='3' -- okey, not bad

+ convert(nvarchar(max),nchar(10) from @test for xml path('')),1,1,''))  -- only in nvarchar(max)
  SET @sql = @sql + N'WHERE ID =' + convert(nvarchar(max),@parm); -- only in nvarchar(max)            

set @sql= 'update '  + QUOTENAME( @tablename) + NCHAR(10)+'set'+NCHAR(10)+
STUFF( (select ','+quotename(col1) +'='+ '''' + col2 +'''' + nchar(10) from @test for xml path('')),1,1,'')  
  SET @sql = @sql + N'WHERE ID =' + @parm;