привет ребта
могу я получит сдес
@COL1 ,@COL2 ,@cval1 ,@cval2
из Arraylist автоматически?
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
ALTER Procedure [dbo].[crud_operation]
@TableName VarChar(100),
@id int=null,
@action int,@COL1 sysname=null,@COL2 sysname=null,@cval1 nvarchar(max)=null,@cval2 nvarchar(max)=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)
