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 ½«°Ñ×ÖĸµÄÖØÒôÐÎʽºÍ·ÇÖØÒôÐÎʽÊÓΪÏàͬ¡£
Çø·
Ïà¹ØÎĵµ£º
import java.sql.*;
public class JdbcUtil
{
public static void close(Statement st, Connection con)
{
try
{
&nb ......
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname ......
mysql : ½«Ò»¸ö±íµÄÊý¾Ý²åÈëµ½newT ÖÐ
£¨newT ±íÐë´æÔÚ£¬ÇҽṹÓëselect Óï¾ä¶ÔÓ¦µÄ½á¹¹Í¬ £¬×îºÃ²»ÓÃ* ¶øÊǾßÌå×ֶΣ©
insert into newT select * from t1 where ...
Ò²¿ÉÒÔcreate table newT select f1,f2 from t1; (select into µÄÌæ´ú·½·¨£¬my ......
rs.open sql,conn Óëconn.execute(sql)µÄÇø±ð
rs.open sql,conn Óëconn.execute(sql)µÄÇø±ð
rs.open
......
MYSQLÊý¾Ý¿âÖеij£ÓÃSQLÓï¾ä
1¡¢SELECT ²éѯÓï¾äºÍÌõ¼þÓï¾ä
SELECT ²éѯ×ֶΠfrom ±íÃû WHERE Ìõ¼þ
²éѯ×ֶΣº¿ÉÒÔʹÓÃͨÅä·û* ¡¢×Ö¶ÎÃû¡¢×ֶαðÃû
±íÃû£º Êý¾Ý¿â.±íÃû £¬±íÃû
³£ÓÃÌõ¼þ£º = µÈÓÚ ¡¢<>²»µÈÓÚ¡¢in °üº¬ ¡¢&nb ......