ʹÓÃsqlÓï¾ä»ñµÃµ±Ç°ÔÂÌìÊý
ʹÓÃsqlÓï¾ä»ñµÃµ±Ç°ÔÂÌìÊý
--»ñµÃµ±ÔÂÌìÊý
select day(dateadd(mm,1,getdate())-day(getdate())) as ±¾ÔÂÌìÊý ;
select getdate() as µ±Ç°ÈÕÆÚ;
select day(getdate()) as ĿǰµÚ¼¸Ìì;
select getdate()-day(getdate()) as ÉϸöÔÂ×îºóÒ»Ìì; -- ¼õÈ¥Á˵±Ç°µÄÌìÊý
select dateadd(mm,1,getdate())-day(getdate()) as ¼ÓÉÏÒ»¸öÔÂ; -- Ò²¾ÍÊÇÕâ¸öÔµÄ×îºóÒ»Ìì
select day(dateadd(mm,1,getdate())-day(getdate())) as »ñµÃµ±ÔÂÌìÊý;
Ïà¹ØÎĵµ£º
½ñÌìºÜ×ÔÈ»µÄÔÚдSqlÓï¾äµÄʱºòÓÃÁËTop£¬Ò»¿ªÊ¼Ã»·¢ÏÖÎÊÌ⣬ÒòΪÎÒ´ÓÊý¾Ý¿â¶Á³öµÄÖµÕýºÃÊÇ0£¬¶øÎÒϰ¹ß±äÁ¿¶¨ÒåµÄʱºòÒ²¶¼¸³Öµ0£¬¿ÉÊǵ½ÎÒ²»Òª0µÄʱºòÎҾͷ¢ÏÖÎÊÌâÁË¡£ºóÀ´²ÅÖªµÀ£¬¿É°®µÄСsqlite¾¹È»Óв»Ö§³ÖµÄsqlÓï·¨¡£
¡¡¡¡¿´µ½Ä³¸öÂÛ̳ÓиöÐÂÊÖÒ²·¢ÏÖÁËÕâ¸öÎÊÌâ²¢·¢ÌûÁË£¬ÏÂÃæÒ»Å£È˵Ļظ´ÊÇ“topÊÇÄļҵĹؼü´Ê?s ......
declare @SchemaName nvarchar(50)
set @SchemaName='dbo'
declare @CommandName nvarchar(50)
set @CommandName='spName'
SELECT
DB_NAME() AS [PROCEDURE_CATALOG],
  ......
¼Ü¹¹£¨Schema£©¡£Î¢ÈíµÄ¹Ù·½ËµÃ÷£¨MSDN£©£º
"Êý¾Ý¿â¼Ü¹¹ÊÇÒ»¸ö¶ÀÁ¢ÓÚÊý¾Ý¿âÓû§µÄ·ÇÖØ¸´ÃüÃû¿Õ¼ä£¬Äú¿ÉÒÔ½«¼Ü¹¹ÊÓΪ¶ÔÏóµÄÈÝÆ÷"£¬Ïêϸ²Î¿¼
http://technet.microsoft.com/zh-cn/library/ms190387.aspx.ÎÒÃÇÖªµÀ£¬ÔÚJAVAÖУ¬ÃüÃû¿Õ
¼äÃûÆäʵ¾ÍÊÇÎļþ¼ÐÃû¡£Òò´ËÎÒÃǷdz£Ã÷È·Ò»µã£ºÒ»¸ö¶ÔÏóÖ»ÄÜÊôÓÚÒ»¸ö¼Ü¹¹£¬¾ÍÏ ......
1¡¢ SQL Server£ºÈëÕ¾¶Ë¿ÚΪTCP 1433£¬³öÕ¾¶Ë¿ÚΪTCPÈÎÒâ¶Ë¿Ú£¨1024¡«5000Ö®¼äµÄ¶Ë¿ÚºÅ£©£»
2¡¢ SQL Browser £ºÈëÕ¾¶Ë¿ÚΪUDP 1434£¬³öÕ¾¶Ë¿ÚΪUDPÈÎÒâ¶Ë¿Ú£¨1024¡«5000Ö®¼äµÄ¶Ë¿ÚºÅ£©£»
3¡¢²é¿´»òÐÞ¸ÄSQL2005ʵÀýµÄ¶Ë¿ÚºÅ£¬Èç¹ûϵͳÖÐͬʱ°²×°SQL 2000ºÍSQL 2005£¬SQL 2005µÄÁ¬½Ó¶Ë¿Ú¿ÉÄܲ»ÊÇ1433£¬ÎÒÃÇÐèÒª¸ü¸ÄSQL 2005 ......
ÊÓͼ
SET¡¡NOCOUNT ON;
SET Northwind;
GO
IF OBJECT_ID('dbo.ViewName') IS NOT NULL
DROP VIEW dbo.ViewName;
GO
CREATE VIEW dbo.Viewname
AS
SELECT * from customer AS C
WHERE EXISTS
(SELECT * from dbo.Orders AS O
WHERE O.CustomerI ......