摘要:
SET QUOTED_IDENTIFIER ONSET ANSI_NULLS ONGOcreate proc spDropColumn @tbname sysname, --要处理的表名 @fdname sysname, --要处理的字段名 @delfield bit=1 --0只删除关系,1同时删 阅读全文
摘要:
根据用户id查询所有时间 1 CREATE TABLE [dbo].[esService_WeiXinNew_Check] 2 ( 3 [fldGuid] [uniqueidentifier] NOT NULL PRIMARY KEY, 4 [fldCheckTime] [smalldatetime 阅读全文
摘要:
行转列不留空 SELECT 'A' AS [订单号],'四川' AS [地址] INTO #Result INSERT INTO #Result SELECT 'A' AS [订单号],'成都' AS [地址] UNION ALL SELECT 'B' AS [订单号],'新疆' AS [地址] U 阅读全文