点滴积累【other】---存储过程修改表的所有字段（sql）

USE [QG_Mis24]
GO
/****** Object:  StoredProcedure [dbo].[p_set]    Script Date: 07/11/2013 17:05:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
 ALTER procedure [dbo].[p_set]   
 as   
 declare tb cursor for  
 SELECT sql='alter table ['+d.name   +'] alter column bgdlx Varchar(64) '  
 FROM syscolumns a left join systypes b on a.xtype=b.xusertype  
 inner join sysobjects d on a.id=d.id and a.name like '%bgdlx%' and a.length =10    
 order by d.name,a.name   declare @sql varchar(1000)   
 open tb   fetch next from tb into @sql   while @@fetch_status = 0   
 begin   print @sql  
 exec(@SQL)  fetch next from tb into @sql   
 end   
 close tb   
 deallocate tb