sqlserver һЩȫ¾Ö±äÁ¿
sqlserver ÖÐ È«¾Ö±äÁ¿ ÊÇÒ»ÖÖÌØÊâÀàÐ͵ıäÁ¿£¬È«¾Ö±äÁ¿ÒÔ@@¿ªÍ·£¬ÊÇÓÉϵͳ¶¨ÒåµÄ¡£
@@CONNECTIONS ·µ»Ø
SQL Server
×ÔÉÏ´ÎÆô¶¯ÒÔÀ´³¢ÊÔµÄÁ¬½ÓÊý¡£
@@CURSOR_ROWS
È·¶¨µ±Æä±»µ÷ÓÃʱ¼ìË÷ÁËÓαê·ûºÏÌõ¼þµÄÐÐÊý¡£
@@DATEFIRST
Õë¶Ô»á»°·µ»Ø
SET DATEFIRST
µÄµ±Ç°Öµ£¬
SET DATEFIRST
±íʾָ¶¨µÄ
ÿÖܵĵÚÒ»Ìì¡£
@@DBTS
·µ»Øµ±Ç°Êý¾Ý¿âµÄµ±Ç°
timestamp
Êý¾ÝÀàÐ͵ÄÖµ£¬
Õâһʱ¼ä´ÁÖµÔÚÊý¾Ý¿âÖбØÐëÊÇΨһµÄ¡£
@@ERROR
·µ»ØÖ´ÐеÄÉÏÒ»¸ö
Transact-SQL
Óï¾äµÄ´íÎóºÅ£¬
Èç¹ûǰһ¸ö
Transact-SQL
Óï¾äÖ´ÐÐûÓдíÎó£¬Ôò·µ»Ø
0
¡£
@@FETCH_STATUS
·µ»ØÕë¶ÔÁ¬½Óµ±Ç°´ò¿ªµÄÈκÎÓα귢³öµÄÉÏÒ»ÌõÓαê
FETCH
Óï¾äµÄ״̬¡£
@@IDENTITY
·µ»ØÉϴβåÈëµÄ±êʶֵ¡£
@@LANGID
·µ»Øµ±Ç°Ê¹ÓõÄÓïÑԵı¾µØÓïÑÔ±êʶ·û
(ID)
¡£
@@LANGUAGE
·µ»Øµ±Ç°ËùÓÃÓïÑÔµÄÃû³Æ¡£
@@LOCK_TIMEOUT
·µ»Øµ±Ç°»á»°µÄµ±Ç°Ëø¶¨³¬Ê±ÉèÖ㨺ÁÃ룩¡£
@@MAX_CONNECTIONS
ȯ
SQL Server
ʵÀýÔÊÐíͬʱ½øÐеÄ×î´óÓû§Á¬½ÓÊý¡£
·µ»ØµÄÊýÖµ²»Ò»¶¨Êǵ±Ç°ÅäÖõÄÊýÖµ¡£
@@OPTIONS
·µ»ØÓйص±Ç°
SET
Ñ¡ÏîµÄÐÅÏ¢¡£
@@PROCID
·µ»Ø
Transact-SQL
µ±Ç°Ä£¿éµÄ¶ÔÏó±êʶ·û
(ID)
¡£
Transact-S
Ä£¿é¿ÉÒÔÊÇ´æ´¢¹ý³Ì¡¢Óû§¶¨Ò庯Êý»ò´¥·¢Æ÷¡£
@@ROWCOUNT
·µ»ØÊÜÉÏÒ»Óï¾äÓ°ÏìµÄÐÐÊý¡£
@@SERVERNAME
·µ»ØÔËÐÐ
SQL Server
µÄ±¾µØ·þÎñÆ÷µÄÃû³Æ¡£
@@TRANCOUNT
·µ»Øµ±Ç°Á¬½ÓµÄ»î¶¯ÊÂÎñÊý¡£
Ïà¹ØÎĵµ£º
µ±SQLServerµÄϵͳÈÕÖ¾¹ý´ó£¬¾Í»áÒýÆðSQLServer·þÎñÆ÷ÎÞ·¨Æô¶¯µÈһϵÁÐÎÊÌâ¡£½ñÌìÎÒÓöµ½ÁËÕâ¸öÎÊÌ⣬ÔÚÍøÉÏËÑË÷ÁËһϣ¬½â¾ö·½·¨ÊÇɾ³ý¾Í¿ÉÒÔÁË£¬¿ÉÊǵ±Ç°µÄErrorLogÕýÔÚ±»SQLʹÓÃÎÞ·¨É¾³ý°¡£¬ÒªÉ¾³ýÖ»ÄÜÍ£Ö¹SQL·þÎñÆ÷£¬ÄѵÀ¾ÍûÓбðµÃ°ì·¨ÁËÂð£¿
»Ø´ðÊǿ϶¨µÄ£ºÊ¹ÓÃÒÔÏ´洢¹ý³Ì£º ......
²é¿´ÊÇ·ñÇø·Ö´óСд-Ö´Ðд洢¹ý³Ìsys.sp_server_info
exec sys.sp_server_info
²é¿´µÚ18ÐÐCOLLATION_SEQ-collationÊôÐÔ
charset=cp936 collation=Chinese_PRC_CS_AS
csÎªÇø·Ö´óСд£¬CIΪ²»Çø·Ö´óСд
½«Çø·Ö´óСд¸ÄΪ²»Çø·Ö´óСд
alter database yourDB COLLATE Chinese_PRC_CI_AS
½«²»Çø·Ö´óСд¸ÄÎªÇø·Ö´óСд
......
//×ܼǼÊý
function sumRecord()
{
var conn= Server.CreateObject("ADODB.connection");
var rs= Server.CreateObject("adodb.recordset");
conn.open("PROVIDER=SQLOLEDB;DATA SOURCE=127.0.0.1;UID=sa;PWD=123456;DATABASE=test");
var sql = "select count(*) as RecordCount from baoming";
rs.open(sql, ......
Ë÷ÒýµÄÖØÒªÐÔ
¡¡¡¡Êý¾Ý¿âÐÔÄÜÓÅ»¯ÖÐË÷Òý¾ø¶ÔÊÇÒ»¸öÖØÁ¿¼¶µÄÒòËØ£¬¿ÉÒÔ˵£¬Ë÷ÒýʹÓò»µ±£¬ÆäËüÓÅ»¯´ëÊ©½«ºÁÎÞÒâÒå¡£
¡¡¡¡¾Û´ØË÷Òý(Clustered Index)ºÍ·Ç¾Û´ØË÷Òý (Non- Clustered Index)¡¡
¡¡¡¡×îͨË׵ĽâÊÍÊÇ:¾Û´ØË÷ÒýµÄ˳Ðò¾ÍÊÇÊý¾ÝµÄÎïÀí´æ´¢Ë³Ðò£¬¶ø¶Ô·Ç¾Û´ØË÷ÒýµÄË÷Òý˳ÐòÓëÊý¾ÝÎïÀíÅÅÁÐ˳ÐòÎ޹ء£¾ÙÀýÀ´Ëµ£¬Äã·µ½Ð ......
²»µÃ²»ËµµÄÔÚ MS SQL SERVER Ï嵀 JDBC µ÷ÓÃ
½ñÌìÏÂÎ磬ÁÙʱ¾ö¶¨ÒªÔÙ MS SQL-SERVER ÏÂÅäÖà Spring µÄÊý¾ÝÔ´ DataSource ¡£µ«ÅäÖÃÁ˰ëÌì,»ñÈ¡Êý¾ÝÔ´ÈÔ²»³É¹¦£¬ÎÒûÓа취£¬ÕÒÔÒòߣ¬Ö»ÄÜд¸öÁÐ×Ó²âÊÔÏ¡£ÏȲ»¹ÜÈýÆß¶þʮһ£¬ÏÈÉÏÕýÈ·µÄÀý×ÓÔÙ˵¡£
¿´¿ÍÈç¹ûÏëÔËÐÐÏÂÃæµÄ´úÂ룬ÐèÒª×Ô¼ºÊÖ¹¤ ......