皓然星空的专栏

<br />select Row_number() over(order by rowname) from table1

--创建存储过程SET NOCOUNT ON;USE master;goIF OBJECT_ID('dbo.sp_perfworkload_trace_start') IS NOT NULL    DROP PROC dbo.sp_perfworkload_trace_start;GOCREATE PROC dbo.sp_perfworkload_trace_start

DECLARE @dbid AS INT, @traceid AS INT;SET @dbid = DB_ID('CCTTBR');--这里写数据库名EXEC dbo.sp_perfworkload_trace_start    @dbid       = @dbid,    @tracefile  =  'c:\temp\Perfworkloaf.trc',--这里写跟踪文件放在