SQL
king_idea8848
这个作者很懒,什么都没留下…
展开
-
My SQL Toolkit
--************************耗时>***************************************DBCC DROPCLEANBUFFERS declare @timediff datetime select @timediff=getdate()--some statementsselect 耗时=datediff(ms,@time原创 2009-10-14 11:37:00 · 471 阅读 · 0 评论 -
My Partition SQL
--添加文件组和文件,确定目录[c:/SQLDataPart]/[d:/SQLDataPart]已存在/*if exists(select 1 from sys.sysfiles where name=Exam99) alter database EventExam remove file Exam99if exists(select 1 from sys.filegro原创 2009-11-12 13:53:00 · 394 阅读 · 0 评论 -
My Paging SQL
/************************ PageByTopMax************************/ IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID ( N[dbo].[PageByTopMax] ) AND type in ( NP , NPC )) DR原创 2009-11-12 22:31:00 · 614 阅读 · 0 评论 -
ExportData4Mssql
CREATE PROCEDURE dbo.OutputData @tablename sysname AS declare @column varchar(1000) declare @columndata varchar(1000) declare @sql varchar(4转载 2014-08-15 13:23:46 · 739 阅读 · 0 评论