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

Statement µÄ execute(sql) ·½·¨µÄ·µ»ØÖµ

Statement µÄ  execute(sql) ·½·¨µÄ·µ»ØÖµ
 true   if   the   first   result   is   a   ResultSet   object;  
 
 false   if   it   is   an   update   count   or   there   are   no   resultsTop
//  Èç¹û executeµÄ·µ»ØÖµÊÇ ResultSetÔò·µ»Ø true
  boolean   sta=stmt.execute(sql);   
  if(sta){ // ·µ»ØÖµÊÇ ResultSet
        ResultSet   rs=stmt.getResultSet();   
        ..............
  }
  else{// 
        int   x=stmt.getUpdateCount();
        ............
  }


Ïà¹ØÎĵµ£º

SQL SERVER ÓÃsqlÓï¾äÈçºÎ»ñµÃµ±Ç°ÏµÍ³Ê±¼ä


SQL SERVER 2000ÓÃsqlÓï¾äÈçºÎ»ñµÃµ±Ç°ÏµÍ³Ê±¼ä
¾ÍÊÇÓÃGETDATE();
SqlÖеÄgetDate()2008Äê01ÔÂ08ÈÕ ÐÇÆÚ¶þ 14:59
Sql Server ÖÐÒ»¸ö·Ç³£Ç¿´óµÄÈÕÆÚ¸ñʽ»¯º¯Êý
Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2008 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1): 05/16/08
Select CONVERT(varchar(100), ......

Êý¾Ý¿â»ù±¾ SQLÓï¾ä´óÈ«

Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
Create DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice disk, testBack, c:mssql7backupMyNwind_1.dat
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
4¡¢Ë ......

ÔÚSQL Server tempdbÂúʱ¼ì²éÊý¾ÝÎļþ

×÷ΪһÃûÊý¾Ý¿âDBA£¬¿Ï¶¨»áÌý˵¹ý“tempdbÊý¾Ý¿âÂúÁË”¡£Í¨³£ÎÒÃǺÜÈÝÒ×È·¶¨Ôì³ÉÕâÒ»ÎÊÌâµÄÔ­Òò¡£µ«ÊǸü¶àµÄʱºòÕâÒ»ÎÊÌâÖ÷ÒªÔ´ÓÚÒ»×éÇëÇó£¬Éæ¼°µ½Ð´úÂ벿Êð»òÖð½¥Ôö¼ÓµÄÊý¾Ý¡£
¡¡¡¡“TempdbÂúÁË”Òâζ×Åʲô?
¡¡¡¡µ±SQL Server tempdbÂúÁËʱ£¬Éϲã¹ÜÀí³£³£ÐèÒª¾ö²ß¡¢Ò»Ð©¿ª·¢ÈËÔ±¿ÉÄÜ»áÍÆÐ¶ÔðÈΣ¬¾ ......

ʵÏÖSQL Server 2008ÖеÄÎļþÁ÷¹¦ÄÜ

SQL Server 2008ÖÐ×îеÄÎļþÁ÷¹¦ÄÜʹµÃÄã¿ÉÒÔÅäÖÆÒ»¸öÊý¾ÝÀàÐÍΪvarbinary(max)µÄÁУ¬ÒԱ㽫ʵ¼ÊÊý¾Ý´æ´¢ÔÚÎļþϵͳÖУ¬¶ø·ÇÔÚÊý¾Ý¿âÖС£Ö»ÒªÔ¸Ò⣬ÄãÈÔ¿ÉÒÔ×÷Ϊһ¸ö³£¹æµÄ¶þ½øÖÆÁÐÀ´²éѯ´ËÁУ¬¼´Ê¹Êý¾Ý×ÔÉí´æ´¢ÔÚÍⲿ¡£
¡¡¡¡ÎļþÁ÷ÌØÐÔͨ¹ý½«¶þ½øÖÆ´ó×Ö¶ÎÊý¾Ý´æ´¢ÔÚ±¾µØÎļþϵͳÖÐ,´Ó¶ø½«Windowsм¼ÊõÎļþϵͳ(NTFS)ºÍS ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ