SqlServer µÄ¼¸ÖÖ·ÖÒ³·½Ê½
·½Ê½Ò»£º
select top 200 * from view_OrganResource
where 1=1 and OrganID = 57 and
(OrderID not in(select top 1000 OrderID from tb_OrganResource
where 1=1 and OrganID = 57 order by uploadtime desc))
order by uploadtime desc --5858 1980
·½Ê½¶þ£º
select top 200 * from
view_OrganResource where organid=57 and
uploadtime <
(
select min(uploadtime)
from
(
select top 1000 uploadtime from view_OrganResource where organid=57 order by uploadtime desc
) a
)
order by uploadtime desc
·½Ê½Èý£º
SELECT ROW_NUMBER() OVER(ORDER BY orderid DESC) AS 'rnum',*
from view_OrganResource
WHERE 1=1 and rnum >1 and rnum < 1000
SELECT TOP 200 * from (SELECT
ROW_NUMBER() OVER (ORDER BY uploadtime desc) AS RowNumber,
*
from
dbo.view_OrganResource) _myResults
WHERE
RowNumber > 1000
·½Ê½ËÄ£º
SELECT * from (SELECT
ROW_NUMBER() OVER (ORDER BY uploadtime desc) AS RowNumber,
*
from
dbo.view_OrganResource) _myResults
WHERE
RowNumber between 1000 and 1200
go
·½Ê½Î壺
WITH OrderedResults AS
(SELECT *, ROW_NUMBER() OVER (order by uploadtime desc) as RowNumber from dbo.view_OrganResource)
SELECT *
from OrderedResults
WHERE RowNumber between 1001 and 1200
·½Ê½Áù£º
BEGIN
DECLARE @PageLowerBound int
DECLARE @PageUpperBound int
-- Set the page bounds
&n
Ïà¹ØÎĵµ£º
ÔÚ SQLServer2005 ÖÐ¶Ô XML µÄ´¦Àí¹¦ÄÜÏÔÈ»ÔöÇ¿Á˺ܶ࣬ÌṩÁË query(),value(),exist(),modify(),nodes() µÈº¯Êý¡£
¹ØÓÚ xml £¬ÄÑÒÔÀí½âµÄ²»ÊÇ SQLServer ÌṩµÄº¯Êý£¬¶øÊÇ¶Ô xml ±¾ÉíµÄÀí½â£¬¿´Ëƺܼòµ¥µÄÎļþ¸ñʽ£¬´¦ÀíÆðÀ´È´ÊǷdz£À§Äѵġ£±¾ÎÄÖ»ÊdzõÌ ......
SQLSERVER 2000
ÿ´Î´ò¿ªSQLServer²éѯ·ÖÎöÆ÷ºó£¬ÔÚÁ¬½Ó´°¿ÚÀïµÄSQLServer·þÎñÆ÷Ñ¡ÔñÏÂÀ¿òºÍµÇ¼Óû§ÃûÊäÈë¿òÀﶼ»áÁôÓÐÀúÊ·µÇ¼µÄ¼Ç¼£¬ÓÐʱºòÎÒÃÇÊDz»Ï£ÍûÕâÑùµÄ£¬±ÈÈçÔÚÒ»¸ö·Ç˽ÓÐÁìµØ×öÁËÔÝʱµÄ¿ª·¢ºó£¬²»ÏëÁôÏÂÈκÎÁ¬½ÓÔ¶³ÌÊý¾Ý¿âµÄ¼Ç¼£¬ÈçºÎɾ³ýÄØ£¿»¹ÊÇ×¢²á±í£¬ÕÒµ½ÒÔÏ·¾¶£º
HKEY_CURRENT_USER\Software\Micr ......
SQLServer
: EXECºÍsp_executesqlµÄÇø±ð
ÕªÒª
1,EXECµÄʹÓÃ
2£¬sp_executesqlµÄʹÓÃ
MSSQLΪÎÒÃÇÌṩÁËÁ½ÖÖ¶¯Ì¬Ö´ÐÐSQLÓï¾äµÄÃüÁ·Ö±ðÊÇEXECºÍsp_executesql;ͨ³£,sp_executesqlÔò¸ü¾ßÓÐÓÅÊÆ£¬Ëü
ÌṩÁËÊäÈëÊä³ö½Ó¿Ú£¬¶øEXECûÓС£»¹ÓÐÒ»¸ö×î´óµÄºÃ´¦¾ÍÊÇÀûÓÃsp_ ......
ÒÉÎÊ£º
1£¬ sqlserverÀïÃæÖ´ÐÐ xp_cmdshell
exec @error=xp_cmdshell 'cmdstr......'
·µ»ØÖµÊÇʲôֵ£¿dosÃüÁîµÄ´íÎó£¿Ê²Ã´ÑùµÄ´íÎó¿ÉÒÔÆË×½µ½£¿
±ÈÈç:
DECLARE @error int
EXEC @error=master.dbo.xp_cmdshell 'bcp CM_DWHSend.dbo.WK_CM_DWHSend_Master in "D:\Sales\DWH_Onl\2010042_SENDMEMM.csv" -n -t, - ......