a,b,c,d Çó¸ù¾Ý·Ö¸î·ûºÏ ' µÃµ½µÄ×Ö·û´®¸öÊý

rt

---

SQL code:
select len('a,b,c,d')-len(replace('a,b,c,d',',',''))
/*
-----------
3

(1 個資ÁÏÁÐÊܵ½Ó°響
*/

---

SQL code:
----------------------------------------------------------------
-- Author :fredrickhu(ÎÒÊÇСF£¬Ïò¸ßÊÖѧϰ)
-- Date :2009-12-22 15:36:48
-- Version:
-- Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)
-- Nov 24 2008 13:01:59
-- Copyright (c) 1988-2005 Microsoft Corporation
-- Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
--
----------------------------------------------------------------
--> ²âÊÔÊý¾Ý£º[tb]
if object_id('[tb]') is not null drop table [tb]
go
create table [tb]([col] varchar(9))
insert [tb]
select 'a,b,c,d' union all
select 's,s,s,s,s'
--------------¿ªÊ¼²éѯ--------------------------

select len(col)-len(replace(col,',','')) from [tb]
----------------½á¹û----------------------------
/* -----------
3
4

(2 ÐÐÊÜÓ°Ïì)

*/

---

select len(@s,replace(@s,'·Ö¸ô·û',''))
Èç¹û·Ö¸ô·û2룬ÄÇÒª.2

---

ÒýÓÃ

select len(@s,replace(@s,'·Ö¸ô·û',''))
Èç¹û·Ö¸ô·û2룬ÄÇÒª.2

д´íÁË
declare @s nvarchar(50)