03 2021 档案

• SqlServer-MERGE
  摘要：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 阅读(92) 评论(0) 推荐(0)
• SqlServer-TableDesc
  摘要：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 阅读(134) 评论(0) 推荐(0)
• SqlServer-NVARCHAR(32)转Guid
  摘要：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 阅读(148) 评论(0) 推荐(0)
• 存储过程-ParseJSON
  摘要：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 阅读(50) 评论(0) 推荐(0)

博客园  ©  2004-2026
浙公网安备 33010602011771号 浙ICP备2021040463号-3