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

sqlserver dateadd

-- ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
¼ÓÄê·Ý——print dateadd(year, 5, getdate())       ¼ÓÔ·ݗ—print dateadd(month, 5, getdate())
¼ÓÌìÊý——print dateadd(day, 5, getdate())    ¼ÓСʱ——print dateadd(hour, 5, getdate())
¼Ó·ÖÖÓ——print dateadd(mi, 5, getdate())     ¼ÓÃëÊý——print dateadd(ss, 5, getdate())


Ïà¹ØÎĵµ£º

JavaScriptÁ¬½ÓSqlServer²¢ÊµÏÖ·ÖÒ³

//×ܼǼÊý
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, ......

²ÉÓÃvs2005¶Ôsqlserver 2005 SP½øÐе¥²½µ÷ÊÔ

  ms sqlserver 2005ÖеĴ洢¹ý³ÌÎÞ·¨ÔÚManagement StudioÖнøÐе÷ÊÔ£¬
µ«¿ÉÒÔͨ¹ýVisual Studio 2005À´¶ÔÖ®½øÐе÷ÊÔ¡££¨¿ÉÉèÖöϵ㣬µ¥²½µ÷ÊԵȣ©
    ²ÉÓÃVisual Studioµ÷ÊÔ´æ´¢¹ý³ÌµÄ·½·¨ÈçÏ£º
 1.Æô¶¯Visual Studio£¨¿É²»´´½¨ÏîÄ¿£©£¬´ò¿ªServer Explorer£¨²Ëµ¥£­view-Server Explorer)
......

SqlServerÃüÃû¹æ·¶

ÃüÃû¹ý³ÌÖÐÈçÓÐÏÖ´æµÄËõд£¬ÔòʹÓøÃËõд£¬ÈçÎÞ£¬Ò»Âɲ»µÃËõд£¬Àý£ºISBN
Êý¾Ý¿â£ºÓÃÒ»¸ö»òÈý¸öÒÔÏÂÓ¢Îĵ¥´Ê×é³É£¬µ¥´ÊÊ××Öĸ´óд£¬È磺DepartmentManage£»
±íÃû£ºÊ¹ÓÃÃû´ÊÐÔÖʵĵ¥´Êȫƴ±íʾ£¬¸÷µ¥´ÊÊ××Öĸ´óд£¬ ʹÓø´ÊýÐÎʽ£¬È磺Books
      Èç¹û¸Ã±íÓÃÓÚ±íÃ÷ÁíÍâÁ½±íÖÐ×ֶμäµÄ¹ØÏµ£¬Óõ ......

SQLServerµÄÁ½¸öά»¤¼¼ÇÉ

¡¡È·Êµ£¬Êý¾Ý¿âµÄά»¤³£³£½»¸øÄÇЩרҵµÄÊý¾Ý¿â¹ÜÀíÔ±£¬µ«ÊÇ×÷Ϊһ¸ö¿ª·¢Õߣ¬ÄãÒ²Ðíż¶ûÐèÒªÔÝʱ´ÓÊÂÕâ¸ö¹¤×÷¡£ËùÒÔ£¬ÊÔÒ»ÊÔÕâÁ½¸öSQL·þÎñÆ÷ά»¤¼¼ÇÉ£ºÇáËɸıäÊý¾Ý¿âÓµÓÐÕß¡¢ÕûÀíË÷ÒýË鯬¡£Ë­»áÏëµ½ÄãÉõÖÁ¿ÉÒÔ¸øÄÇЩÊý¾Ý¿â¹ÜÀíÔ±½ÌÉÏÒ»Á½¸öм¼ÇÉÄØ£¿ÖØÖ¸¶¨Êý¾Ý¿âÓµÓÐÕßµ±»Ø¸´»òÕßн¨Êý¾Ý¿âʱ£¬ÄãÓÐûÓÐ×¢Òâµ½SQL Server° ......

sqlserver 2000 Ô¶³ÌÁ¬½Ó ·þÎñÆ÷µÄ½â¾ö·½°¸

sqlserver 2000 Ô¶³ÌÁ¬½Ó ·þÎñÆ÷µÄ½â¾ö·½°¸
Ïêϸ³ö´¦²Î¿¼£ºhttp://www.jb51.net/article/18774.htm
¾ßÌå²½Ö裺
Ò»¡¢ping·þÎñÆ÷IPÄÜ·ñpingͨ
¹Û²ìÔ¶³ÌSQL Server 2000·þÎñÆ÷µÄÎïÀíÁ¬½ÓÊÇ·ñ´æÔÚ¡£Èç¹û²»ÐУ¬Çë¼ì²éÍøÂ磬²é¿´ÅäÖ㬵±È»µÃÈ·±£Ô¶³Ìsql server 2000·þÎñÆ÷µÄIPƴдÕýÈ·¡£
¶þ ÔÚDos»òÃüÁîÐÐÏÂÊäÈëtelnet · ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ