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

sqlµÄÊÓͼ - MS-SQL Server / »ù´¡Àà

Çë¸ßÊÖ¾ßÌå˵˵ÊÓͼµÄÓÃ; ¸úÓ÷¨ »¹ÓÐÓï¾ä£¡
´´½¨ÊÓͼµÄÌõ¼þ µÈµÈ лл··
http://blog.csdn.net/feixianxxx/archive/2009/11/11/4798287.aspx
²Î¿´

http://baike.baidu.com/view/71981.htm?fr=ala0_1_1

·¶Î§Ì«´óÁË,˵¾ßÌåµã

ÏëÒªÄãµÄ·ÖËùÒÔÀ´ÁË¡£

create view view_name
as 
ÕâÀïÊÇÒ»°ãÓòéѯÓï¾äµÄ

ÄãÓõϰֱ½Ó select * from view_view

ÇëÎÊÒ»¸öÊý¾Ý¿âÀïÃæ²»ÄÜÓÐÁ½ÕÅÊÓͼÂð£¿

ÊÓͼ¾ÍÊÇÒ»¸ö²éѯ OKÁË ¸ø·Ö°É

ÊÓͼÀï²¢²»±£´æÈκÎÊý¾Ý£¬ËüÖ»ÊÇÒ»¸ö²éѯÓï¾ä£¬Ö´ÐÐËüµÄʱºò¸ù¾Ý´´½¨Ìõ¼þÈ¥±íÀïÈ¡Êý¾Ý£¬ÓÃÊÓͼÖ÷ÒªÊÇ·½±ãȨÏÞ¹ÜÀí£¬ÈÃijЩ×Ö¶ÎÈÃÏìÓ¦µÄÈ˲Ù×÷£¬ÓкöàÓÃ;Ҫ×Ô¼º¿´¿´×ÊÁϵġ£

crate view ÊÓͼÃû
as 
begin
  Óï¾ä¡£¡££¨ÀýÈ磺select * from student£©
end

µ÷ÓõÄʱºò:select * from view


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

ASPÁ´½ÓSQLµÄ¼òµ¥µÇ½½çÃæ - .NET¼¼Êõ / ASP.NET

protected void btnLogin_Click(object sender, EventArgs e)
  {
  SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......

vs2008 Á¬½Ómysql£¿ - MS-SQL Server / »ù´¡Àà

ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐË­ÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿

ÒýÓÃ
ÇëÎÊ
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ