zhangjun06041的博客

USE [master]GO/****** Object: StoredProcedure [dbo].[p_lockinfo] Script Date: 2016-11-23 16:29:01 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO/*--处理死锁查看当前进程,或死锁进程,并能自动杀掉死进程因为是针对死锁的,所以如果有死锁进程,只能查看死锁进程当然,你可以通过参数控制,不管有没有死锁,都只查看死锁进程调用示例...

--SELECT ROW_NUMBER() OVER (ORDER BY FEntryID) AS FNO,FEntryID, (FAuxQty-FAuxCommitQty) AS FunQty INTO #SEOutStockEntry2016 FROM SEOutStockEntry WHERE finterid=3925--SELECT * FROM #SEOutStockEntry2016--insert INTO #SEOutStockEntry2016--SELECT 4,4,10..

第一：定义 @strsql SET @strsql='                INSERT INTO SEOrder            (FExSeorderNo,FExSeorderVal,FInterID,FBillNo,FBrNo,FTranType,FCancellation,FStatus,FDiscountType,Fdate,         

SELECT power(10,4)SELECT cast(power(10,4) as VARCHAR) --10000SELECT cast(power(10,4) as VARCHAR)+1 --100001select right(cast(power(10,4) as varchar)+1,4)