zwei1121

博客园 首页 新随笔 联系 订阅 管理

04 2009 档案

摘要:alter table SendMailListadd key_col int not null identity(1,1)godelete from SendMailListwhere exists(select * from SendMailList as t2where t2.EMail=SendMailList.EMailand t2.key_col>SendMailList.key_co... 阅读全文
posted @ 2009-04-24 17:40 zwei 阅读(141) 评论(0) 推荐(0)

摘要:declare @t varchar(555),@c varchar(555) ,@inScript varchar(8000) set @inScript='' declare table_cursor cursor for select a.name,b.name from sysobjects a,syscolumns b where a.id=b.id and a.xtype='u' an... 阅读全文
posted @ 2009-04-08 15:37 zwei 阅读(176) 评论(0) 推荐(0)