sqlserver 测试

CREATE TABLE [dbo].[school_new](

[id] [int] NOT NULL primary key identity(1,1),

[name] [nchar](20) NOT NULL,

[address] [varchar](500) NOT NULL,

[createdTime] [datetime] NOT NULL default getdate()

)

insert into school_new(name,address,createdTime)

select name,address,createdTime from school

--删除外键

alter table class drop constraint class_school_id

drop table school

--修改表名从school_new 改为school

exec sp_rename 'school_new','school'

alter table class add constraint class_school_id foreign key(schoolid) references school(id)

--查询服务名称

select @@servername

select @@spid

select @@version

select @@textsize

select @@NESTLEVEL

select @@OPTIONS

--查询当前日期对应的月份

select month(getdate())

select Day(GETDATE())

select getutcdate()

select * from class

--字符串分割

select value from string_split('fdaf-sdfsd_dfd_sdfas','_')

select value from string_split('r432!@dfdf@erfwe334@32','@')

--字符串切片

select Substring('fdaf-sdfsd_dfd_sdfas',1,3)

--字符串替换

select stuff('ffdaf-sdfsd_dfd_sdfas',1,2,'aaa')