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

»ùÓÚSQL Server ·ÖÒ³´æ´¢¹ý³ÌµÄÑݽø

 
»ùÓÚSQL Server ·ÖÒ³´æ´¢¹ý³ÌµÄÑݽø ÊÕ²Ø
Õë¶ÔÊý¾Ý¿âÊý¾ÝÔÚUI½çÃæÉϵķÖÒ³ÊÇÀÏÉú³£Ì¸µÄÎÊÌâÁË£¬ÍøÉϺÜÈÝÒ×ÕÒµ½¸÷Ö֓ͨÓô洢¹ý³Ì”´úÂ룬¶øÇÒÓÐЩ»¹¶¨ÖƲéѯÌõ¼þ£¬¿´ÉÏȥʹÓúܷ½±ã¡£±ÊÕß´òËãͨ¹ý±¾ÎÄÒ²À´¼òµ¥Ì¸Ò»Ï»ùÓÚSQL SERVER 2000µÄ·ÖÒ³´æ´¢¹ý³Ì£¬Í¬Ê±Ì¸Ì¸SQL SERVER 2005Ï·ÖÒ³´æ´¢¹ý³ÌµÄÑݽø¡£
 
ÔÚ½øÐлùÓÚUIÏÔʾµÄÊý¾Ý·Öҳʱ£¬³£¼ûµÄÊý¾ÝÌáÈ¡·½Ê½Ö÷ÒªÓÐÁ½ÖÖ¡£µÚÒ»ÖÖÊÇ´ÓÊý¾Ý¿âÌáÈ¡ËùÓÐÊý¾ÝÈ»ºóÔÚϵͳӦÓóÌÐò²ã½øÐÐÊý¾Ý·ÖÒ³£¬ÏÔʾµ±Ç°Ò³Êý¾Ý¡£µÚ¶þÖÖ·ÖÒ³·½Ê½Îª´ÓÊý¾Ý¿âÈ¡³öÐèÒªÏÔʾµÄÒ»Ò³Êý¾ÝÏÔʾÔÚUI½çÃæÉÏ¡£
ÒÔÏÂÊDZÊÕß¶ÔÁ½ÖÖʵÏÖ·½Ê½Ëù×öµÄÓÅȱµã±È½Ï£¬Õë¶ÔÓ¦ÓóÌÐò±àд£¬±ÊÕßÒÔ.NET¼¼Êõƽ̨ΪÀý¡£
Àà±ð
SQLÓï¾ä
´úÂë±àд
Éè¼ÆÊ±
ÐÔÄÜ
µÚÒ»ÖÖ
Óï¾ä¼òµ¥£¬¼æÈÝÐÔºÃ
ºÜÉÙ
Íêȫ֧³Ö
Êý¾ÝÔ½´óÐÔÄÜÔ½²î
µÚ¶þÖÖ
¿´¾ßÌåÇé¿ö
½Ï¶à
²¿·ÖÖ§³Ö
Á¼ºÃ£¬¸úSQLÓï¾äÓйØ
 
¶ÔÓÚµÚÒ»ÖÖÇé¿ö±¾ÎIJ»´òËã¾ÙÀý£¬µÚ¶þÖÖʵÏÖ·½Ê½±ÊÕßÖ»ÒÔÁ½´ÎTOP·½Ê½À´½øÐÐÌÖÂÛ¡£
ÔÚ±àд¾ßÌåSQLÓï¾ä֮ǰ£¬¶¨ÒåÒÔÏÂÊý¾Ý±í¡£
Êý¾Ý±íÃû³ÆÎª£ºProduction.Product¡£ProductionΪSQL SERVER 2005ÖиĽøºóµÄÊý¾Ý±í¼Ü¹¹£¬¶Ô¾ÙÀý²»Ôì³ÉÓ°Ïì¡£
°üº¬µÄ×Ö¶ÎΪ£º
ÁÐÃû
Êý¾ÝÀàÐÍ
ÔÊÐí¿Õ
˵Ã÷
ProductID
Int
 
²úÆ·ID£¬PK¡£
Name
Nvarchar(50)
 
²úÆ·Ãû³Æ¡£
 
²»ÄÑ·¢ÏÖÒÔÉϱí½á¹¹À´×ÔSQL SERVER 2005 ÑùÀýÊý¾Ý¿âAdventureWorksµÄProduction.Product±í£¬²¢ÇÒֻȡÆäÖÐÁ½¸ö×ֶΡ£
 
·ÖÒ³Ïà¹ØÔªËØ£º
PageIndex – Ò³ÃæË÷Òý¼ÆÊý£¬¼ÆÊý0ΪµÚÒ»Ò³¡£
PageSize – Ã¿¸öÒ³ÃæÏÔʾ´óС
RecordCount – ×ܼǼÊý
PageCount – Ò³Êý
 
¶ÔÓÚºóÁ½¸ö²ÎÊý£¬±ÊÕßÔÚ´æ´¢¹ý³ÌÖÐÒÔÊä³ö²ÎÊýÌṩ¡£
 
1£®SQL SERVER 2000ÖеÄTOP·ÖÒ³
CREATE PROCEDURE [Zhzuo_GetItemsPage]
    @PageIndex INT, /*@PageIndex´Ó¼ÆÊý,0ΪµÚÒ»Ò³*/
    @PageSize INT, /*Ò³Ãæ´óС*/
    @RecordCount INT OUT, /*×ܼǼÊý*/
    @PageCount INT OUT /*Ò³Êý*/
AS
/*»ñÈ¡¼Ç¼Êý*/
SELECT @RecordCount = COUNT(*) from Production.Product
/*¼ÆËãÒ³ÃæÊý¾Ý*/
SET @PageCount = CEILING(@RecordCount&


Ïà¹ØÎĵµ£º

¶¯Ì¬´´½¨Sql ServerÊý¾Ý¿âÏà¹Ø£¨È«£©

 
CREATE DATABASE
´´½¨Ò»¸öÐÂÊý¾Ý¿â¼°´æ´¢¸ÃÊý¾Ý¿âµÄÎļþ£¬»ò´ÓÏÈǰ´´½¨µÄÊý¾Ý¿âµÄÎļþÖи½¼ÓÊý¾Ý¿â¡£
˵Ã÷ ÓйØÓë DISK INIT Ïòºó¼æÈÝÐԵĸü¶àÐÅÏ¢£¬Çë²Î¼û"Microsoft® SQL Server™ Ïòºó¼æÈÝÐÔÏêϸÐÅÏ¢"ÖеÄÉ豸£¨¼¶±ð 3£©¡£
Óï·¨
CREATE DATABASE database_name
[ ON
[ < filespec > ......

sql´óÈ«³¬Ïêϸ

  SQL ÃüÁî
Õⲿ·Ö°üº¬ÄÇЩ PostgreSQL Ö§³ÖµÄ SQL ÃüÁîµÄÐÅÏ¢£®ÕâÀïµÄ "SQL" ¾ÍÊǸÃÓïÑÔͨ³£µÄº¬Ò壻 ÿÌõÃüÁîµÄÓë±ê×¼ÓйصļæÈÝÐÔµÄÐÅÏ¢¿ÉÒÔÔÚÏà¹ØµÄ²Î¿¼Ò³ÖÐÕÒµ½£®
Table of Contents
ABORT --  Í˳öµ±Ç°ÊÂÎñ
ALTER GROUP --  Ïò×éÖÐÔö¼ÓÓû§»ò´Ó×éÖÐɾ³ýÓû§ 
ALTER USER --  ¸Ä±äÊý¾ ......

SQL ÅжÏÉí·ÝÖ¤ºÅÂë

ÏÖÒªÇó²éѯ½çÃæ£º²»ÂÛ15λ»òÕß18λÉí·ÝÖ¤ºÅ¶¼Äܲéѯ³öÊý¾Ý¿âÖÐËùÓе±Ç°Óû§ÐÅÏ¢¡£
·½°¸1£º
create or replace function CONVERT_ID_15 (/*ת»»Éí·ÝÖ¤ºÅΪ15λ*/
  p_id2 in varchar2
) return varchar2
is
  p_id varchar2(20);
  id varchar2(15);
begin
  p_id:=ltrim(p_id2);
  p_id ......

SQLÓï¾ä¸´Ï°:insert,update,delete,select

 ×î½üÒ»Ö±ÔÚѧϰSQL serverµÄÄÚÈÝ¡£×òÌ쿼ÁËÒ»ÏÂÊÔ¡£¸Ð¾õÕæµÄÊDz»ÈÝÒ×°¡¡£ÌرðÊÇһЩ¸´ÔӵIJéѯ¡£¸ãµÃÎÒÍ·»èÄÔÕ͵ġ£²»¹ýÒ²ÊÇÓÉÓÚ×Ô¼ºµÄÖªÊ¶ÕÆÎյϹ²»¹»Ôúʵ°¡¡£ËùÒÔ½ñÌ츴ϰÁËÒ»ÏÂT-SQlÓï¾äµÄÔöɾ¸Ä²é¡£·¢ÏÖµÄÈ·ÊÇÓкܶ඼Íü¼ÇÁË¡£ÏÖÔڰѽá¹ûд³öÀ´¡£ÒÔºó¿É²»ÒªÍüÁËѽ¡£
--SQLÓï¾ä¸´Ï° --Ò»,²åÈëinsertÓï¾ä --1,ins ......

¶¯Ì¬SQL»ù±¾Óï·¨

 Select * from tableName
exec('select * from tableName')
exec sp_executesql N'select * from tableName' -- Çë×¢Òâ×Ö·û´®Ç°Ò»¶¨Òª¼ÓN
2:×Ö¶ÎÃû£¬±íÃû£¬Êý¾Ý¿âÃûÖ®Àà×÷Ϊ±äÁ¿Ê±£¬±ØÐëÓö¯Ì¬SQL
declare @fname varchar(20)
set @fname = 'FiledName'
Select @fname from tableName -- ´íÎó,²»»áÌáʾ´í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ