Éú³É²ÎÊýSQL . ˳±ãÉ¢·Ö.

×î½üÓÃintraWeb,  ºÜ¶à·½Ê½ÒªÓô«²Î·½Ê½.¸ÕûÊÂ,дÁËÒ»¸öÍæ.  Ï£ÍûÓÐÓÃ.  ˳±ãÉ¢·Ö

SQL code:



--select * from KcbWebRegMast

execute PR_GetParaSql 'KcbWebRegMast'

if Exists (select 1 from sysobjects where xtype = 'P' And name = 'PR_GetParaSql')
drop procedure dbo.PR_GetParaSql
go
Create procedure dbo.PR_GetParaSql @TableName Sysname
as begin

declare @FieldName sysname
declare @SqlStr varchar(4000)
declare @SqlPar Varchar(4000)

--set @tablename = 'KcbWebRegMast'
Set NoCount on

set @SqlStr = 'Insert into '+LTRIM(rtrim(@TableName))+'('
set @SqlPar = 'Values ('

declare cur_tmp cursor local for
select name from syscolumns where id = OBJECT_ID(@tableName)
open cur_tmp
while (1=1)
begin
fetch next from cur_Tmp into @FieldName
if @@FETCH_STATUS <> 0 break
set @SqlStr = @SqlStr + LTRIM(rtrim(@fieldName))+','
set @SqlPar = @SqlPar + ':'+LTRIM(rtrim(@FieldName))+','
end
close cur_tmp
deallocate cur_tmp
print substring(@sqlstr,1,len(@sqlstr)-1)+') '+
substring(@sqlPar,1,len(@sqlPar)-1)+')'
end

---

1

---

2

---

3

---

jf

---

ѧϰһÏ£¬Ë³±ã²ä·Ö

---

mark

---

Insert into @TableName
(ËùÓÐ×Ö¶Î)
values
(:ËùÓÐ×Ö¶Î)

---

ÒýÓÃ

Insert