farmwang的专栏

alter database AmazonDB set emergency 设定Test状态为紧急模式sp_dboption 'AmazonDB','single user','false' 设定数据库模式为"单一使用者"ALTER DATABASE AmazonDB SET EMERGENCYDBCC checkdb(AmazonDB)ALTER DATABASE AmazonDB SET SINGLE_USER WITH ROLLBACK IMMEDIATEDBCC CheckDB (.

sp_configure 'show advanced options', 1;RECONFIGUREGOsp_configure 'Agent XPs', 1;RECONFIGUREGODECLARE @daysleft intDECLARE @instancename sysnameSELECT @instancename = CONVERT(sysname, SERVE...

EXEC sp_rename 'Menu.group' , 'batch'增加列alter table Menu add batch varchar(30) alter table Menu alter column batch varchar(4000) 3.删除列：alter table Menu drop column batch ...

create table TT(tablename nvarchar(128),columnname nvarchar(128),columndata nvarchar(max)); use MES; --使用数据库declare @t11 varchar(50) declare @c1 varchar(50) declare @b1 varchar(10)declare...

SELECT * FROM INFORMATION_SCHEMA.TABLESselectsys.schemas.name, sys.objects.namefrom sys.objects,sys.schemaswhere sys.objects.type='U'and sys.objects.schema_id=sys.schemas.schema_id

CREATE TABLE "t6" ( "AuftrREFID" VARCHAR(50) NULL DEFAULT NULL, "Auftr_ID" VARCHAR(50) NULL DEFAULT NULL); CREATE TABLE "t3" ( "Auftr_ID" VARCHAR(50) NULL DEFAULT NULL, "auftrrefid" VARCH

SQL SERVER 提供了一些时间函数：取当前时间：select getdate()取前一个月的时间：SELECT DATEADD(MONTH,-1,GETDATE()) 月份减一个月取年份：SELECT YEAR( DATEADD(MONTH,-1,GETDATE())),Year 取年份取月份：SELECT MONTH( DATEADD(MONTH,-1,GETDATE())) ，month...

concat()函数  --用于将多个字符串连接起来，形成一个字符串 update form_approve set status='HOLD',memo=CONCAT(memo,' --- ',' 群群群') where form_id='18041513551556358' and approve_id='pd100' and seq=100...

比如最常见的USER作为表名，用SQL语句“select * from USER”查询就会出现如下错误：在关键字 'USER' 附近有语法错误 可以用[ ]避免出现这样的错误，即：将SQL语句改正这样“select * from [USER]”...

create table TT(tablename nvarchar(128),columnname nvarchar(128),columndata nvarchar(max)); use test; --使用数据库declare @t11 varchar(50) declare @c1 varchar(50) declare @b1 varchar(10)declar...

CREATE TABLE "form_pd300item" ( "refid" bigint identity(1,1) not null, "form_id" VARCHAR(20) NULL DEFAULT NULL, "item" VARCHAR(20) NULL DEFAULT NULL, "item_desc" NVARCHAR(100) NULL DEFAULT NU...

with a as(select distinct pcode,matid,matgroup,matmemo from ps where matgroup like 'B01%' ), b as ( select distinct pcode,matid,matgroup,matmemo from ps where matgroup like 'H0%'), c as (selec...

 ELECT * FROM 表 WHERE CONVERT(Nvarchar, dateandtime, 111) = CONVERT(Nvarchar, GETDATE(), 111)   ORDER BY dateandtime DESC本月记录SELECT * FROM 表 WHERE datediff(month,[dateadd],getdate())=0本周记录SELECT * FRO...

with a as ( select orderid,matid,matgroup from ps1 where matgroup like 'B01%' ), b as ( select orderid,matid,matgroup from ps1 where matgroup like 'H0%' ), c as ( select orderid,matid,mat...

exec sys.sp_readerrorlog 0, 1, 'listening'