UDWORLD的博客

SQLServer数据库PIVOT行转列用法

SQL Server数据库配置自动备份

USE[master] GO ALTER DATABASE [DataBase] SET RECOVERY SIMPLE WITH NO_WAIT GO ALTER DATABASE [DataBase] SET RECOVERY SIMPLE --简单模式 GO USE [DataBase] GO DBCC SHRINKFILE (N'DataBase_log' , 2, TRUNCATEONLY) --设置压缩后的日志大小为2M，可...

查询数据总条数SQLSELECT SUM (ROWS) [总条数]FROM ( SELECT a.name, b. ROWS FROM sysobjects AS a INNER JOIN sysindexes AS b ON a.id = b.id WHERE (a.type = 'u') AND (b.indid IN(0, 1)) ) a;查询空间占用情况sp_spaceused ;...

select * from table_A where 1=1 AND PATINDEX('%[^0-9|.|-|+]%',clo) = 0 AND ISNUMERIC(clo) = 1 AND len(cloD)<=20 AND ISNULL(clo,'')<>'/' AND ISNULL(clo,'') not like '%-%'

SELECT FSX,TYPE,VAL FROM ( SELECT TYPE, VAL FROM (SELECT FXY1,FXY2from TABLE_A EVALEFT JOIN TABLE_B ENT ON EVA.SP_ID = ENT.idLEFT JOIN TABLE_C JBXX ON JBXX.ID = ENT.enterIdWHERE EVA.delFlag = 0 AND EVA.SJZT = 2 ) AS A UNPIVOT ( VAL FOR TYPE IN (.

select * from (select count(id) cont1 from table_a where delflag = 0 ) aFULL JOIN (select count(id) cont2 from table_b where delflag = 0) b on 1=1FULL JOIN (select count(id) cont3 from table_c where delflag = 0 ) c on 1=1