SQL²ÎÊý»¯
SqlCommand com = new SqlCommand("select * from myuser where username=@UserName and password=@Pwd", con);
com.Parameters.Add(new SqlParameter("@UserName", UserName));
com.Parameters.Add( new SqlParameter("@Pwd",Pwd));
Ïà¹ØÎĵµ£º
1. µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
select getdate()
2. dateadd ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
ÀýÈ磺ÏòÈÕÆÚ¼ÓÉÏ2Ìì
select dateadd(day,2,'2004-10-15') --·µ»Ø£º2004-10-17 00:00:00.000
3. datediff ·µ»Ø¿çÁ½¸öÖ¸¶¨ÈÕÆÚµÄÈÕÆÚºÍʱ¼ä ......
ΪÁ˹«Ë¾¿¼ÇÚϵͳµÄÐèÒª
±àдµÄ¼¸¸ö¼òµ¥´æ´¢¹ý³Ì(¿ÉÒÔÊÖ¶¯ÔËÐÐ,Ò²¿ÉÒÔÉèÖÃÊÂÎñ×Ô¶¯ÔËÐÐ!¸Ð¾õ»¹ÐбȽÏͨÓÃ,д³öÀ´¹²ÏíÏÂ)
Calendar±í½á¹¹ºÜ¼òµ¥,2¸ö×Ö¶Î:
fdDate ÈÕÆÚ
fdType ¿¼ÇÚÀàÐÍ(¹¤×÷ÈÕN,ÖÜÄ©W,½Ú¼ÙÈÕH[ÐèÒª¸ù¾ÝÐèÒª×Ô¼ºÐÞ¸Ä])
--ÅжÏÒ»¶Îʱ¼ä·¶Î§ÄڵŤ×÷ÈÕ£¨N£©ºÍÖÜÄ©£¨W£©
Create PR ......
¡¡1¡¢ÔÚ.net framework 2.0µÄ°²×°Ä¿Â¼ÏÂ
£¨Ä¬ÈÏÊÇWINNT\Microsoft.NET\Framework\v2.0.40607£©£¬Æô¶¯Ò»¸ö½ÐASPnet_regsql.exeµÄÃüÁîÐй¤¾ß£¬±ÈÈ磺
ASPnet_regsql -S localhost –U sa –P 123456 -d Pubs –ed
¡¡¡¡ÉÏÃæµÄÒâ˼ÊÇ£¬Ö¸¶¨Á˱¾µØµÄÊý¾Ý¿â·þÎñÆ÷localhost,²¢Ö¸¶¨Á˵ǽµÄÓû§ÃûºÍÃÜÂ룬²¢ÓòΠ......
²éÑ¯ÖØ¸´Öµ£¬ÏÔʾ³ö²»Öظ´µÄ²¿·Ö
select distinct(employeeid) from orders
²éѯÁ½¸ö±íÖ®¼äÏàͬÊý¾Ý
select orders.EmployeeID,Employees.EmployeeID
from orders INNER JOIN Employees
on Employees.EmployeeID=orders.EmployeeID
ʵÏÖÄ¿µÄ£¬Ò»¸ö±í´æ·ÅÓû§±àºÅºÍÓû§Ãû£¬ÔÚÁíÒ»¸ö±íÖпÉÒÔ¸ù¾ÝÓû§±àº ......
1¡£Èç¹û×°sql serverÖÐδ³öÏÖÒì³£µÄ»°£¬ÇÒһЩ×ÔÑ¡²ÎÊý£¬ÕË»§£¬ÃÜÂëµÈûÓдíÎóµÄ»°¡£Ò»µ©³öÏÖÖîÈçsocket½¨Á¢²»Æð£¬Á¬½Ó²»ÉϵÈÎÊÌâ¡£×îÓÐЧµÄ½â¾ö·½·¨ÊÇ´ò²¹¶¡£¬ÆäÖÐsp4£ºhttp://www.microsoft.com/downloads/details.aspx?DisplayLang=zh-cn&FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5£¬sp3a£ºhttp://www.microsof ......