Sqlserver
无名1949
这个作者很懒,什么都没留下…
展开
-
SqlServer 中实现表的树形结构排序
use testset nocount onif object_id('Dept','U') is not nulldrop table Deptgocreate table Dept(ID int,ParentID int,Name varchar(20)) insert into Dept select 1,0,'AA' insert into Dept sel转载 2013-12-14 08:33:22 · 743 阅读 · 0 评论 -
SqlServer2005 合并两个字符串的方法
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原创 2013-12-14 14:09:28 · 593 阅读 · 0 评论 -
Sqlserver 锁表处里
select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT' ----spid 锁表进程 --tableName 被锁表名 --解锁:转载 2014-04-19 17:00:31 · 440 阅读 · 0 评论 -
SQLSERVER 位运算
createfunction bin2dec(@svarchar(255) ) --二进制转化为十进制returnsintas begin declare@iint,@tempchar(1),@resultint select@i=1 select@result=0 while (@ilen(转载 2014-09-03 10:34:22 · 1186 阅读 · 0 评论 -
SqlServer Try Catch
IF EXISTS (SELECT* FROM SYSOBJECTS WHERE name='my_sp_test'AND TYPE='P')BEGIN DROPPROCEDURE my_sp_test;END;GOcreate procedure my_sp_test @i int, @outstrvarchar(100) out as原创 2015-01-31 09:26:30 · 557 阅读 · 0 评论