sqlserver
changlong3158
这个作者很懒,什么都没留下…
展开
-
sql server 存储过程返回table
CREATE PROCEDURE RETURN_TABLE_TEST AS BEGIN SELECT id,name,comment INTO #TEMP FROM table1 WHERE createtime>='2014-01-01' SELECT * FROM #TEMP END -------------------------------------原创 2014-04-01 17:25:22 · 3488 阅读 · 0 评论 -
sql 字符串合并类似行转列(指定字段的行结果合并成字符串)
CREATE TABLE temp1(typeid int,NAME NVARCHAR(30)); INSERT INTO temp1 values(1,'张三'); INSERT INTO temp1 values(1,'李四'); INSERT INTO temp1 values(1,'王五'); INSERT INTO temp1 values(1,'赵六'); INSERT IN原创 2014-11-07 11:30:16 · 592 阅读 · 0 评论 -
SQL SERVER2008 自动生成索引
DECLARE @IX TABLE(index_handle INT,eq NVARCHAR(4000),included_columns NVARCHAR(4000),NAME VARCHAR(100),dbname VARCHAR(30)) ;WITH idx AS( SELECT a.index_handle ,a.equality_columns,a.inequality_column原创 2015-10-19 15:54:04 · 1170 阅读 · 0 评论 -
sql server 索引优化相关
----------------索引碎片 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SELECT DB_NAME() AS DatbaseName , SCHEMA_NAME(o.Schema_ID) AS SchemaName , OBJECT_NAME(s.[object_id]) AS TableName , i.转载 2015-10-19 15:57:51 · 359 阅读 · 0 评论