MS SQL µÝ¹éº¯Êý
/*
select *,dbo.getDeptTree(id) as DeptTree from sysdept
µÝ¹éº¯Êý
*/
CREATE function getDeptTree(@NodeId int)
returns varchar(8000)
as
begin
declare @ret varchar(8000),@ParentId int,@len int
set @len = 0
set @ret = ''
select @ret=deptname+@ret,@ParentId=subid from sysdept where id=@NodeId
while @@rowcount<>0
begin
set @NodeId=@ParentId
-- set @ret = replace(@ret,'©¤',' ')
select @ret='|©¤'+@ret,@ParentId=subid from sysdept where id=@NodeId
end
return @ret
end
Ïà¹ØÎĵµ£º
2000·¢²¼Ó붩ÔÄ
Ô¤±¸¹¤×÷
1.·¢²¼·þÎñÆ÷,¶©ÔÄ·þÎñÆ÷¶¼´´½¨Ò»¸öͬÃûµÄwindowsÓû§,²¢ÉèÖÃÏàͬµÄÃÜÂë,×öΪ·¢²¼¿ìÕÕÎļþ¼ÐµÄÓÐЧ·ÃÎÊÓû§
--¹ÜÀí¹¤¾ß
--¼ÆËã»ú¹ÜÀí
--Óû§ºÍ×é
--ÓÒ¼üÓû§
--н¨Óû§
--½¨Á¢Ò»¸öÁ¥ÊôÓÚadministrator×éµÄµÇ½windowsµÄÓû§£¨SynUser£©
2.ÔÚ·¢²¼·þÎñÆ÷ÉÏ,н¨Ò»¸ö¹²ÏíĿ¼ ......
(1)SEQNAME.NEXTVALÀïÃæµÄÖµÈçºÎ¶Á³öÀ´£¿¿ÉÒÔÖ±½ÓÔÚinsert into test values(SEQNAME.NEXTVAL) ÊÇ¿ÉÒÔÓà ÕâÑù£º
SELECT tmp#_seq.NEXTVAL
INTO id_temp
from DUAL; È»ºó¿ÉÒ ......
½«b±íÖÐcallerÁеÄÖµ²åÈëa±íÖÐcallÁÐÖС£
create table a
(
fid int,
call varchar(20),
age int
)
create table b
(
fid int,
caller varchar(20),
parentId int
)
select * from a
select * from b
insert into a values(1,null,19)
insert into a values(2,n ......
C# SQLÊý¾Ý¿â²Ù×÷ͨÓÃÀà
using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
namespace Framework.DataBase
{
///
/// ͨÓÃÊý¾Ý¿âÀà
///
public class DataBase
{
private string ConnStr = null;
public DataBase()
{
&nb ......