Sql Sever 2005 ÊÓͼµÄ²Ù×÷
ºÜ¶àÈËÌرðϲ»¶ÓÃÊÓͼ,µ«ÓеÄÈË´ÓÀ´²»ÓÃÊÓͼ.ÕⶼÊÇÁ½ÖÖ²»Á¼µÄÏ°¹ß. ÒªÃ÷È·ÊÓͼ¿ÉÒÔÍê³ÉµÄ¹¤×÷ÒÔ¼°Ê¹Óó¡ºÏ.
1.×èֹѡÔñ±£ÃÜÁÐ
2.½µµÍÓû§¶ÁÈ¡Êý¾Ý¿âÄÚÊý¾ÝµÄ¸´ÔÓÐÔ
3.ÔÚÊý¾Ý¿âÖÐÌí¼ÓË÷ÒýÒÔ¼ÓËÙ²éѯÐÔÄÜ
ÊÓͼµÄºËÐÄÔÚÓÚËü½öÊÇÒ»¸ö±»´æ´¢µÄ²éѯ. Æä×î´óÌصãÊÇÊÇÄã¿ÉÒÔ»ìºÏ»úÆ¥Åä»ù±í(»òÆäËûÊÓͼ)ÖеÄÊý¾Ý,´Ó¶à·½Ã濼ÂÇ,Æ书ÄܾÍÏñÁíÍâÒ»ÕÅ»ù±í.Äã¼È¿ÉÒÔ´´½¨Ò»¸öÖ»´Ó±íÖÐÑ¡ÔñһЩÁеļòµ¥²éѯ,Ò²¿ÉÒÔ´´½¨Ò»¸öÁ¬½Ó¶àÕÅ±í²¢ÈÃÕâЩ±íÏÔʾΪһÕűíµÄ¸´ÔÓ²éѯ.
ÊÓͼÊÇÒ»¸öÐéÄâ±í,ÆäÄÚÈÝÓвéѯ¶¨Òå.ͬÕæʵµÄ±íÒ»Ñù,ÊÓͼ°üº¬Ò»ÏµÁдøÓÐÃû³ÆµÄÁкÍÐÐÊý¾Ý.ÊÓͼÔÚÊý¾Ý¿âÖв¢²»ÊÇÒÔÊý¾ÝÖµ´æ´¢¼¯ÐÎʽ´æÔÚ,³ý·ÇÊÇË÷ÒýÊÓͼ.ÐкÍÁÐÊý¾ÝÀ´×ÔÓÚ×Ô¶¨ÒåÊÓͼµÄ²éѯËùÒýÓõıí,²¢ÇÒÔÚÒýÓÃÊÓͼʱ¶¯Ì¬Éú³É.
¶ÔÆäÖÐËùÒýÓõĻù´¡±íÀ´ËµÊÓͼµÄ×÷ÓÃÀàËÆÓÚɸѡ¡£¶¨ÒåÊÓͼµÄɸѡ¿ÉÒÔÀ´×Ôµ±Ç°»òÆäËûÊý¾Ý¿âÒ»¸ö»ò¶à¸ö±í£¬»òÕßÆäËûÊÓͼ.·Ö²¼Ê½²éѯҳ¿ÉÓÃÓÚ¶¨ÒåʹÓöà¸öÒìÀàÔ´Êý¾ÝµÄÊÓͼ.ÀýÈç,Èç¹ûÓжą̀²»Í¬µÄ·þÎñÆ÷·Ö±ð´¢´æÔÚÄãµÄµ¥Î»ÔÚ²»ÓõØÇøµÄÊý¾Ý,¶øÄãÐèÒª½«ÕâЩ·þÎñÆ÷ÉϽṹÏàËƵÄÊý¾Ý×éºÏÆðÀ´,ÄÇôÕâÖÖ·½Ê½¾ÍºÜÓÐÓÃ.
ͨ¹ýÊÓͼ½øÐвéѯûÓÐÈκÎÏÞÖÆ,¶øÇÒͨ¹ýËûÃǾÐÐÊý¾ÝÐÞ¸ÄʱµÄÏÞÖÆÒ²ºÜÉÙ.
ÊÓͼ´´½¨Óï·¨Óë Create Óï¾äÏàËÆ,
Create View <view name>
As
<Select statement>
µ±È»,ÉÏÃæµÄÓï¾äÖ»´ú±í´´½¨ÊÓͼµÄÓï·¨µÄÒ»²¿·Ö£¬µ«ËüÈÔÈ»ÊÇ×î³£ÓõÄÐÎʽ. À©Õ¹ÈçÏÂ
Crete View[schema_name.]<view name>[(<column name list>)]
[With[Encryption][,Schemabinding][,View_Metadata]]
as
<Select statement>
With Check Option
¹ØÓÚ´´½¨ÊÓͼ,ÐÞ¸ÄÊÓͼ ÖµµÃ×¢ÒâµÄµØ·½
1.²»Äܽ«¹æÔò»ñµÃDefault¶¨Òå¹ØÁªÓÚÊÓͼ
2.¶¨ÒåÊÓͼµÄ²éѯ²»ÄÜÓÐOrder by,Compute,Compute by Óï¾ä
3.Èç¹ûÊÓͼµÄijһÁÐÊÇÒ»¸öËãÊõ±í´ïʽ,¹¹Ô캯Êý»òÕß³£Êý,¶øÇÒÊÓͼÖÐÁ½¸ö»òÕ߸ü¶à²»ÓõÄÁÐÓµÓÐÒ»¸öÏàͬµÄÃû×Ö(ÕâÖÖÇé¿öͨ³£ÊÇÒòΪÔÚÊÓͼµÄ¶¨ÒåÓÐÒ»¸öÁ¬½Ó,¶øÇÒÕâÁ½¸ö»òÕ߶à¸öÀ´×Ô²»Í¬±íµÄÁÐÓÃÓÚÏàͬµÄÃû³Æ) --´ËʱÐèҪΪÊÓͼµÄÿһÁÐÖ¸¶¨ÁеÄÃû³Æ
4.ÔÚÐÞ¸ÄÊÓͼʱÐèÒª°üº
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
SqlCommand com = new SqlCommand("select * from myuser where username=@UserName and password=@Pwd", con);
com.Parameters.Add(new SqlParameter("@UserN ......
SQL ServerÓëExcelÊý¾Ý»¥µ¼
´ÓSQL ServerÖе¼Èë/µ¼³ö Excel µÄ»ù±¾·½·¨
/*=================== µ¼Èë/µ¼³ö Excel µÄ»ù±¾·½·¨ ===================*/
´ÓExcelÎļþÖÐ,µ¼ÈëÊý¾Ýµ½SQLÊý¾Ý¿âÖÐ,ºÜ¼òµ¥,Ö±½ÓÓÃÏÂÃæµÄÓï¾ä:
/*========================================================*/
--Èç¹û½ÓÊÜÊý¾Ýµ¼ÈëµÄ±íÒѾ´æÔÚ
ins ......
Aaron Bertrand
Adam Machanic
All Things SQL Server
Allen Kinsel - SQL DBA
Allen White
Amit Bansal writes...
Andrew Fryer's Blog
Andrew Kelly
Andy Leonard
Anything and Everything IT
Arcane Code
Arnie Rowland: Ramblings of a Harried Technogeek
B.I. for the SQL Guy
Bart Duncan's SQL Weblog ......