文章分类 - SQL

摘要：if exists(select 1 from tempdb..sysobjects where id=object_id('tempdb..#tabName') and xtype='u')drop table #tabNamegocreate table #tabName(tabname var 阅读全文

posted @ 2021-03-26 16:18 ※繁星※ 阅读(829) 评论(0) 推荐(0)

SQL 游标foreach 表

摘要：declare @auid int,@aulname varchar(20),@aufname varchar(20), @st char(2),@auinfo varchar(50) declare auth_cur cursor for select tp_id, nvarchar19 from 阅读全文

posted @ 2016-07-02 21:19 ※繁星※ 阅读(361) 评论(0) 推荐(0)