搁浅的博客

BEGIN begin tran begin try 这里写入业务代码 if(@@ERROR=0) commit tran else rollback tran end try begin catch rollback tran end catchEND

一、SqlServer 代码USE[数据库名称]GO/******Object:UserDefinedFunction[dbo].[Base64StrDecode]ScriptDate:2020/4/716:57:00******/SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATEFUNCTION[dbo].[Base64StrDecode](@Base64Strvarchar(max))RETURNs...

SELECTA.name AS table_name,B.name AS column_name,C.value AS column_descriptionFROM sys.tables AINNER JOIN sys.columns B ON B.object_id = A.object_idLEFT JOIN sys.extended_properties C ON C.major_id = B.object_id AND C.minor_id = B.column_idWHEREA..