--通用的增加存储过程
if exists (select * from sysobjects where name = 'usp_insert')
drop proc usp_insert
go
create proc usp_insert
(
@table nvarchar(255),
@values nvarchar(max)
)
as
declare @sql nvarchar(max)
set @sql = 'insert into ['+@table+'] values('+@values+')'
exec sp_executesql @sql
go
if exists (select * from sysobjects where name = 'usp_insert')
drop proc usp_insert
go
create proc usp_insert
(
@table nvarchar(255),
@values nvarchar(max)
)
as
declare @sql nvarchar(max)
set @sql = 'insert into ['+@table+'] values('+@values+')'
exec sp_executesql @sql
go
exec usp_insert 'customer','''Tom'',''132342434243'''