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

Microsoft SQL Server 2005µÄÅÅÐò¹æÔò³åÍ»½â¾ö(ת)

ÏÖÏó£º
        ÔÚʹÓÃMicrosoft SQL Server 2005ʱ£¬Òª´´½¨Ò»¸öµÇ¼Ãû£¬²¢Îª¸ÃµÇ¼Ãû¹ØÁªÁËÒ»¸öÊý¾Ý¿â£¬µ«ÊÇÔÚÑ¡Ôñ“°²È«¶ÔÏó”Ñ¡Ïîʱ£¬È´³öÏÖÁËÈçÌâËùʾµÄ´íÎó¡£ÆäËûÐÅÏ¢ÏÔʾΪ£ºÖ´ÐÐTransact-SQLÓï¾ä»òÅú´¦Àíʱ·¢ÉúÁËÒì³£(Microsoft.SqlServer.ConnectionInfo)¡£ÎÞ·¨½â¾öUNION²Ù×÷ÖГSQL_Latin1_General_CP1_CI_AS”ºÍ“Chinese_PRC_CI_AS”Ö®¼äµÄÅÅÐò¹æÔò³åÍ»¡££¨Microsoft SQL Server£¬´íÎó£º468£©
½â¾ö°ì·¨£º
·½·¨1£º
    1¡¢²åÈëmssql server µÄ°²×°ÅÌ£¬
2¡¢ÔËÐÐ-->CMD -->»Ø³µ
3¡¢ÔÚDOS ״̬ϽøÈëmssql server µÄsetupĿ¼£¬Ö®ºóÊäÈëÒÔÏ´úÂ룬»Ø³µºóÉÔµÈÊ®Êý·ÖÖÓ¼´¿É²¢¸ü¸Ä·þÎñÆ÷ÅÅÐò¹æÔò£¨Îñ±Ø×¢Òâ´óСд±ØÐëÒ»Ö£¬ÁíÍâSAPWD Ö¸Êý¾Ý¿â·þÎñÆ÷saÓû§µÄ·ÃÎÊÃÜÂ룩
start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=test SQLCOLLATION=Chinese_PRC_CI_AS
Windows / SQL Server 2005 µÄÅÅÐò¹æÔò
Èç Chinese_PRC_Stroke_CS_AI_WS£¬ÅÅÐò¹æÔòÃû³ÆÓÉÁ½²¿·Ý¹¹³É£»
Ç°°ë²¿·ÝÊÇÖ¸±¾ÅÅÐò¹æÔòËùÖ§³ÖµÄ×Ö·û¼¯¡£
Chinese_PRC Ö¸Õë¶Ô´ó½¼òÌå×ÖUNICODEµÄÅÅÐò¹æÔò¡£
ºó°ë²¿·Ý¼´ºó׺µÄº¬ÒåΪ£º
_BIN        Ö¸¶¨Ê¹ÓÃÏòºó¼æÈݵĶþ½øÖÆÅÅÐò˳Ðò¡£
_BIN2      Ö¸¶¨Ê¹Óà SQL Server 2005 ÖÐÒýÈëµÄÂëλ±È½ÏÓïÒåµÄ¶þ½øÖÆÅÅÐò˳Ðò¡£
_Stroke   °´±Ê»®ÅÅÐò
_CI(CS) ÊÇ·ñÇø·Ö´óСд£¬CI²»Çø·Ö£¬CSÇø·Ö
_AI(AS)    ÊÇ·ñÇø·ÖÖØÒô£¬AI²»Çø·Ö£¬ASÇø·Ö
_KI(KS)   ÊÇ·ñÇø·Ö¼ÙÃûÀàÐÍ£¬KI²»Çø·Ö£¬KSÇø·Ö
_WI(WS) ÊÇ·ñÇø·ÖÈ«°ë½Ç£¬WI²»Çø·Ö£¬WSÇø·Ö
¶þ½øÖÆ£º    ¶þ½øÖÆÅÅÐò˳Ðò¼ÈÇø·Ö´óСд£¬Ò²Çø·ÖÖØÒô¡£Èç¹ûδѡÔñ´ËÑ¡ÏÔò SQL Server ½«×ñÑ­×ÖµäÖж¨ÒåµÄÏà¹ØÓïÑÔ»ò×Öĸ±íµÄÅÅÐòºÍ±È½Ï¹æÔò¡£
¶þ½øÖÆÂëλ£ºÒÔUnicode Âëλ¶ÔÊý¾Ý½øÐбȽϻòÅÅÐò¡£¶ÔÓÚ·Ç Unicode Êý¾ÝÔòʹÓöþ½øÖÆÅÅÐòÏàͬµÄ±È½Ï·½Ê½¶ÔÒÑÅÅÐòµÄ SQL Server Êý¾Ý½øÐбȽϵÄÓ¦ÓóÌÐò²»±ØÖØжÔÊý¾Ý½øÐÐÅÅÐò¡£//Ìá¸ßÐÔÄÜ¡£
Çø·Ö´óСд£ºÈç¹ûδѡÔñ´ËÑ¡ÏÔò SQL Server ÈÏΪ×ÖĸµÄ´óСдÐÎʽ¶ÔÓÚÅÅÐòÄ¿µÄ¶øÑÔÊÇÏàͬµÄ¡£
Çø·ÖÖØÒô£º Èç¹ûδѡÔñ´ËÏÔÚÅÅÐòʱ£¬SQL Server ½«°Ñ×ÖĸµÄÖØÒôÐÎʽºÍ·ÇÖØÒôÐÎʽÊÓΪÏàͬ¡£
Çø·


Ïà¹ØÎĵµ£º

sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ ......

jdbcÁ¬½Ósql server

import java.sql.*;
public class JdbcUtil
{
    public static void close(Statement st, Connection con)
    {
        try
        {
          &nb ......

sqlÖÐhaving Óëgroup byÏê½â

GROUP BY ʵÀý
±í "Sales":
Company Amount
W3Course 6500
IBM 5500
W3Course 7300
SQL:
SELECT Company, SUM(Amount) from Sales
½á¹û:
Company SUM(Amount)
W3Course 19300
IBM 19300
W3Course 19300
ÉÏÃæµÄ´úÂëÊÇÎÞЧµÄ£¬ÕâÊÇÓÉÓÚ±»·µ»ØµÄÁÐûÓнøÐв¿·ÖºÏ¼Æ¡£GROUP BY ×Ó¾äÄܽâ¾öÕâ¸öÎÊÌ⣺
SELE ......

Sql Sever 2005 ÊÓͼµÄ²Ù×÷

ºÜ¶àÈËÌرðϲ»¶ÓÃÊÓͼ,µ«ÓеÄÈË´ÓÀ´²»ÓÃÊÓͼ.ÕⶼÊÇÁ½ÖÖ²»Á¼µÄÏ°¹ß.     ÒªÃ÷È·ÊÓͼ¿ÉÒÔÍê³ÉµÄ¹¤×÷ÒÔ¼°Ê¹Óó¡ºÏ.
     1.×èֹѡÔñ±£ÃÜÁÐ
     2.½µµÍÓû§¶ÁÈ¡Êý¾Ý¿âÄÚÊý¾ÝµÄ¸´ÔÓÐÔ  
     3.ÔÚÊý¾Ý¿âÖÐÌí¼ÓË÷ÒýÒÔ¼ÓËÙ ......

rs.open sql,conn Óëconn.execute(sql)µÄÇø±ð

rs.open sql,conn Óëconn.execute(sql)µÄÇø±ð ÊÕ²Ø
ÒýÓÓsrnld£¨ÌìÑÄ£©”µÄ»°£º 
ʲôʱºòÓÃʲô?  
  ÄǾÍƾ¸öÈ˾­Ñé»ýÀ۵ĸоõÁË:  
    Èç¹ûÖ»ÐèÒªÒ»±Ê´ø¹ýµÄÅöÅöÊý¾Ý¿â,ÓÃexecute  
  Èç¹ûÒª¶ÔÊý¾Ý¿â×÷±È½ÏÅÓÔӵIJÙ×÷!Ôò×îºÃÓà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ