我想我是海 冬天的大海 心情随风轻摆

USE tempdbGOIF OBJECT_ID('dbo.[t]') IS NOT NULL DROP TABLE dbo.[t]GOCREATE TABLE dbo.[t]([c1] VARCHAR(10),[c2] INT,[c3] VARCHAR(50) )GOSET NOCOUNT ONINSERT INTO dbo.[t] VALUES(N'A',N'1',N'A,B,C')INSERT INTO dbo.[t] VALUES(N'B',N'2',N'A,B')I.

--年月日星期 对照表IF OBJECT_ID('DimDateStartWithMonday') IS NOT NULL DROP TABLE DimDateStartWithMondayGOCREATE TABLE DimDateStartWithMonday( DateKey INT PRIMARY KEY, FullDate DATE NOT NULL, [DateName] NVARCHAR(20).

原贴：点击打开链接USE tempdbGOIF OBJECT_ID('view_test') IS NOT NULL DROP VIEW view_testGOIF OBJECT_ID('father') IS NOT NULL DROP TABLE fatherIF OBJECT_ID('sub') IS NOT NULL DROP TABLE subGOCREATE TABLE...

DECLARE @a VARCHAR(10)='aa',@b VARCHAR(10)='b'SET @a+=@b;SET @b=LEFT(@a,LEN(@a)-LEN(@b))SET @a=RIGHT(@a,LEN(@a)-LEN(@b))SELECT @a AS aValue ,@b AS bValue

--相邻的记录只保留一个USE tempdbGOIF OBJECT_ID('tb1') IS NOT NULL DROP TABLE tb1GOCREATE TABLE tb1( n NVARCHAR(10) )GOINSERT INTO tb1 VALUES (1),(1),(2),(3),(3),(1),(1);WITH t AS ( SELECT ROW_NUMBER...

--获取某个表插入时必须要的字段DECLARE @tableName NVARCHAR(200)SET @tableName='BuyApply' --替换实际表名;WITH cte AS (SELECT c.name AS colName FROM sys.columns c WHERE c.[object_id]=OBJECT_ID(@tableName)AND c.is_null

相关贴子：点击打开链接--1. 材料表--2. 产品表--3. 产品材料中间表--4. 属性表--5. 材料属性中间表USE tempdbGOIF OBJECT_ID('material_data') IS NOT NULL DROP TABLE material_dataIF OBJECT_ID('product_data') IS NOT NULL DROP TABLE p

USE tempdbGOIF OBJECT_ID('t') IS NOT NULLDROP TABLE tGOCREATE TABLE t(id INT,[time] DATETIME,num1 INT)INSERT INTO tSELECT 9,'2018-02-09 15:55:40',3UNION ALL SELECT 8,'2018-02-08 15:55:26',1UN

USE tempdbGOIF OBJECT_ID('t1') IS NOT NULL DROP TABLE t1IF OBJECT_ID('t2') IS NOT NULL DROP TABLE t2GOCREATE TABLE t1(uno VARCHAR(20),uname NVARCHAR(20))CREATE TABLE t2(uno VARCHAR(20),uname NVA

USE tempdbGOIF OBJECT_ID('v_t') IS NOT NULL DROP VIEW v_t;IF OBJECT_ID('t') IS NOT NULL DROP TABLE t;GOCREATE TABLE t(id INT IDENTITY(1,1) PRIMARY KEY,n NVARCHAR(20) )INSERT INTO t(n)VALUES(

-------- 创建测试库及测试表 ----------USE [master]GO--创建测试库IF EXISTS(SELECT 1 FROM sys.databases AS d WHERE d.name='db1') DROP DATABASE db1GOIF EXISTS(SELECT 1 FROM sys.databases AS d WHERE d.name='db2'

USE tempdbGOIF OBJECT_ID('t') IS NOT NULL DROP TABLE tGOCREATE TABLE t( id INT IDENTITY(1,1) PRIMARY KEY, c1 INT, c2 int )GODECLARE @sql NVARCHAR(MAX)SELECT @sql=STUFF( ( SELECT ','+c.n...

drop table if exists t;CREATE TABLE t ( id int NOT NULL AUTO_INCREMENT, `d` datetime NOT NULL, PRIMARY KEY (`id`));INSERT t (d) values('2018-08-09 18:06');INSERT t (d) values('2018-08-09 20...

USE tempdbGOIF OBJECT_ID('t') IS NOT NULL DROP TABLE tGOCREATE TABLE t( id INT IDENTITY(1,1) PRIMARY KEY, buyer NVARCHAR(10), goods NVARCHAR(10))GOINSERT INTO t VALUES ('A商','橘子')INSERT IN...

原贴：  https://bbs.youkuaiyun.com/topics/392489035?page=1#post-403595581USE tempdbGOIF OBJECT_ID('t') IS NOT NULL DROP TABLE tGOCREATE TABLE t( id INT IDENTITY(1,1) PRIMARY KEY, [name] NVARCHAR(10) N...

USE tempdbGOIF OBJECT_ID('dbo.[t]') IS NOT NULL DROP TABLE dbo.[t]GOCREATE TABLE dbo.[t]([id] NVARCHAR(MAX),[areaname] NVARCHAR(MAX),[postcode] NVARCHAR(MAX),[iParent] NVARCHAR(MAX) )GOS...

USE tempdbGOIF OBJECT_ID('Student') IS NOT NULL DROP TABLE StudentIF OBJECT_ID('Course') IS NOT NULL DROP TABLE CourseIF OBJECT_ID('Scores') IS NOT NULL DROP TABLE ScoresGOCREATE TABLE Student(...

USE tempdbGOIF OBJECT_ID('t') IS NOT NULL DROP TABLE tGOCREATE TABLE t( id VARCHAR(50) PRIMARY KEY, uname NVARCHAR(20) )GOINSERT INTO t VALUES ('2018041A1243HS001','a')INSERT INTO t VALUES ...

相关贴子：https://bbs.youkuaiyun.com/topics/392472876 USE tempdbGOIF OBJECT_ID('t') IS NOT NULL DROP TABLE tGOCREATE TABLE t( ID INT ,姓名 NVARCHAR(10) ,语文 NVARCHAR(10) ,数学 NVARCHAR(10) ,物理 NVARCHAR(10...

USE tempdbGO--测试数据if not object_id(N'Employee') is null drop table EmployeeGoCreate table Employee([EId] nvarchar(23),[Name] nvarchar(23),[Sex] nvarchar(21),[Depart] int)Insert Employeesel...

EXEC sp_MSforeachdb 'if "?" not in (''master'',''tempdb'',''model'',''msdb'',''distribution'') BEGINDECLARE @search NVARCHAR(200),@sql NVARCHAR(MAX)SET @search=''广东'' --自己修改DECLARE @t TABLE ( ...

相关贴子： https://bbs.youkuaiyun.com/topics/392447008 use tempdbgoIF Object_ID('mainT') is not null drop table mainTIF Object_ID('subT') is not null drop table subTgoCREATE TABLE mainT( id INT IDENTITY...

相关贴子：https://bbs.youkuaiyun.com/topics/392439957状态字段，一般是单纯的，但如果有复合的状态怎么办？比如考勤，一个人一天之中，既有迟到，又有早退，那如何设计这个状态字段？用户考勤，共 6种状态：--userState：--1 出勤 1--2 请假 10--4 公差 100--8 迟到 ...

USE tempdbGOIF OBJECT_ID('t') IS NOT NULL DROP TABLE tGOCREATE TABLE t(addTime DATETIME2)GOIF OBJECT_ID('proc_test') IS NOT NULL DROP PROC proc_testGOCREATE PROC proc_testASBEGIN SET NOCOUN

原贴：点击打开链接--注：需要 SQL Server2012 或以上版本才能运行USE tempdbGOIF OBJECT_ID('t') IS NOT NULLDROP TABLE tGOCREATE TABLE t( 月份 int ,投资代码 NVARCHAR(20) ,利息收益日期 datetime ,利息收益 int)GOIN

-------------- 测试表 Begin ------------------这里的测试库为 tempdb--弄清楚之后，修改相关代码，再上正式生产环境操作USE tempdbGOIF EXISTS(SELECT * FROM sys.triggers AS t WHERE t.name='TR_Safety_Table')BEGIN DROP TRIGGER TR_Safe

今天在坛子里发现一个很有意思的贴子： 点击打开链接如上图所示，【需求数量】不变，【已满足数量】按照从序号大到小的顺序，从最小的【序号】中取值，使其等于【需求数量】举个例子：比如物料号为1的，有三条记录：分别是序号1、3、4，序号4的【已满足数量】比【需求数量】少了1，则从序号1【已满足数量】中取出1 给序号4，序号1的【已满足数量】变为11，序号4的【已满足数量】变为5；2、序

USE [master]GO--1. 创建测试库CREATE DATABASE [test] CONTAINMENT = NONE ON PRIMARY ( NAME = N'test', FILENAME = N'D:\database\2014\test.mdf' , SIZE = 8192KB , FILEGROWTH = 8192KB ) LOG ON ( NAME =

原贴：点击打开链接如何实现查询29条记录然后分别使用1-6条的记录，取平均值对应一个值，2-7条记录对应一个值，3-8等等这样的规律一直取24个值。也就是最后取到24-29条记录平均后的值，。求分享-------------------- 构建测试表和测试数据 BEGIN -------------------------之所以长是因为需要构建一批随机记录，如果你有现成的表可以省去这

---------------- 测试表及视图 BEGIN ----------------USE tempdbGOIF OBJECT_ID('dbo.t') IS NOT NULLDROP TABLE dbo.tGOCREATE TABLE dbo.t(id INT PRIMARY KEY,userName NVARCHAR(20))GOIF OBJECT_ID('dbo.vie

USE tempdbGOIF OBJECT_ID('t1') IS NOT NULL DROP TABLE t1IF OBJECT_ID('t2') IS NOT NULL DROP TABLE t2CREATE TABLE t1(c1 INT,c2 NVARCHAR(60))CREATE TABLE t2(c1 INT,c2 VARCHAR(50));WITH cte AS (S

--1. 创建随机视图 view_randif object_id('view_rand') is not nullbegin drop view view_randendgocreate view view_randas select rand() as [r]GO--2. 创建随机分割的表值函数IF OBJECT_ID('dbo.Fun_Random') IS NOT

DECLARE @t TABLE ( id INT PRIMARY KEY, n INT)INSERT INTO @t (id,n) VALUES (2,10),(3,12),(5,13),(7,14),(8,15)SELECT * FROM @tDECLARE @v INTSET @v = 30;WITH t AS(SELECT ROW_NUMBER() OVER (ORDE

DECLARE @tmp TABLE (id INT,plate VARCHAR(20),time DATETIME,speed INT)INSERT INTO @tmp(id,plate,TIME,speed) VALUES(4,'武装巡逻01','2014-11-05 14:29:06.000',0)INSERT INTO @tmp(id,plate,TIME,speed) VALUES(

DECLARE @user TABLE( userId BIGINT, userName NVARCHAR(20), positionIds VARCHAR(1000))DECLARE @position TABLE ( positionId BIGINT, positionName NVARCHAR(20))SET NOCOUNT ONINSERT INTO @user (u

原题：点击打开链接题目是人家的，　答案是自己做的。SET NOCOUNT ONCREATE TABLE STUDENT( SNO VARCHAR(3) NOT NULL, SNAME VARCHAR(4) NOT NULL, SSEX VARCHAR(2) NOT NULL, SBIRTHDAY DATETIME, CLASS VARCHAR(5))goCR...

题目来自: 点击打开链接下面是本人的答案：--一下语句中用到的表tb均指这个测试表--1、你猜下面这条语句能得到什么结果，这个很常用if object_id('tb') is not nulldrop table tbgo select getdate()create table tb(id int identity ,name varchar(10))insert into

-- ------------------------------ Table structure for sys_area_2017-- ----------------------------IF OBJECT_ID('sys_area_2017') IS NOT NULLDROP TABLE sys_area_2017GO--全国行政区划-省市县三级(2017版)CREATE

原贴：点击打开链接USE tempdbGOIF OBJECT_ID('dbo.a') IS NOT NULL DROP TABLE dbo.aIF OBJECT_ID('dbo.b') IS NOT NULL DROP TABLE dbo.bCREATE TABLE a(deviceId INT ,beginTime TIME,endTime TIME)CREATE TABLE b(

原贴：点击打开链接USE tempdbGOIF OBJECT_ID('tempdb..#temp') IS NOT NULL DROP TABLE #tempcreate table #temp(name1 varchar(10),name2 varchar(10),cnt int)SET NOCOUNT ONinsert into #temp values('A','B',