Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SqlServerÖÐ×Ô¶¨ÒåÀàËÆSplit½ØÈ¡×ֶκ¯Êý

if exists (select * from dbo.sysobjects where name='SplitStr' )
drop FUNCTION SplitStr
go
CREATE   FUNCTION   SplitStr   (@splitString   varchar(8000),   @separate   varchar(10))  
RETURNS   @returnTable   table(col_Value   varchar(20))  
AS  
BEGIN  
declare   @thisSplitStr   varchar(20)  
declare   @thisSepIndex   int  
declare   @lastSepIndex   int  
set   @lastSepIndex   =   0  
if   Right(@splitString   ,len(@separate))   <>   @separate   set   @splitString   =   @splitString   +   @separate  
set   @thisSepIndex   =   CharIndex(@separate,@splitString   ,@lastSepIndex)  
while   @lastSepIndex   <=   @thisSepIndex  
begin  
                set   @thisSplitStr   =   SubString(@splitString   ,@lastSepIndex,@thisSepIndex-@lastSepIndex)  
                set   @lastSepIndex   =   @thisSepIndex   +   1  
                set   @thisSepIndex   =   CharIndex(@separate,@splitString   ,@lastSepIndex)  
                insert   into   @returnTable   values(@thisSplitStr)  
end&n


Ïà¹ØÎĵµ£º

SQLServerËø»úÖÆÑо¿

 
Ïà¹ØÎÄÕÂ:  
mysqlÊý¾Ý¿âËø
ORACLEÀXÖÖËøÄ£Ê½
ÍÆ¼öȦ×Ó: Pipboy
¸ü¶àÏà¹ØÍÆ¼ö
new Draggable("related_topics");

¶ÔËø»úÖÆµÄÑо¿Òª¾ß±¸Á½¸öÌõ¼þ£º
1£®Êý¾ÝÁ¿´ó
2£®¶à¸öÓû§Í¬Ê±²¢·¢
Èç¹ûȱÉÙÕâÁ½¸öÌõ¼þ£¬Êý¾Ý¿â²»ÈÝÒײúÉúËÀËøÎÊÌâ¡£Ñо¿ÆðÀ´¿ÉÄÜ»áʱ¶¹ ......

SQLServerÖÐÁÙʱ±íµÄÒ»ÔòʹÓÃ

1.SQLServerµÄ´´½¨½Å±¾ÈçÏ£º
USE [master]
GO
/****** Object:  Database [test]    Script Date: 10/29/2009 17:43:10 ******/
CREATE DATABASE [test] ON  PRIMARY
( NAME = N'test', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\test.mdf' , S ......

OracleÖÐÓëSQLSERVER ISNULLº¯ÊýÏàͬ×÷Óõĺ¯Êý

NVL(Expr1,Expr2)Èç¹ûExpr1ΪNULL£¬·µ»ØExpr2µÄÖµ£¬·ñÔò·µ»ØExpr1µÄÖµ
NVL2(Expr1,Expr2,Expr3)Èç¹ûExpr1ΪNULL£¬·µ»ØExpr2µÄÖµ£¬·ñÔò·µ»ØExpr3µÄÖµ
NULLIF(Expr1,Expr2)Èç¹ûExpr1ºÍExpr2µÄÖµÏàµÈ£¬·µ»ØNULL£¬·ñÔò·µ»ØExpr1µÄÖµ ......

C#¶ÁÈ¡sqlserver ¶¯»­flash swf Îļþµ½±¾µØÓ²ÅÌ

 using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlC ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ