if exists (select * from ConfigSystem where FullId='00000' and ConfigContent>'6.1.0.0')
goto Table6101
go
delete table temp1
go
delete table temp2
go
Table6101:
请问上面的语句怎么实现,不能去除GO语句
...全文
20515打赏收藏
邹建请回答
if exists (select * from ConfigSystem where FullId='00000' and ConfigContent>'6.1.0.0') goto Table6101 go delete table temp1 go delete table temp2 go Table6101: 请问上面的语句怎么实现,不能去除GO语句
if exists (select * from ConfigSystem where FullId='00000' and ConfigContent>'6.1.0.0')
Begin
...
End
Else
Begin
Drop table temp1 --你是要删除表还是删除数据?? 删除数据的话,用Delete from temp1
Drop table temp2
End
...
GO