摘要：declare @data nvarchar(90)declare @data1 datetimebegin tryset @data=@data+1set @data1='dd'end trybegin catchprint 'hello'SELECT ERROR_NUMBER() AS Erro... 阅读全文

摘要：ALTER FUNCTION UFun_GetChildren(@ID nvarchar(60))RETURNS @tbChildren TABLE (ID varchar(60) )ASBEGIN WITH UFun_GetChildren(ID) AS ( SELECT OrganizationID FROM ECOrganization WHERE ParentOrganizationID=@ID UNION ALL SELECT OrganizationID FROM ECOrganization INNER JOIN UFun_GetChildren ON UFun_GetChil. 阅读全文