生成SQL语句字符串,通过存储过程执行
摘要:
/*使用游标,临时生成Sql语句*/DECLARE mealcursor CURSOR FOR Select * From T_MealOrderAutodeclare @count as intdeclare @sqlstr as nvarchar(4000)/*长度最大,如果太长会出错*/declare @id as int /*set @sqlstr = ''Create table T_I... 阅读全文
posted @ 2005-07-13 17:28 蒜头 阅读(1459) 评论(0) 推荐(0) 编辑