2021年3月8日

摘要: IF EXISTS ( SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'Sync_SM_Supplier') AND OBJECTPROPERTY(id, N'IsProcedure') = 1 ) BEGIN DROP PROCEDURE Sync_ 阅读全文
posted @ 2021-03-08 14:36 eeeeeeeeeeeeeeee 阅读(60) 评论(0) 推荐(0) 编辑
摘要: IF EXISTS ( SELECT *FROM sysobjectsWHERE id = OBJECT_ID(N'TableDesc')AND OBJECTPROPERTY(id, N'IsProcedure') = 1 )BEGINDROP PROCEDURE TableDesc;END;GO 阅读全文
posted @ 2021-03-08 14:33 eeeeeeeeeeeeeeee 阅读(104) 评论(0) 推荐(0) 编辑
摘要: IF OBJECT_ID('ToGuid','FN') IS NOT NULL BEGIN DROP FUNCTION ToGuid;ENDGOCREATE FUNCTION ToGuid(@str NVARCHAR(32))RETURNS UNIQUEIDENTIFIERASBEGIN --DEC 阅读全文
posted @ 2021-03-08 14:32 eeeeeeeeeeeeeeee 阅读(126) 评论(0) 推荐(0) 编辑
摘要: CREATE FUNCTION [dbo].[parseJSON]( @JSON NVARCHAR(MAX))RETURNS @hierarchy TABLE ( element_id INT IDENTITY(1, 1) NOT NULL, /* internal surrogate primar 阅读全文
posted @ 2021-03-08 14:30 eeeeeeeeeeeeeeee 阅读(40) 评论(0) 推荐(0) 编辑