|
发表于 2019-7-19 14:57:51
|
显示全部楼层
可以用存储过程封装,
- --创建表1含有[字段]
- createtable表1(字段varchar(10))
- --创建存储过程
- createprocdbo.sp20190719
- as
- begin
- INSERTINTO表1(字段)VALUES('123')
- end
- --删除表1,重建表1,[字段]改名为[字段x]
- droptable表1
- createtable表1(字段xvarchar(10))
- --测试
- BEGINTRY
- BEGINTRAN
- execdbo.sp20190719
- COMMITTRAN;
- ENDTRY
- BEGINCATCH
- SELECTERROR_MESSAGE()ASErrorMessage,ERROR_SEVERITY()ASErrorSeverity,ERROR_STATE()ASErrorState,@@ROWCOUNTasROWCOUNTs,error_number()asnumber
- ENDCATCH
- /*
- ErrorMessageErrorSeverityErrorStateROWCOUNTsnumber
- -----------------------------------------------------------------------------
- Invalidcolumnname'字段'.1610207
- (1行受影响)
- */
复制代码 |
|