create table a( i tinyint, ii smallint, iii int ) insert into a values(1,11,111) insert into a values(2,11,111) insert into a values(3,11,111) insert into a values(4,18,111) insert into a values(7,81,111) create proc proc_my as exec('declare @n int select @n=count(*) from a print cast(@n as char(100))') exec proc_my 可以参考我的例题
i tinyint,
ii smallint,
iii int
)
insert into a values(1,11,111)
insert into a values(2,11,111)
insert into a values(3,11,111)
insert into a values(4,18,111)
insert into a values(7,81,111)
create proc proc_my
as
exec('declare @n int select @n=count(*) from a print cast(@n as char(100))') exec proc_my
可以参考我的例题