FuncDropColumn（为表删除某字段）

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

自动侦测表中有没有该字段，既可以避免删除出错，也可以提高程序的灵活性。

/*
author:nyb
time  :2003/12/29
fixtime :
aim   :看表中是否有这个字段，如果有，删除
input :
调用：

executeFuncDropColumn'PSZ31','Z31No'
*/
CREATE  PROCEDUREFuncDropColumn
@tablename varchar(128),--表名
@Columnnamevarchar(128)--列名

as
set@tablename=ltrim(rtrim(@tablename))
set@Columnname=ltrim(rtrim(@Columnname))

declare@stringvarchar(8000)

IF EXISTS(select*fromsyscolumnswhereid=object_id(@tablename)andname=@Columnname)
begin
select @string =' ALTER TABLE'+@tablename+'DROPCOLUMN ['+ltrim(rtrim(@Columnname)) +']'
print@string
execute(@string)
end

 


GO

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>