ÇëÎÊsqlÔõôʵÏÖ - .NET¼¼Êõ / ASP.NET

declare @a varchar(50)

set @a = '2010/02/02¡«2010/02/05'

ÎÒÏëÒªÊä³öÁ½¸ö×Ö·û´®£¬·Ö±ðÊÇ
'2010/02/02¡¯ºÍ¡®2010/02/05'

ÇëÎÊsqlÔõôʵÏÖ£¬×îºÃ²»Òª½ØÈ¡×Ö·û´®µÄÄÇÖÖ

---

²»½ØÈ¡ÄÇÄÒ¸ö°ì°¡£¿

---

Äܲ»Äܸù¾Ý ¡°¡«¡±
Õâ¸ö·ûºÅÀ´·Ö¿ª

---

SQL code:

declare @a varchar(50)
set @a = '2010/02/02¡«2010/02/05'
declare @b varchar(10)
declare @c varchar(10)
set @b=left(@a,10)
set @c=right(@a,10)



??

---

СËÎ

---

SQL code:

declare @a varchar(50)

set @a = '2010/02/02¡«2010/02/05'

select substring(@a,0,charindex('¡«',@a))
select substring(@a,charindex('¡«',@a)+1,len(@a))

---

Â¥ÉÏÕý½â

---

Ö§³Ö~

---

ÒýÓÃ

SQL code

declare @a varchar(50)

set @a = '2010/02/02¡«2010/02/05'

select substring(@a,0,charindex('¡«',@a))
select substring(@a,charindex('¡«',@a)+1,len(@a))

˵µÄ¶Ô°¡

---

ѧϰÏ£¡

---

¶¥¶¥¶¥¶¥¶¥¶¥¶¥¶¥

---

declare   @a   varchar(50)
set   @a   =   '2010/02/02¡«2010/02/05 '
declare   @b   varchar(10)
declare   @c   varchar(10)
set   @b=left(@a,10)
set &