Ç󼸾äSQLÓï¾ä

Ò»¸ö¶©µ¥ºÅÏÂÓжà¸ö¼Ç¼£¬Ã¿Ìõ¼Ç¼ÖеÄÑÕÉ«ÓÖÊǶàÖÖ
ÎÒÏëÒªµÄ½á¹û£º
°ÑÕâ¸ö¶©µ¥ºÅϵÄÑÕɫͳ¼ÆΪһ¸ö×Ö¶ÎÀ´ÏÔʾ£¬ÎÒ×Ô¼ºÓÃWHILEÀ´Ñ­»·Ê¼ÖÕ¶¼ÓеãÎÊÌ⣬
ËùÒÔÀ´Çë½Ì¸÷λ£¬Ð»Ð»¡£

---

Âé·³¸ø¸÷λ°ï¿´¿´

---

¿ÉÒÔ¸øµãÊý¾Ý³öÀ´Ã´~~

---

ÂÛ̳̫¶àÁË.

---

¸ø³ö½á¹¹À´¿´¿´

---

¹Ø¼üÊǽá¹ûҪʲôÑù×ӵģ¿

---

SQL code:
CREATE FUNCTION GET_STRING(@ID INT)
RETURNS VARCHAR(500)
AS
BEGIN
DECLARE @NAME VARCHAR(500)
SELECT @NAME=ISNULL(@NAME+',','')+NAME from TB WHERE ID=@ID
RETURN @NAME
END


Ó¦¸ÃÊÇ×Ö·ûºÏ²¢º¯Êý

---

ÒýÓÃ

ÂÛ̳̫¶àÁË.

ͬÒâ

---

SQL code:
/******************************************************************************************************************************************************
ºÏ²¢·Ö²ð±íÊý¾Ý

ÕûÀíÈË£ºÖйú·ç(Roy)

ÈÕÆÚ:2008.06.06
******************************************************************************************************************************************************/

--> --> (Roy)Éú³É測試數據

if not object_id('Tab') is null
drop table Tab
Go
Create table Tab([Col1] int,[Col2] nvarchar(1))
Insert Tab
select 1,N'a' union all