22,207
社区成员
发帖
与我相关
我的任务
分享
create table loginlog(loginid int)
insert into loginlog values(27)
insert into loginlog values(28)
go
create proc SelectLoginLog
@intext nvarchar(300)
as
declare @sqltext as nvarchar(300)
set @sqltext='select * from loginlog '
exec (@sqltext+@intext)
go
exec SelectLoginLog ' where loginId in(27,28)'
drop table loginlog
drop proc SelectLoginLog
/*
loginid
-----------
27
28
(所影响的行数为 2 行)
*/