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

MSSQL ·Ö²¼Ê½ÊÂÎñ¹ÜÀí

   µ±Êý¾Ý·þÎñÆ÷ºÍWeb·þÎñÆ÷²¿ÊðÔÚ²»Í¬µÄ·þÎñÆ÷ÉÏʱ£¬»áÓõ½·Ö²¼Ê½ÊÂÎñ£¬ÐèÒª¶ÔÁ½¸ö·þÎñÆ÷µÄMSDTC½øÐÐÅäÖá£
    ´ò¿ª“¹ÜÀí¹¤¾ß¨D¨D×é¼þ·þÎñ”£¬ÒÔ´Ë´ò¿ª“×é¼þ·þÎñ¨D¨D¼ÆËã»ú”£¬ÔÚ“ÎҵĵçÄÔ”Éϵã»÷ÓÒ¼ü¡£ÔÚMSDTCÑ¡ÏÖУ¬µã»÷“°²È«ÅäÖÔ°´Å¥¡£
    ÔÚ°²È«ÅäÖô°¿ÚÖÐ×öÈçÏÂÉèÖ㺠
    Ñ¡ÖГÍøÂçDTC·ÃÎÊ”
    ÔÚÊÂÎñ¹ÜÀíͨѶÖÐÑ¡“ÔÊÐíÈëÕ¾”“ÔÊÐí³öÕ¾”“²»ÒªÇó½øÐÐÑé
    Ñ¡ÖГÆôÓÃXAÊÂÎñ(X)”
   Èçͼ£º
×¢ÒâÊÇÊý¾Ý¿â·þÎñÆ÷ºÍWeb·þÎñÆ÷¶¼ÒªÅäÖÃ.


Ïà¹ØÎĵµ£º

MSSQLÈ«ÎļìË÷

MSSQLÈ«ÎļìË÷ --1.´ò¿ªÊý¾Ý¿â
use pubs
go
--2.´ò¿ªÈ«ÎÄË÷ÒýÖ§³Ö
--execute sp_fulltext_database 'enable'
/*
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 0 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
*/ ......

ÐÞ¸ÄMSSQL±íËùÓÐÕßµÄÁ½ÖÖ·½·¨

ÍøÕ¾¸ü»»¿Õ¼äµÄʱºò£¬¾­³£»áÒòΪMSSQLÊý¾Ý¿âÃû²»Í¬£¬µ¼Ö´Ӿɿռ䱸·ÝµÄÊý¾Ý¿âÔÚпռ仹ԭºóÎÞ·¨Õý³£Ê¹Óá£Õâʱºò£¬ÎÒÃÇ¿ÉÒÔͨ¹ý½«Êý¾Ý¿â±íµÄËùÓÐÕßÐÞ¸ÄΪ"dbo"À´½â¾öÕâ¸öÎÊÌ⣬¾ßÌåµÄ·½·¨ÈçÏ£º
´ò¿ª"Microsoft SQL Server"µÄ“ÆóÒµ¹ÜÀíÆ÷”£¬µã¿ªÒªÐ޸ĵÄÊý¾Ý¿â£¬Ñ¡Ôñ¹¤¾ßÀ¸Éϵē¹¤¾ß” ......

mssql´æ´¢¹ý³Ìas֮ǰ֮ºóµÄ±äÁ¿ÉêÃ÷ÓÐʲôÇø±ð£¿

create    PROCEDURE zdy_CBFY (@SFSS VARCHAR(1),@DWBH varchar(20),@KMBH VARCHAR(10),@KJND VARCHAR(4))
AS
DECLARE @ZWkmye  varchar(20),@zwkmzd  varchar(20),@ZWSSKMYE  varchar(20)
set @zwkmye='zwkmye'+@kjnd
SET @ZWKMZD='ZWKMZD'+@KJND
SET @ZWSSKMYE='ZWSSKMYE'+@KJND
Æä ......

ASP²ÉÓÃODBCÊý¾ÝÔ´Á¬½ÓMSSQLÊý¾Ý¿âÏêϸ˵Ã÷¡¾ÊµÓá¿

ODBCÊý¾ÝÔ´¿É·ÖΪ“ϵͳÐÍ”ºÍ“ÎļþÐÍ”£¬ËûÃǵÄÇø±ðÔÚÓړϵͳÐÍ”ÊÇÁ¬½ÓÊý¾Ý¿âµÄÐÅÏ¢½¨Á¢Ôړϵͳע²á±í”À“ÎļþÐÍ”ÔòÊÇÒÔdsnÎļþÐÎʽ´æ´¢ÔÚODBCÔ´µÄĿ¼ÏÂÃæ
Ò»¡¢½¨Á¢ODBCÊý¾ÝÔ´µÄ·½·¨£º
¿ØÖÆÃæ°å - ¹ÜÀí¹¤¾ß - Êý¾ÝÔ´£¨ODBC£©
´ò¿ªODBCÊý¾ÝÔ´¹ÜÀíÆ÷£¬È»ºóÒ ......

ORACLE ÐÐÁÐת»»Í¨Óô洢¹ý³Ì£¬ÒѾ­×ª»»µÄMSSQL°æ±¾

ÏÂÃæÊÇORACLEÐÐÁÐת»»Í¨Óô洢¹ý³Ì£º
1¡¢
Function Fun_Split_Str(p_Str Varchar2, p_Division Varchar2, p_Seq Int)
    Return Varchar2 Is
    v_First Int;
    v_Last  Int;
  Begin
    If p_Seq < 1 Then
   &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ