????????????(Transaction)
???????????????????????и???????????????????е??(unit)--???????sql????????????????????????
??????Щsql??????????????????????????????С??????????
?????????裺
???????????BEGIN TRANSACTION
????????????COMMIT TRANSACTION
????????????ROLLBACK TRANSACTION
?????ж?????????????????
??????????@@ERROR??
????@@ERROR????ж??????T-SQL??????????д??????ж???????????T-SQL???????д?????????????????????
????????SET @errorSum=@errorSum+@@error
?????洢????---????????????з???(????)
??????C#?????????????洢??????/?洢??????????/?????з???????
??????????if else/while/???? ???????????洢?????????
???????
?????????????
??????????黯???????
??????????????
?????????????????
???????洢????
???????????壬?????master???????
??????????“sp_”?????”xp_”???
?????????洢????
??????????????????????д?????洢????
???????洢????
???????
????sp_databases
?????г???????????????????
????sp_helpdb
?????????й???????????????????????
????sp_renamedb
??????????????????
????sp_tables
??????????????????????????б?
????sp_columns
????????????е????
????sp_help
???????????????????
????sp_helpconstraint
???????????????
????sp_helpindex
????????????????
????sp_stored_procedures
?????г?????????е????д洢?????