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

¹ØÓÚSQLÓï¾ä

½ñÌìÐ´ÍøÕ¾µÄʱºòºÜ囧°¡£¬·¢ÏÖ²éÕÒÓû§È¨ÏÞµÄʱºòÎÞÔµÎ޹ʵÄͬһ¸öȨÏÞÖØ¸´³öÏֺܶà´Î
Ð޸ĺóµÄSQLÓï¾äÈçÏÂ
SELECT
node
.
id
,
node
.
name
,
access
.
role_id
from
think_role_user
AS
user
,
think_access
AS
access
,
think_node
AS
node
WHERE
user
.
user_id
=
5
AND
access
.
role_id
=
user
.
role_id
AND
access
.
level
=
3
AND
access
.
node_id
=
node
.
id
LIMIT
0
,
30
ÆäÖÐNODEÊÇȨÏ޽ڵ㣬ACCESSÊÇȨÏÞºÍÓû§ËùÔÚ×é¶ÔÓ¦µÄ½Úµã£¬USERÊÇÓû§ÓëÆäËùÔÚ×éÖ®¼äµÄ±í£¬ÕâÑùд³öÀ´µÄSQLÓï¾ä¾ÍÄܹ»ÕýÈ·²éѯÁË
ÎÒ·¢ÏÖÎÒ´íÎóµÄµØ·½ÊǶàÒýÈëÁËÁíÒ»¸öÎÞ¹ØµÄ±í£¬¾ÍÊÇ˵fromÀïÃæ¶à³öÀ´ÁíÒ»¸ö±í£¬Ò»¿ªÊ¼ÎÒÒÔΪûÓвî±ð£¬ºóÀ´²Å·¢ÏÖ¶àÒ»¸öÄÇÑùµÄ±í£¬Í¬Ò»¸ö²éѯ½á¹û¾Í»á¶à³öÄǸö±íµÄ½Úµã¸öÊý±¶¡£¡£¡£
¶÷£¬ºÜ¾ÃûÓÐд¹ýSQL£¬½ñÌìËãÊǸ´Ï°ÁËһϡ£ºÜ²»´í~~~~


Ïà¹ØÎĵµ£º

SQLÖеÄDDL,DML,DCLÓïÑÔ

     ¸Ð¾õ×Ô¼ºÊDZȽϱ¿µÄ£¬Ñ§Ï°¹ýSQLÓïÑÔ£¬µ«ÊÇÈ´·Ö²»Ì«Çå³þDDL¡¢DML¡¢DCLÓïÑÔ£¬ËùÒÔÄØ£¬½ñÌì¾Íºñ×ÅÁ³Æ¤ÎÊÁËÀÏʦ£¬ÏÖÔÚ¾Í×Ô¼ºÄ¿Ç°µÄÁ˽âÀ´×ܽáһϡ£
1¡¢DDL£¨DATA DEFINITION LANGUAGE£©Êý¾ÝÃèÊöÓïÑÔ
     DDLÓï¾ä²»»á²úÉú»¹Ô­Êý¾Ý£¬ËùÒÔɾ³ýµÄÊý¾ÝÒ²ÊÇÎÞ·¨»Ö¸´µÄ
CREATE - to ......

sql server 2008 ·ÖÇø±íÎÊÌâ

    ¹«Ë¾Óиö±¨±íϵͳÏìÓ¦ËٶȲ»ÊǺÜÀíÏ룬µ÷Óŵ÷Á˺ü¸´Î£¬ÓеãЧ¹û£¬µ«²»ÊǺÜÈÃÈËÂúÒâ¡£×î½üÓÖ¿ªÊ¼µ÷ÓÅ£¬ÊÔÁËÊÔsql server 2008µÄ·ÖÇø±í¹¦ÄÜ£¬¿´¿´ÊDz»ÊÇ·ÖÇøÖ®ºóËÙ¶È¿ÉÒÔ¿ìÒ»µã¡£
    ÓÃÁËÒ»¸ö°ÙÍò¼¶Êý¾ÝµÄ»ã×ܱíÀ´×ö·ÖÇø£¬·ÖÇøµÄÏë·¨Êǰ´ÔÂÀ´·ÖÇø£¬Ò»¸ö·ÖÇø´æ´¢Ò»¸öÔµÄÊý¾Ý£¬Ò»¸ö·ÖÇøµ ......

sqlÊý¾Ý¹ýÂË

 
Ò». ²éÕÒÖØ¸´¼Ç¼
1. ²éÕÒÈ«²¿Öظ´¼Ç¼
Select * from ±í Where ÖØ¸´×Ö¶Î In (Select ÖØ¸´×Ö¶Î
from ±í Group By ÖØ¸´×Ö¶Î Having Count(*)>1)
2. ¹ýÂËÖØ¸´¼Ç¼(Ö»ÏÔʾһÌõ)
Select * from HZT Where ID In (Select Max(ID) from HZT Group By Title)
×¢£º´Ë´¦ÏÔʾID×î´óÒ»Ìõ¼Ç¼
¶þ. ɾ³ýÖØ¸´¼Ç ......

SQL Êý¾Ý¿â¼ä¸´ÖƱí

·½·¨Ò»£º
DB1  tb1  
DB2  tb2
Ñ¡ÔñDB1 µ½±íµÄÁбíÄÇÀï
Ñ¡Ôñtb1±í ÓÒ¼ü ËùÓÐÈÎÎñ Êý¾Ýµ¼³ö
ÏÂÒ»²½  Ñ¡ÔñÄãÒªµ¼³öµÄÊý¾Ý¿âDB1  ÏÂÒ»²½ Ñ¡ÔñÄãÒªµ¼ÈëµÄÊý¾Ý¿âDB2
ÏÂÒ»²½  Ñ¡ÔñÄãÒªµ¼µÄ±í£¨Ç°Ãæ»­¹´£©tb1£¬ ºóÃæ¶ÔÓ¦µÄÊÇÐÂÊý¾Ý¿âµÄ±íÃûtb2£¨Ä¬ÈÏÊÇÏàͬ±íÃû£¬¿ÉÐ޸ģ© ÏÂÒ»²½ ÍêÁË ......

sql server 2000µÄ·ÖÒ³´æ´¢¹ý³Ì

 ´æ´¢¹ý³ÌgetRecordfromPageµÄÄÚÈÝ
//getRecordfromPage.sql
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[getRecordfromPage]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[getRecordfromPage]
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
G ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ