if else:
if(1=1) begin--必须1个=号
print '111'--begin end 之间必须要有内容
end else begin
print '222'
end
while:
DECLARE @i INT
set @i=1
while (@i<=@count) BEGIN
print 'I love U'+CONVERT(varchar,@i);
set @i=@i+1;
END
if else:
if(1=1) begin--必须1个=号
print '111'--begin end 之间必须要有内容
end else begin
print '222'
end
while:
DECLARE @i INT
set @i=1
while (@i<=@count) BEGIN
print 'I love U'+CONVERT(varchar,@i);
set @i=@i+1;
END