随笔分类 -  sql server

sql查询连续签到时间数
摘要：根据用户id查询所有时间 1 CREATE TABLE [dbo].[esService_WeiXinNew_Check] 2 ( 3 [fldGuid] [uniqueidentifier] NOT NULL PRIMARY KEY, 4 [fldCheckTime] [smalldatetime 阅读全文
posted @ 2020-04-23 16:24 菜鸟级程序猿 阅读(1155) 评论(0) 推荐(0)
sql实现行转列
摘要：行转列不留空 SELECT 'A' AS [订单号],'四川' AS [地址] INTO #Result INSERT INTO #Result SELECT 'A' AS [订单号],'成都' AS [地址] UNION ALL SELECT 'B' AS [订单号],'新疆' AS [地址] U 阅读全文
posted @ 2018-09-20 11:41 菜鸟级程序猿 阅读(5272) 评论(0) 推荐(0)
删除sql数据库列存储过程包括关系
摘要：SET QUOTED_IDENTIFIER ONSET ANSI_NULLS ONGOcreate proc spDropColumn @tbname sysname, --要处理的表名 @fdname sysname, --要处理的字段名 @delfield bit=1 --0只删除关系,1同时删 阅读全文
posted @ 2017-10-10 11:50 菜鸟级程序猿 阅读(256) 评论(0) 推荐(0)