摘要:
IF EXISTS ( SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'Sync_SM_Supplier') AND OBJECTPROPERTY(id, N'IsProcedure') = 1 ) BEGIN DROP PROCEDURE Sync_ 阅读全文
摘要:
IF EXISTS ( SELECT *FROM sysobjectsWHERE id = OBJECT_ID(N'TableDesc')AND OBJECTPROPERTY(id, N'IsProcedure') = 1 )BEGINDROP PROCEDURE TableDesc;END;GO 阅读全文
摘要:
IF OBJECT_ID('ToGuid','FN') IS NOT NULL BEGIN DROP FUNCTION ToGuid;ENDGOCREATE FUNCTION ToGuid(@str NVARCHAR(32))RETURNS UNIQUEIDENTIFIERASBEGIN --DEC 阅读全文
摘要:
CREATE FUNCTION [dbo].[parseJSON]( @JSON NVARCHAR(MAX))RETURNS @hierarchy TABLE ( element_id INT IDENTITY(1, 1) NOT NULL, /* internal surrogate primar 阅读全文