世间的喧闹都是浮云，书中的宁静才是永恒！！！

use test set nocount on if object_id('Dept','U') is not null drop table Dept go create table Dept(ID int,ParentID int,Name varchar(20))   insert into Dept select 1,0,'AA' insert into Dept sel

select distinct * from ( select ijo_no,pmat_name,pmat_id=stuff((select '/'+pmat_id from (select * from @addTable ) a where a.ijo_no=b.ijo_no and a.pmat_name=b.pmat_name and a.qty=b.qty for xml path

select   request_session_id   spid,OBJECT_NAME(resource_associated_entity_id) tableName    from   sys.dm_tran_locks where resource_type='OBJECT'   ----spid   锁表进程 --tableName   被锁表名   --解锁：  

createfunction bin2dec(@svarchar(255) ) --二进制转化为十进制 returnsint as     begin         declare@iint, @tempchar(1), @resultint         select@i=1         select@result=0         while (@ilen(

IF EXISTS (SELECT * FROM SYSOBJECTS WHERE name='my_sp_test' AND TYPE='P') BEGIN     DROP PROCEDURE my_sp_test; END; GO create procedure my_sp_test @i int, @outstr varchar(100) out as