Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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, ......

SqlServer ±í ½âËø

--spid:ËÀËøµÄ½ø³Ì,tableName :ËÀËøµÄ±í
select request_session_id spid,OBJECT_NAME(resource_associated_entity_id)tableName from sys.dm_tran_locks
where resource_type='OBJECT'
--spid:Òª½áÊøµÄ½ø³Ìid
kill spid ......

SqlServerÃüÃû¹æ·¶

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

SqlServer,Oracle ³£Óú¯Êý±È½Ï


SqlServer,Oracle ³£Óú¯Êý±È½Ï
 
Êýѧº¯Êý£º
1.¾ø¶ÔÖµ
¡¡¡¡ Sql Server: SELECT abs(-1) value
¡¡¡¡ Oracle: SELECT abs(-1) value from dual
2.È¡Õû(´ó)
¡¡¡¡ Sql Server: SELECT ceiling(-1.001) value
¡¡¡¡ Oracle: SELECT ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
¡¡¡¡ Sql Server: SELECT f ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ