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

sql´æ´¢

declare @p int
declare @p1 int
declare @count int
set @p=0
set @p1=10
set @count=2
if(@count<>0 or @count<>1)
set @p=@p1*@count-10
SELECT [t1].[userid], [t1].[username], [t1].[userorder]
from (
    SELECT ROW_NUMBER() OVER (ORDER BY [t0].[userorder]) AS [ROW_NUMBER], [t0].[userid], [t0].[username], [t0].[userorder]
    from [dbo].[users] AS [t0]
    ) AS [t1]
WHERE [t1].[ROW_NUMBER] BETWEEN @p + 1 AND @p + @p1
USE [SC1]
GO
/****** Object:  StoredProcedure [dbo].[KB_ExaminationSearch_sp]    Script Date: 05/17/2010 08:55:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:  <peter>
-- Create date: <2010-03-15>
-- Description: <»ñÈ¡·¢²¼¿¼ÊÔÐÅÏ¢>
-- =============================================
ALTER PROCEDURE [dbo].[KB_ExaminationSearch_sp]
 @papecode NVARCHAR(10),
 @BExamdate NVARCHAR(50),
 @EExamdate NVARCHAR(50),
 @usercode  NVARCHAR(50),
 @subccode NVARCHAR(10), 
 @examstae NVARCHAR(50),
 @deptcode NVARCHAR(50),
 @BExamscor NVARCHAR(10),
    @EExamscor NVARCHAR(10),  
 @PageIndex INT,
    @PageSize INT,
 @RecordCount INT OUTPUT
AS
BEGIN
 
 DECLARE @sql  NVARCHAR(4000)
 DECLARE @fromWhere  NVARCHAR(3500)
 
 SET @fromWhere = ' from(SELECT CASE examstat WHEN ''0'' THEN ''δ·¢²¼'' WHEN ''1'' THEN ''ÒÑ·¢²¼'' WHEN ''2'' THEN ''´ýÅúÔÄ'' WHEN ''3'' THEN ''ÒÑÅúÔÄ''  WHEN ''4'' THEN ''Íê³É'' WHEN ''6'' THEN ''¿¼ÊÔÖÐ'' WHEN ''7'' THEN ''´ý¿¼'' ELSE ''ȱ¿¼'' END examstae,kbexam.*,kbpape.papname,aduser.userenam,subccode from PKKBEXAMM0 kbexam LEFT JOIN PKKBPAPEM0 kbpape ON kbexam.papecode = kbpape.papecode LEFT JOIN PKADUSERM0 aduser ON aduser.usercode =  kbexam.usercode)temp WHERE 1 = 1  '
 IF(@usercode


Ïà¹ØÎĵµ£º

SQL server2000 Ôõô¸Ä±äÕʺŵÄĬÈÏÊý¾Ý¿â

´ò¿ª²éѯ·ÖÎöÆ÷£¬ÔÚ²éѯ·ÖÎöÆ÷ÏÂÖ´ÐУº
exec sp_defaultdb Õ˺ÅÃû , ĬÈÏÊý¾Ý¿â
¾ÙÀý£ºÎÒµÄĬÈÏÕ˺ÅÊÇsa£¬´ò¿ª²éѯ·ÖÎöÆ÷£¬Ä¬ÈÏÊý¾Ý¿âÊÇmaster£»ÏÖÔÚÎÒн¨ÁËÒ»¸öÊý¾Ý¿âmyData,Ï뽫ĬÈÏÊý¾Ý¿â¸ÄΪmyData£¬Ö»ÐèÖ´ÐУº         exec sp_defaultdb sa , myData  ¼´ ......

SQLÓï¾ä´óÈ«

Ò»¡¢»ù´¡
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¡¢Ëµ ......

jspÓëSQL Server 2000 µÄÁ¬½Ó

ÖÕÓڸ㶨JSPÁ¬½ÓSQL Server 2000Êý¾Ý¿âµÄÎÊÌâÁË
2008Äê01ÔÂ29ÈÕ ÐÇÆÚ¶þ 15:54
    ǰ¼¸Ì죬ƽƽͬѧһֱÔÚ¸ãJSP Á¬½ÓSQL Server 2000Êý¾Ý¿âµÄÎÊÌ⣬һֱÁ¬²»ÉÏ£¬È»ºó½ÐÎÒÈ¥°ïËû¿´¿´£¬Æ¾×ÅÒÔǰµÄ¾­Ñ飬¸ãÁËÒ»¸öÏÂÎ磬ºÙºÙ£¡ÖÕÓÚ°ïËûÁ¬½ÓÉÏÁË£¬Ö÷Òª²½ÖèÈçÏ£º
    1¡¢ÐèÒªµÄ¶«Î÷´ó¼Ò¿ÉÒÔµ½Î ......

sql server 2008 µÄ°²×°

¸ø´ó¼Ò¸öѧϰÊý¾Ý¿âµÄÈí¼þ°É£¬sql server 2008£¬Õâ¸öÊÇ΢Èí¹«Ë¾µÄ×÷Æ·£¬²»´í£¬Ó¦¸ÃÊǷdz£²»´í£¬ÔÚµçÄÔÉϰ²×°OracleÊý¾Ý¿âµÄ»°£¬ÄǸö±È½Ï´ó£¬¶øÇÒÔÚÍøÉÏÒ²²»ºÃÏÂÔØ£¬ÒªÊÇÁ¬½Óµ½Ñ§Ð£·þÎñÆ÷µÄ»°£¬Ò²ÊDz»¿ÉÄܵ쬳ý·Ç´ó¼Ò¾­³£È¥»ú·¿ÉÏ»ú£¬µ«ÊÇÄǸöÒ²²»¿ª£¬·Ï»°²»¶à˵ÁË£¬´ó¼Òȥ΢Èí¹ÙÍøÏÂÔØÒ»¸ösql server 2008µÄÊÔÓðæµÄ°²×°ÎÄ ......

SQL ÓαêÔ­ÀíºÍʹÓ÷½·¨

 Êý¾Ý¿â¿ª·¢¹ý³ÌÖУ¬µ±Äã¼ìË÷µÄÊý¾ÝÖ»ÊÇÒ»Ìõ¼Ç¼ʱ£¬ÄãËù±àдµÄÊÂÎñÓï¾ä´úÂëÍùÍùʹÓÃSELECT INSERT Óï¾ä¡£µ«ÊÇÎÒÃdz£³£»áÓöµ½ÕâÑùÇé¿ö£¬¼´´Óijһ½á¹û¼¯ÖÐÖðÒ»µØ¶ÁȡһÌõ¼Ç¼¡£ÄÇôÈçºÎ½â¾öÕâÖÖÎÊÌâÄØ£¿ÓαêΪÎÒÃÇÌṩÁËÒ»ÖÖ¼«ÎªÓÅÐãµÄ½â¾ö·½°¸¡£
      1.1 ÓαêºÍÓαêµÄÓŵã
  & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ