Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQLServerͨÓ÷ÖÒ³´æ´¢¹ý³Ì£¬×Ö·û·Ö¸ôº¯Êý

·ÖÒ³´æ´¢¹ý³Ì
sp_QueryPaging
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author:
-- Create date:
-- Description: ·ÖÒ³²éѯ
-- ·µ»ØµÄÊý¾ÝÖÐ×ÜÊÇÔÚÿÌõ¼Ç¼ǰ¼ÓÉÏÐкÅRowNumberÁС£
-- Èç¹ûδָ¶¨@StrSelect²ÎÊý£¬Ï൱ÓÚÉèÖÃËüΪ'*'
-- Èç¹ûδָ¶¨@Strfrom²ÎÊý£¬²»×ö²éѯ£¬·µ»Ø-1
-- Èç¹ûδָ¶¨@StrWhere²ÎÊý£¬ÔòºöÂÔWhereÌõ¼þ
-- Èç¹ûδָ¶¨@StrOrder²ÎÊý£¬ÊÔ×Å×Ô¶¯»ñµÃ±êʶÁÐ×÷Ϊ@StrOrder£¬Ê§°ÜÔò²»×ö²éѯ£¬·µ»Ø-1
-- Èç¹ûδָ¶¨@PageSize²ÎÊý£¬»òÕßËü<=0£¬Ôò·µ»ØÈ«²¿¼Ç¼
-- Èç¹ûδָ¶¨@PageIndex²ÎÊý£¬»áÉèÖÃËüΪ1£¬ÏÔʾµÚÒ»Ò³Êý¾Ý
-- ²Î¿¼£ºshiwenbin http://www.cnblogs.com/virusswb/archive/2009/10/20/1587179.html
-- =============================================
ALTER PROCEDURE [dbo].[sp_QueryPaging]
@StrSelect NVARCHAR(4000) = '*' , --ÓûÏÔʾµÄÁУ¨¶àÁÐÓöººÅ·Ö¿ª£©£¬ÀýÈ磺id,name
@Strfrom NVARCHAR(4000) , --±íÃû³Æ£¬»òÕßÊDZíÁ¬½Ó×Ö·û´®£¬¶à±íÁ¬½ÓÀýÈç:student as s inner join dwinfo as dw on s.dwbh=dw.bh
@StrWhere NVARCHAR(4000) = '' , --²éѯÌõ¼þ,''´ú±íûÓÐÌõ¼þ£¬µ¥Ìõ¼þ»òÕß¶àÌõ¼þ£¬¶àÌõ¼þÀýÈ磺name='°¡' and id=10
@StrOrder NVARCHAR(4000) , --ÅÅÐòÁÐ(¶à¸öÅÅÐòÁÐÓöººÅ·Ö¿ª£©£¬ÀýÈç:id desc,name as
@PageSize INT = 0 , --ÿҳÏÔʾÌõÊý
@PageIndex INT = 1 , --µ±Ç°Ò³
@RecordCount BIGINT = -1 OUTPUT --·µ»Øµ±Ç°Ò³¼Ç¼Êý
AS
BEGIN
SET NOCOUNT ON ;
IF @Strfrom IS NULL
BEGIN
RETURN -1
END
--ÈôûÓÐÖ¸¶¨@StrOrder£¬ÊÔ×Å»ñÈ¡±êʶÁÐ
IF @StrOrder IS NULL
BEGIN
DECLARE @identitycol NVARCHAR(50)
SET @identitycol = ( SELECT TOP ( 1 )
COLUMN_NAME
from INFORMATION_SCHEMA.columns
WHERE TABLE_NAME = @Strfrom
AND COLUMNPROPERTY(OBJECT_ID(@Strfrom),
COLUMN_N


Ïà¹ØÎĵµ£º

SQLSERVER ·ÖÒ³

select   identity(int,1,1) as col_id , *   into   temp   from  uep.dbo.A_experiment 
select   *   from temp where   col_id   between   50   and   60
drop  table temp ......

ÔÚ²»Í¬sqlserver·þÎñÆ÷¼ä£¬´´½¨ÏàͬÊý¾Ý¿â¶ÔÏó¡£

·ÖÁ½ÖÖÇé¿ö£º
1¡¢Í¨¹ý½Å±¾·½Ê½£¬2¡¢µ¼Èëµ¼³ö·½Ê½
µ«²»Í¬°æ±¾µÄSqlServer,ÔÚÕâ·½Ãæ²¢²»Ïàͬ¡£
sql2000¶ÔÊý¾Ý¿â¶ÔÏóÖ´ÐÐÉú³É½Å±¾Ê±£¬¾¡¹Ü¶¼Ñ¡Éϸ÷¸öÌõ¼þ£¬µ«¶ÔÓÚ±í¶ÔÏó²¢²»ÄÜ´´½¨Ö÷¼ü
¿ÉÒÔͨ¹ýµ¼Èëµ¼³ö·½Ê½£¬ÔÚµ¼ÈëÄ¿±êÑ¡ÔñÄ¿±êsqlserverºó£¬Ñ¡ÔñÖ»µ¼³ö¶ÔÏó½á¹¹¾ÍºÃÁË¡£
sql2005¶ÔÊý¾Ý¿â¶ÔÏóÖ´ÐÐÉú³É½Å±¾Ê±£¬¿ÉÒÔ´´½¨Ö÷¼ ......

һЩSqlServerÓï¾ä

Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
4¡¢Ëµ ......

[Òý]SQLServerºÍAccess¡¢ExcelÊý¾Ý´«Êä¼òµ¥×ܽá

http://www.tongyi.net/article/20031101/200311013786.shtml
ËùνµÄÊý¾Ý´«Ê䣬ÆäʵÊÇÖ¸SQLServer·ÃÎÊAccess¡¢Excel¼äµÄÊý¾Ý¡£
ΪʲôҪ¿¼Âǵ½Õâ¸öÎÊÌâÄØ£¿
ÓÉÓÚÀúÊ·µÄÔ­Òò£¬¿Í»§ÒÔǰµÄÊý¾ÝºÜ¶à¶¼ÊÇÔÚ´æÈëÔÚÎı¾Êý¾Ý¿âÖУ¬ÈçAcess¡¢Excel¡¢Foxpro¡£ÏÖÔÚϵͳÉý¼¶¼°Êý¾Ý¿â·þÎñÆ÷ÈçSQLServer¡¢ORACLEºó£¬¾­³£ÐèÒª·ÃÎÊÎı¾Êý ......

sqlserver 2005 split function

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
create function [dbo].[split](@str nvarchar(1000),@word varchar(5),@no
int) returns nvarchar(500)
as begin
    declare @len int
    declare @index int
    set @index=charindex(@word,@str)
   ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ