SQL 2000 ·ÖÒ³
SELECT TOP 10 *
from HumanResources.Employee
WHERE EmployeeID NOT IN (SELECT TOP 0 EmployeeID from HumanResources.Employee ORDER BY EmployeeID desc)
ORDER BY EmployeeID desc
————————————————————
SELECT TOP ·ÖÒ³´óС * from ±íÃû where Ö÷¼ü not in (select top µ±Ç°Ò³¼õ1*·ÖÒ³´óС from ±íÃû order by Ö÷¼ü)
order by Ö÷¼ü
Ïà¹ØÎĵµ£º
SQLÈÕÆÚʱ¼ä²»ÄÜÔçÓÚ1753Äê
1.¹«ÔªÔªÄêµÄµÚÒ»Ì죬Ҳ¾ÍÊǹ«Ôª1Äê1ÔÂ1ÈÕ£¬ÄÇÌìÊÇÐÇÆÚÁù¡£
2.
ÏÖÐеĹ«ÀúÊǸñÀû¸êÀïÀú·¨£¬Õâ¸öÀú·¨²¢²»ÊÇÁ¬ÐøµÄ£¬ÖмäȱÉÙÁË11Ìì¡£1752Äê9ÔÂ2ÈյĺóÒ»Ìì²¢²»ÊÇ9ÔÂ3ÈÕ£¬¶øÊÇ9ÔÂ14ÈÕ¡£Ò²¾ÍÊÇ˵£¬´Ó1752Äê9ÔÂ3ÈÕµ½9ÔÂ13ÈÕµÄ11Ìì²¢²»´æÔÚ¡£
&nb ......
²Î¿¼£ºhttp://gaowenjie7758.blog.163.com/blog/static/5946788920091116244306/
SQL´æ´¢¹ý³ÌÖÐSELECTÓëSET ¶Ô±äÁ¿¸³ÖµµÄÇø±ð
SQL Server ÖжÔÒѾ¶¨ÒåµÄ±äÁ¿¸³ÖµµÄ·½Ê½ÓÃÁ½ÖÖ£¬·Ö±ðÊÇ SET ºÍ SELECT¡£¶ÔÓÚÕâÁ½ÖÖ·½Ê½µÄÇø±ð£¬SQL Server Áª»ú´ÔÊéÖÐÒѾÓÐÏêϸµÄ˵Ã÷£¬µ«ºÜ¶àʱºòÎÒÃDz¢Ã»ÓÐ×¢Ò⣬ÆäʵÕâÁ½ÖÖ·½Ê½»¹ÊÇÓкܶ ......
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE data ......
EXEC sp_configure 'show advanced options', 1
declare @strdirname varchar(100)
declare @RemotePathstr varchar(100)
declare @LocalPathstr varchar(100)
declare @DBName char(50)
declare @sql varchar(100)
set @strdirname=replace(substring(convert(varchar(20),getdate(),120),1,10),'-','') --»ñµÃÈÕÆÚ ......
col_1 col_2 col_3 col_4
---------- ---------- ---------- ----------
a 111 222&nb ......