文章分类 -  SQL

摘要：CREATE TABLE member (idINTEGER PRIMARY KEYauto_increment,usernameVARCHAR(20)NOT NULL,passwordVARCHAR(20)NOT NULL,realnameVARCHAR(20)NULL,telVARCHAR(20)NULL,addressVARCHAR(100)NULL,zipVARCHAR(6)NULL,emailVARCHAR(50)NULL);CREATE TABLE orders (idINTEGERPRIMARY KEYauto_increment,ordernoVARCHAR(50)NOT NU 阅读全文

摘要：CREATE TABLE table1( [ID] [bigint] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](128) NOT NULL, [class] int not null, [date] datetime not null)/* */select id,name,class,date from(select id,name,class,date ,row_number() over(partition by class order by date desc)as rowindex from table1)awher... 阅读全文

摘要：declare @tb table(id int, code varchar(10), [values] int)insert @tb select1, 'a' , 2 union all select 2 , 'a' , 3 union all select 3 , 'a' , 3 union all select4 , 'b' , 1 union all select5 ,'b' , 4 union all select6 ,'b' , 4 select* from @tb twhe... 阅读全文

摘要：--第1个表CREATE TABLE [dbo].[t1]([id] [int] IDENTITY(1,1) NOT NULL,[name] [nvarchar](50) NULL,)--第2个表：CREATE TABLE [dbo].[t2]([id] [int] IDENTITY(1,1) NOT NULL,[t1_ID] [int] NULL,[bwin] [int] NULL,[dat] [datetime] NULL CONSTRAINT [DF_t2_dat] DEFAULT (getdate()),)--解决方案select t1.*,t2.id,t2.bwin,t2.datfr 阅读全文

摘要：Conceptual data typeDBMS-specific physical data typeContent Length Integer int / INTEGER32-bit integerShort Integersmallint / SMALLINT 16-bit integerLong Integerint / INTEGER32-bit integerByte tinyint / SMALLINT 256 values Number numeric / NUMBER Numbers with a fixed decimal point Fixed Decimal deci 阅读全文

摘要：View Code TSQL_生成表结构：/**//****** 对象: 表 [dbo].[LargeTable] 脚本日期: 2006-10-26 15:40:27 ******/if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[LargeTable]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[LargeTable]GO/**//****** 对象: 表 [dbo].[LargeTable 阅读全文

摘要：View Code % 包含零个或任意多个字符_(下划线) 单个字符[] 指定范围的单个字符(只占一个字符的位置)[^] 非(指定范围的单个字符)ESCAPE LIKE 的一个子句就先解释这些吧，，不明白的看例子。。... where fieldname like 'BUG%'//字符串字段中前三个字母带'BUG'的都是符合条件的记录//例:'BUGd','BUGdefg','BUG','BUG42'....... where fieldname like '%BUG'//字符串字段 阅读全文