-
-
-
-
declare @a int
-
set @a=12
-
if @a>100
-
begin
-
print @a
-
end
-
else
-
begin
-
print 'no'
-
end
-
-
-
-
declare @i int
-
set @i=1
-
while @i<30
-
begin
-
insert into test (userid) values(@i)
-
set @i=@i+1
-
end
-
-
-
-
-
-
-
-
-
-
select * into #csj_temp from csj
-
-
-
begin try
-
drop table #csj_temp
-
end try
-
-
begin catch
-
end catch
-
-
-
-
-
-
-
declare @temp_temp int
-
-
-
-
DECLARE aaa CURSOR for select House_Id from House_House where Deleted=0 or deleted is null
-
-
Open aaa
-
-
-
fetch next from aaa into @temp_temp
-
-
while @@fetch_status=0
-
begin
-
-
select * from House_monthEnd where House_Id=@temp_temp
-
-
fetch next from aaa into @temp_temp
-
-
-
end
-
-
-
Close aaa
-
-
Deallocate aaa
-
|