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


Ïà¹ØÎĵµ£º

ʵÏÖsqlserver·ÖÒ³²éѯÓï¾ä

 sqlServer£º
Ò»´Î²éѯ£¬Êý¾Ý¿âÖ»·µ»ØÒ»Ò³µÄÊý¾Ý¡£¶ø²»ÊÇÈ¡³öËùÓеÄÊý¾Ý¡£
pagesize£º ÿҳÏÔʾ¼Ç¼Êý
cureentpage£ºµ±Ç°Ò³Êý
select * from (   select TOP pagesize * from ( SELECT TOP pagesize*cureentpage   * from my_table   ORDER BY id ASC ) as amyTable   OR ......

sqlserver¸Ä±äÊÇ·ñÇø·Ö´óСд

²é¿´ÊÇ·ñÇø·Ö´óСд-Ö´Ðд洢¹ý³Ì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
½«²»Çø·Ö´óСд¸ÄÎªÇø·Ö´óСд ......

SQLServer 2005 ÖеÄÀàÐÍ Óë C# ÖеÄÀàÐÍ ¶ÔÓ¦ ¹ØÏµ

<Language from="SQL" To="C#">
   <Type from="bigint" To="long" />
   <Type from="binary" To="object" />
   <Type from="bit" To="bool" />
   <Type from="char" To="string" />
   <Type from="datetime" To="DateTime" ......

sqlserver´æ´¢¹ý³Ì¿½±´µ½¼Çʱ¾µÄÇé¿ö

×òÌìÉÏ´«³ÌÐòûÓгɹ¦£¬·¢ÏÖÒ»¸öÎÊÌâ
½«SQLServerµÄ´æ´¢¹ý³Ì¿½±´µ½¼Çʱ¾Ê±£¬Èç¹û¼Çʱ¾ÊÇ×Ô¶¯»Ø³µµÄ£¬ÐèҪעÒâһϲÎÊýÊÇ·ñ»Ø³µ¡£
¾ÙÀý£º
alter Proc [dbo].[aaa]
@tCardNos nvarchar(500), --Ïû·Ñ¿¨¿¨ºÅ@tCardPwds nvarchar(1000),--Ïû·Ñ¿¨¿¨ºÅ--¿¨ÃÜÂë@ProductId nvarchar(15), --²úÆ·±àºÅ
ËùÓеIJÎÊý¶¼Ô ......

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ºÅ