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 Ö÷¼ü
Ïà¹ØÎĵµ£º
1>ͨ¹ýÆóÒµ¹ÜÀíÆ÷½øÈë²éѯ·ÖÎöÖ´ÐУº
EXEC sp_password NULL, 'ÄãµÄÐÂÃÜÂë', 'sa'
Èç¹ûÄãÔÚNTÏÂ(°üÀ¨2000)×°µÄSQL Server£¬Ôò¿ÉÒÔÕâÑù×ö£º
Ö±½Ó´ò¿ª"²éѯ·ÖÎöÆ÷"(×¢Òâ²»ÊÇ´Ó"ÆóÒµ¹ÜÀíÆ÷"ÖнøÈë,¿ÉÒÔ´Ó¿ªÊ¼²Ëµ¥µÄ³ÌÐò×é½øÈ¥,Èç¹ûÕÒ²»µ½µÄ»°,Ö±½ÓÔÚ"ÔËÐÐ"ÖÐÊäÈë"isqlw.exe"Ò²¿É);
Ñ¡Ôñ"WindowsÉí·ÝÑéÖ¤"½øÈë,²»ÐèÒªÊäÈ ......
'±£´æÊý¾Ý
Private Sub Save()
Try
If MsgBox("È·¶¨Òª±£´æËùÐ޸ĵÄÊý¾ÝÂð£¿", MsgBoxStyle.Question Or MsgBoxStyle.DefaultButton2 Or MsgBoxStyle.YesNo, "ϵͳÌáʾ") = Ms ......
Ò»¡¢Á˽âReporting Services
Sqlserver Reporting ServicesÊÇ΢ÈíµÄÊý¾Ý¿â±¨±íÉè¼Æ¹¤¾ß£¬Ëü¼¯³ÉÔÚ΢ÈíµÄÉÌÒµÖÇÄÜ¿ª·¢¹¤¾ß£ºSQL Server Business Intelligence Development StudioÖ®ÖУ¬Õâ¸ö¹¤¾ßÆäʵ¾ÍÊÇ´ó¼ÒÊìϤµÄVisual Studio£¬ÀûÓÃReporting ServicesÎÒôÄܹ»¸ßЧµÄ¿ª·¢Êý¾Ý±¨±í£¬Reporting S ......
create or replace procedure pro_insert_dbms
is
cid number;
cid_DDL number;
selectsql varchar2(1000);
ddlsql varchar2(1000);
row_count number;
nofrows integer;
lrowid & ......