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

SQLÕù°ÔÈüÊÔÌâ¼°²Î¿¼´ð°¸

1.ijҽԺ²¡·¿¼ÆËã»ú¹ÜÀíÖÐÐèÒªÈçÏÂÐÅÏ¢£º£¨15·Ö£©
¿ÆÊÒ£º¿ÆÃû£¬¿ÆµØÖ·£¬¿Æµç»°
²¡·¿£º²¡·¿ºÅ£¬ËùÊô¿ÆÊÒÃû
Ò½Éú£ºÐÕÃû£¬Ö°³Æ£¬ËùÊô¿ÆÊÒÃû£¬ÄêÁ䣬¹¤×÷Ö¤ºÅ
²¡ÈË£º²¡ÀúºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬Õï¶Ï£¬Ö÷¹ÜÒ½Éú£¬²¡·¿ºÅ£¬ÈëסÈÕÆÚ
ÆäÖУ¬Ò»¸ö¿ÆÊÒÓжà¸ö²¡·¿¡¢¶à¸öÒ½Éú£¬Ò»¸ö²¡·¿Ö»ÄÜÊôÓÚÒ»¸ö¿ÆÊÒ£¬Ò»¸öÒ½ÉúÖ»ÊôÓÚÒ»¸ö¿ÆÊÒ£¬µ«¿É¸ºÔð¶à¸ö²¡È˵ÄÕïÖΣ¬Ò»¸ö²¡È˵ÄÖ÷¹ÜÒ½ÉúÖ»ÓÐÒ»¸ö£¬Ò»¸ö²¡ÈË¿ÉÄÜÔÚ²»Í¬Ê±¼äÈëס²»Í¬µÄ²¡·¿£¬Ò²ÊǾÍ˵һ¸ö²¡ÈËÒ²ÐíÈëס¹ý¶à¼ä²¡·¿£¬Ò»¼ä²¡·¿¿ÉÒÔÈëס¶àÃû²¡ÈË¡£
Íê³ÉÈçÏÂÉè¼Æ£º
£¨1£©       Éè¼Æ¸Ã¼ÆËã»ú¹ÜÀíϵͳµÄE£­Rͼ£¨7·Ö£©£»
´ð°¸£¨ÊµÌåÉϵÄÊôÐÔÃèÊö¼°¹ØÏµÃèÊöÂÔ£©»­³öËĸöʵÌåͼ£¬È»ºó¹ØÏµÃèÊöÕýÈ·¼´¿É¡£
 
£¨2£©       ½«¸ÃE-Rͼת»»ÎªÊý¾Ý¿âÄ£ÐÍͼ(±íÃûºÍ×Ö¶ÎÃû¶¼¿ÉÒÔÓÃÖÐÎÄÀ´Ð´)£¨8·Ö£©£»
´ð°¸£º
2. £¨75·Ö£©
±íÃû
S
×÷ÓÃ
´æ´¢Ñ§ÉúÐÅÏ¢
Ö÷¼ü
SNO
ÐòºÅ
×Ö¶ÎÃû³Æ
×Ö¶Î˵Ã÷
ÀàÐÍ
ÊôÐÔ
±¸×¢
1
SNO
Ö÷¼ü£¬Ñ§ºÅ
Varchar(5)
·Ç¿Õ
ѧºÅ±ØÐëΪÊý×Ö
2
SName
ѧÉúÐÕÃû
Nvarchar(50)
·Ç¿Õ
ÐÕÃûΨһ
3
Age
ÄêÁä
Int
·Ç¿Õ
1~100
4
Sex
ÐÔ±ð
Nvarchar(1)
·Ç¿Õ
ĬÈÏΪÄУ¬Ö»ÄÜÌîдÄкÍÅ®
 
±íÃû
C
×÷ÓÃ
´æ´¢¿Î³ÌÐÅÏ¢
Ö÷¼ü
CNO
ÐòºÅ
×Ö¶ÎÃû³Æ
×Ö¶Î˵Ã÷
ÀàÐÍ
ÊôÐÔ
±¸×¢
1
CNO
Ö÷¼ü£¬¿Î³ÌºÅ
char(2)
·Ç¿Õ
¿Î³ÌºÅ³¤¶È±ØÐëΪ2
2
CName
¿Î³ÌÃû
Nvarchar(50)
·Ç¿Õ
Ψһ
3
Teacher
ÀÏʦÐÕÃû
Nvarchar(50)
·Ç¿Õ
 
 
±íÃû
SC
×÷ÓÃ
´æ´¢³É¼¨ÐÅÏ¢
Ö÷¼ü
CNO,SNO
ÐòºÅ
×Ö¶ÎÃû³Æ
×Ö¶Î˵Ã÷
ÀàÐÍ
ÊôÐÔ
±¸×¢
1
CNO
¿Î³ÌºÅ£¬Íâ¼ü
char(2)
·Ç¿Õ
¿Î³ÌºÅ³¤¶È±ØÐëΪ2
2
SNO
ѧÉúºÅ£¬Íâ¼ü
Varchar(5)
·Ç¿Õ
ѧºÅ±ØÐëΪÊý×Ö
3
Grade
³É¼¨
Int
·Ç¿Õ
0~100
 
2.1 д³öSQLÓï¾ä£¬½¨Á¢Ñ§ÉúÊý¾Ý¿âStudent£¬²¢°´ÒÔÉÏÒªÇó½¨Á¢±í£¬Ô¼Êø£¨13·Ö£©£¨´ð°¸ÂÔ£©£»
2.2 ²åÈëһϲâÊÔÊý¾Ý£º£¨2·Ö£©
INSERT [C] ([CNO],[CName],[Teacher]) VALUES ( 'k1','CÓïÑÔ','Íõ»ª')
INSERT [C] ([CNO],[CName],[Teacher]) VALUES ( 'K5','Êý¾Ý¿âÔ­Àí','³Ì¾ü')
INSERT [C] ([CNO],[CName],[Teacher]) VALUES ( 'K8','±àÒëÔ­Àí','³Ì¾ü')
 
INSERT [S] ([SNO],[SName],[Age],[sex]) VALUES ( '1','ÀîÇ¿',23,'ÄÐ')
INSERT [S] ([SNO],[SName],[Age],[sex]) VALUES ( '2','ÁõÀö',22,


Ïà¹ØÎĵµ£º

sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ ......

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 ......

¹ØÓÚ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
=
......

sql Óï¾ä exec Ö´ÐÐ×Ö·û´®

create PROCEDURE [dbo].[AllDnn_NewsPublish_DeleteArticleByArticle]
@ArticleID nvarchar(200)
AS

declare @sql nvarchar(1000)
set @sql='DELETE dbo.Site_News_Article where ArticleID in ('+@ArticleID+')'
exec (@sql)
--[AllDnn_NewsPublish_DeleteArticleByArticle] '50,51' ......

SQL ServerËÀËø×ܽá

1.
ËÀËøÔ­Àí
   
¸ù¾Ý²Ù×÷ϵͳÖе͍Ò壺ËÀËøÊÇÖ¸ÔÚÒ»×é½ø³ÌÖеĸ÷¸ö½ø³Ì¾ùÕ¼Óв»»áÊͷŵÄ×ÊÔ´£¬µ«Òò»¥ÏàÉêÇë±»ÆäËû½ø³ÌËùÕ¾Óò»»áÊͷŵÄ×ÊÔ´¶ø´¦ÓÚµÄÒ»ÖÖÓÀ¾ÃµÈ´ý״̬¡£
   
ËÀËøµÄËĸö±ØÒªÌõ¼þ£º
»¥³âÌõ¼þ
(Mutual exclusion)
£º×ÊÔ´²»Äܱ»¹²Ïí£¬Ö»ÄÜÓÉÒ»¸ö½ø³ÌʹÓá£
ÇëÇóÓë± ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ