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

SQL Server¹ÒÆð

ÔÚÔËÐд°¿ÚÊäÈëregedit£¬´ò¿ª×¢²á±í±à¼­Æ÷£¬ÔÚHKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\Session ManagerÖÐÕÒµ½PendingFileRenameOperations£¬É¾³ý¸Ã¼üÖµ£¬¹Ø±Õ×¢²á±í±à¼­Æ÷¡£ÖØÐ°²×°SQL Server 2000,´Ëʱ,¾Í¿ÉÒÔÕý³£½øÈëÆÚ´ýµÄ°²×°½çÃæÁË¡£


Ïà¹ØÎĵµ£º

sql·ÖÒ³£¨×ª£©

½¨Á¢Ò»¸ö Web Ó¦Ó㬷ÖÒ³ä¯ÀÀ¹¦Äܱز»¿ÉÉÙ¡£Õâ¸öÎÊÌâÊÇÊý¾Ý¿â´¦ÀíÖÐÊ®·Ö³£¼ûµÄÎÊÌâ¡£¾­µäµÄÊý¾Ý·ÖÒ³·½·¨ÊÇ:ADO ¼Í¼¼¯·ÖÒ³·¨£¬Ò²¾ÍÊÇÀûÓÃADO×Ô´øµÄ·ÖÒ³¹¦ÄÜ£¨ÀûÓÃÓα꣩À´ÊµÏÖ·ÖÒ³¡£µ«ÕâÖÖ·ÖÒ³·½·¨½öÊÊÓÃÓÚ½ÏСÊý¾ÝÁ¿µÄÇéÐΣ¬ÒòΪÓα걾ÉíÓÐȱµã£ºÓαêÊÇ´æ·ÅÔÚÄÚ´æÖУ¬ºÜ·ÑÄÚ´æ¡£ÓαêÒ»½¨Á¢£¬¾Í½«Ïà¹ØµÄ¼ÇÂ¼Ëø×¡£¬Ö±µ½È¡ÏûÓ ......

ʵÏÖ¶àÐкϲ¢Ò»ÐеÄSQLд·¨

[ORACLE]
ÏîÄ¿ÖÐÓöµ½Ò»¸öÐèÇó£¬ÐèÒª½«¶àÐкϲ¢ÎªÒ»ÐС£
±í½á¹¹ÈçÏ£º
NAME                            Null           ......

sql°²×°ÎÊÌâ

Ò»¡¢Çé¿ö˵Ã÷
    sql server 2000ÒÔǰµÄ°æ±¾£¬ÀýÈç7.0Ò»°ã²»´æÔÚ¶à¸ö°æ±¾£¬Ö»Óбê×¼°æ¸ú×ÀÃæ°æ£¬Óû§Èç¹û²»Çå³þ¸Ãװʲô°æ±¾µÄ»°£¬¿É°´°²×°ÉϵÄ
°²×°ÏȾöÌõ¼þָʾ°²×°£¬Ò»°ãÔÚWIN2000 ·þÎñÆ÷°æÉÏ×°±ê×¼°æ£¬ÆäËûµÄϵͳװ×ÀÃæ°æµÄ¾Í¿ÉÒÔ£»¶øSQL Server 2000°²×°ÎÊÌâ¾Í±È½Ï´ó£¬Ê±³£
¼ûµ½µÄÎÊÌâÈçÏ£º
......

ʵÏÖ¶àÐкϲ¢Ò»ÐеÄSQL [MSSQL2005]д·¨

--1. ´´½¨±í£¬Ìí¼Ó²âÊÔÊý¾Ý
CREATE TABLE tb(id int, [value] varchar(10))
INSERT tb SELECT 1, 'aa'
UNION ALL SELECT 1, 'bb'
UNION ALL SELECT 2, 'aaa'
UNION ALL SELECT 2, 'bbb'
UNION ALL SELECT 2, 'ccc'
--SELECT * from tb
/**//*
id value
----------- ----------
1 aa
1 bb
2 aaa ......

Java Á¬½Ó SQL Server 2000ʾÀý´úÂë

ÄãµÄSQL Server 2000±ØÐë´òÉÏSP3µÄ²¹,È»ºó°²×°MicrosoftµÄJDBCÇý¶¯,½«ÒÔÏÂÈý¸öjar°ü¸´ÖƵ½WebContent\WEB-INF\lib
msbase.jar
mssqlserver.jar
msutil.jar
ÏÂÃæÊDzâÊÔ´úÂ룬ûÓб¨´íÊý¾Ý¿â¾ÍÄÜÕý³£Á¬½Ó
 public class DbcTest {
/**
* @param args
*/
public static void main(String[] args) {
Str ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ