use ISMS
declare @code varchar(200)
declare @EmailContent varchar(200)
select @code=code,@EmailContent=EmailContent from SendEmail where SendEmailFlag='false'
select @code ,@EmailContent
查询结果:
1 zz 您好select code,EmailContent from SendEmail where SendEmailFlag='false'
查询结果:
1 zz 您好
2 GG 您好
请问查询语句中加入@code=code,@EmailContent=EmailContent 后查询结果是不是只有一个,如果我要查出所有的结果要怎么改呢,非常感谢.......
declare @code varchar(200)
declare @EmailContent varchar(200)
select @code=code,@EmailContent=EmailContent from SendEmail where SendEmailFlag='false'
select @code ,@EmailContent
查询结果:
1 zz 您好select code,EmailContent from SendEmail where SendEmailFlag='false'
查询结果:
1 zz 您好
2 GG 您好
请问查询语句中加入@code=code,@EmailContent=EmailContent 后查询结果是不是只有一个,如果我要查出所有的结果要怎么改呢,非常感谢.......
(
ID int IDENTITY (1,1) not null, --创建列ID,并且每次新增一条记录就会加1
code varchar(50),
EmailContent varchar(100)
);insert into #Tmp(code,EmailContent) select code,EmailContent from SendEmail where SendEmailFlag='false'
Select * from #Tmp