ADO.NETÖÐSQL ServerÊý¾Ý¿âÁ¬½Ó³Ø
Á¬½Óµ½Êý¾Ý¿â·þÎñÆ÷ͨ³£Óɼ¸¸öÐèÒªºÜ³¤Ê±¼äµÄ²½Öè×é³É¡£ ±ØÐ뽨Á¢ÎïÀíͨµÀ£¨ÀýÈçÌ×½Ó×Ö»òÃüÃû¹ÜµÀ£©£¬±ØÐëÓë·þÎñÆ÷½øÐгõ´ÎÎÕÊÖ£¬±ØÐë·ÖÎöÁ¬½Ó×Ö·û´®ÐÅÏ¢£¬±ØÐëÓÉ·þÎñÆ÷¶ÔÁ¬½Ó½øÐÐÉí·ÝÑéÖ¤£¬±ØÐëÔËÐмì²éÒÔ±ãÔÚµ±Ç°ÊÂÎñÖеǼǣ¬µÈµÈ¡£
ʵ¼ÊÉÏ£¬´ó¶àÊýÓ¦ÓóÌÐò½öʹÓÃÒ»¸ö»ò¼¸¸ö²»Í¬µÄÁ¬½ÓÅäÖᣠÕâÒâζ×ÅÔÚÖ´ÐÐÓ¦ÓóÌÐòÆÚ¼ä£¬Ðí¶àÏàͬµÄÁ¬½Ó½«·´¸´µØ´ò¿ªºÍ¹Ø±Õ¡£ ΪÁËʹ´ò¿ªµÄÁ¬½Ó³É±¾×îµÍ£¬ADO.NET ʹÓóÆÎªÁ¬½Ó³ØµÄÓÅ»¯·½·¨¡£
Á¬½Ó³Ø¼õÉÙÐÂÁ¬½ÓÐèÒª´ò¿ªµÄ´ÎÊý¡£ ³Ø½ø³Ì±£³ÖÎïÀíÁ¬½ÓµÄËùÓÐȨ¡£ ͨ¹ýΪÿ¸ö¸ø¶¨µÄÁ¬½ÓÅäÖñ£ÁôÒ»×é»î¶¯Á¬½ÓÀ´¹ÜÀíÁ¬½Ó¡£ Ö»ÒªÓû§ÔÚÁ¬½ÓÉϵ÷Óà Open£¬³Ø½ø³Ì¾Í»á¼ì²é³ØÖÐÊÇ·ñÓпÉÓõÄÁ¬½Ó¡£ Èç¹ûij¸ö³ØÁ¬½Ó¿ÉÓ㬻Ὣ¸ÃÁ¬½Ó·µ»Ø¸øµ÷ÓÃÕߣ¬¶ø²»ÊÇ´ò¿ªÐÂÁ¬½Ó¡£ Ó¦ÓóÌÐò¶Ô¸ÃÁ¬½Óµ÷Óà Close ʱ£¬³Ø½ø³Ì»á½«Á¬½Ó·µ»Øµ½»î¶¯Á¬½Ó³Ø¼¯ÖУ¬¶ø²»ÊÇÕæÕý¹Ø±ÕÁ¬½Ó¡£ Á¬½Ó·µ»Øµ½³ØÖÐÖ®ºó£¬¼´¿ÉÔÚÏÂÒ»¸ö Open µ÷ÓÃÖÐÖØ¸´Ê¹Óá£
Ö»ÓÐÅäÖÃÏàͬµÄÁ¬½Ó¿ÉÒÔ½¨Á¢³ØÁ¬½Ó¡£ ADO.NET ͬʱ±£Áô¶à¸ö³Ø£¬Ã¿¸öÅäÖÃÒ»¸ö³Ø¡£ Á¬½ÓÓÉÁ¬½Ó×Ö·û´®ÒÔ¼° Windows ±êʶ£¨ÔÚʹÓü¯³ÉµÄ°²È«ÐÔʱ£©·ÖΪ¶à¸ö³Ø¡£ »¹¸ù¾ÝÁ¬½ÓÊÇ·ñÒÑÔÚÊÂÎñÖеǼÇÀ´½¨Á¢³ØÁ¬½Ó¡£
³ØÁ¬½Ó¿ÉÒÔÏÔÖøÌá¸ßÓ¦ÓóÌÐòµÄÐÔÄܺͿÉËõ·ÅÐÔ¡£ ĬÈÏÇé¿öÏ£¬ADO.NET ÖÐÆôÓÃÁ¬½Ó³Ø¡£³ý·ÇÏÔʽ½ûÓ㬷ñÔò£¬Á¬½ÓÔÚÓ¦ÓóÌÐòÖдò¿ªºÍ¹Ø±Õʱ£¬³Ø½ø³Ì½«¶ÔÁ¬½Ó½øÐÐÓÅ»¯¡£ »¹¿ÉÒÔÌṩ¼¸¸öÁ¬½Ó×Ö·û´®ÐÞÊηûÀ´¿ØÖÆÁ¬½Ó³ØµÄÐÐΪ¡£
³ØµÄ´´½¨ºÍ·ÖÅä
ÔÚ³õ´Î´ò¿ªÁ¬½Óʱ£¬½«¸ù¾ÝÍêȫƥÅäËã·¨´´½¨Á¬½Ó³Ø£¬¸ÃËã·¨½«³ØÓëÁ¬½ÓÖеÄÁ¬½Ó×Ö·û´®¹ØÁª¡£ ÿ¸öÁ¬½Ó³Ø¶¼ÓëÒ»¸ö²»Í¬µÄÁ¬½Ó×Ö·û´®Ïà¹ØÁª¡£ ´ò¿ªÐÂÁ¬½Óʱ£¬Èç¹ûÁ¬½Ó×Ö·û´®²¢·ÇÓëÏÖÓгØÍêȫƥÅ䣬½«´´½¨Ò»¸öгء£ °´½ø³Ì¡¢°´Ó¦ÓóÌÐòÓò¡¢°´Á¬½Ó×Ö·û´®ÒÔ¼°£¨ÔÚʹÓü¯³ÉµÄ°²È«ÐÔʱ£©°´ Windows ±êʶÀ´½¨Á¢³ØÁ¬½Ó¡£ Á¬½Ó×Ö·û´®»¹±ØÐëÊÇÍêȫƥÅäµÄ£»°´²»Í¬Ë³ÐòΪͬһÁ¬½ÓÌṩµÄ¹Ø¼ü×Ö½«·Öµ½µ¥¶ÀµÄ³ØÖС£
ÔÚÒÔÏ C# ʾÀýÖд´½¨ÁËÈý¸öÐ嵀 SqlConnection ¶ÔÏ󣬵«ÊǹÜÀíʱֻÐèÒªÁ½¸öÁ¬½Ó³Ø¡£ ×¢Ò⣬¸ù¾ÝΪ Initial Catalog ·ÖÅäµÄÖµ£¬µÚÒ»¸öºÍµÚ¶þ¸öÁ¬½Ó×Ö·û´®ÓÐËù²»Í¬¡£
1: using (SqlConnection connection = new SqlConnection(
2: "Integrated Security=SSPI;Initial Catalog=Northwind"))
3: {
4: connection.Open();
5: // Pool A is created.
6: }
7:
8: using (SqlConnection
Ïà¹ØÎĵµ£º
ת×Ô£ºhttp://news.newhua.com/news1/program_database/2008/530/0853092638H5D5AAC4I06BI1G22DCAH8H8B7HIGB0G3F109J6E7F9K2_2.html?lt=common
1. Ôʼµ¥¾ÝÓëʵÌåÖ®¼äµÄ¹ØÏµ
¿ÉÒÔÊÇÒ»¶ÔÒ»¡¢Ò»¶Ô¶à¡¢¶à¶Ô¶àµÄ¹ØÏµ¡£ÔÚÒ»°ãÇé¿öÏ£¬ËüÃÇÊÇÒ»¶ÔÒ»µÄ¹ØÏµ£º¼´Ò»ÕÅÔʼµ¥¾Ý¶ÔÓ¦ÇÒÖ»¶ÔÓ¦Ò»¸öʵÌå¡£ÔÚÌØÊâÇé¿öÏ£¬ËüÃÇ¿ÉÄÜÊÇÒ»¶Ô¶ ......
--> Title : ijÍâÆóSQL ServerÃæ試題
--> Author : wufeng4552
--> Date : 2010-1-15
Question 1£ºCan you use a batch SQL or store procedure to calculating the Number of Days in a Month
Answer 1£ºÕÒ³öµ±ÔµÄÌìÊý
select datepart(dd,dateadd(dd,-1,dateadd(mm,1,cast( ......
MFCÖÐÓÃado·ÃÎÊSQL Server 2005Êý¾Ý¿â
½ñÌìÀÏ´ó½»´úÏîÄ¿£¬ÐèÒªMFC·ÃÎÊÁíһ̨»úÆ÷É쵀 SQL Server 2005Êý¾Ý¿â¡£MFCÎÒ²»Ê죬SQLÒ²´ÓûÓùý¡£ÔÚÍøÉϲéÁ˲»ÉÙ×ÊÁÏ£¬Ã¦ÁËÒ»ÕóÖÕÓÚ¸ãͨÁË¡£Óë¸÷λÅóÓÑ·ÖÏíһϣ¬¸ßÊÖÃǾͲ»Óÿ´ÁË£¬ÕâÊÇд¸øÏñÎÒÒ»Ñù³õѧÕߵġ£
Ò»¡¢°²×°SQL SERVER 2005£¬ÔÚ±¾»ú½¨Á¢·þÎñÆ÷ĬÈϰ²×°¼´¿É£¬Ò²¿ÉÒÔ×Ô¼ ......
C = CHECK Ô¼Êø
D = ĬÈÏÖµ»ò DEFAULT Ô¼Êø
F = FOREIGN KEY Ô¼Êø
FN = ±êÁ¿º¯Êý
IF = ÄÚǶ±íº¯Êý
K = PRIMARY KEY »ò UNIQUE Ô¼Êø
L = ÈÕÖ¾
P = ´æ´¢¹ý³Ì
R = ¹æÔò
RF = ¸´ÖÆÉ¸Ñ¡´æ´¢¹ý³Ì
S = ϵͳ±í
TF = ±íº¯Êý
TR = ´¥·¢Æ÷
U = Óû§±í
V = ÊÓͼ
X = À©Õ¹´æ´¢¹ý³Ì
......