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

MS SQL 2005 32/64λÏÂÔØ

MS SQL 2005 32/64λÏÂÔØ
thunder://QUFmdHA6Ly9TaGFyZToxNjQzQHd3dy5zb293ZWIubmV0L1NoYXJlL1NlcnZlci9NaWNyb3NvZnQlMjBTUUwlMjBTZXJ2ZXIlMjAyMDA1L1NRTC4yMDA1LmFsbC5jaHMuaXNvWlo=
Microsoft SQL Server 2005 CHN 32λ CD1
ed2k://|file|%5B%E5%BE%AE%E8%BD%AFSQL%E6%9C%8D%E5%8A%A1%E5%99%A82005%E7%AE%80%E4%BD%93%E4%B8%AD%E6%96%87%E7%89%88%5D.Microsoft.SQL.Server.2005.CHN.CD2.iso|635772928|ba2aeef53dc9f3ccd55f27220446708b|h=73lf2b6wzntcvgobwoaedy5275so7iki|/
Microsoft SQL Server 2005 CHN 32λ CD2
ed2k://|file|%5B%E5%BE%AE%E8%BD%AFSQL%E6%9C%8D%E5%8A%A1%E5%99%A82005%E7%AE%80%E4%BD%93%E4%B8%AD%E6%96%87%E7%89%88%5D.Microsoft.SQL.Server.2005.CHN.CD1.iso|441892864|caabf976f9b4591007b6157814661988|h=dxb5msxvf3psish3svv7x7lx7cyji2e5|/
SQL2005 ·ÖÎå¸ö°æ±¾£¬ÈçÏÂËùÁУº
SQL Server 2005 Enterprise Edition£¨32 λºÍ 64 룩
Enterprise Edition ´ïµ½ÁËÖ§³Ö³¬´óÐÍÆóÒµ½øÐÐÁª»úÊÂÎñ´¦Àí (OLTP)¡¢¸ß¶È¸´ÔÓµÄÊý¾Ý·ÖÎö¡¢Êý¾Ý²Ö¿âϵͳºÍÍøÕ¾ËùÐèµÄÐÔÄÜˮƽ¡£Enterprise Edition µÄÈ«ÃæÉÌÒµÖÇÄܺͷÖÎöÄÜÁ¦¼°Æä¸ß¿ÉÓÃÐÔ¹¦ÄÜ£¨Èç¹ÊÕÏתÒÆȺ¼¯£©£¬Ê¹Ëü¿ÉÒÔ´¦Àí´ó¶àÊý¹Ø¼üÒµÎñµÄÆóÒµ¹¤×÷¸ººÉ¡£Enterprise Edition ÊÇ×îÈ«ÃæµÄ SQL Server °æ±¾£¬Êdz¬´óÐÍÆóÒµµÄÀíÏëÑ¡Ôñ£¬Äܹ»Âú×ã×ÔÓµÄÒªÇ󡣸ð汾»¹ÍƳöÁËÒ»ÖÖÊÊÓÃÓÚ 32 λ»ò 64 λƽ̨µÄ 120 Ìì Evaluation Edition¡£
SQL Server 2005 Standard Edition£¨32 λºÍ 64 룩
Standard Edition ÊÇÊʺÏÖÐСÐÍÆóÒµµÄÊý¾Ý¹ÜÀíºÍ·ÖÎöƽ̨¡£Ëü°üÀ¨µç×ÓÉÌÎñ¡¢Êý¾Ý²Ö¿âºÍÒµÎñÁ÷½â¾ö·½°¸ËùÐèµÄ»ù±¾¹¦ÄÜ¡£Standard Edition µÄ¼¯³ÉÉÌÒµÖÇÄܺ͸߿ÉÓÃÐÔ¹¦ÄÜ¿ÉÒÔΪÆóÒµÌṩ֧³ÖÆäÔËÓªËùÐèµÄ»ù±¾¹¦ÄÜ¡£Standard Edition ÊÇÐèҪȫÃæµÄÊý¾Ý¹ÜÀíºÍ·ÖÎöƽ̨µÄÖÐСÐÍÆóÒµµÄÀíÏëÑ¡Ôñ¡£
SQL Server 2005 Workgroup Edition£¨½öÊÊÓÃÓÚ 32 룩
¶ÔÓÚÄÇЩÐèÒªÔÚ´óСºÍÓû§ÊýÁ¿ÉÏûÓÐÏÞÖƵÄÊý¾Ý¿âµÄСÐÍÆóÒµ£¬Workgroup Edition ÊÇÀíÏëµÄÊý¾Ý¹ÜÀí½â¾ö·½°¸¡£Workgroup Edition ¿ÉÒÔÓÃ×÷Ç°¶Ë Web ·þÎñÆ÷£¬Ò²¿ÉÒÔÓÃÓÚ²¿ÃÅ»ò·ÖÖ§»ú¹¹µÄÔËÓª¡£Ëü°üÀ¨ SQL Server ²úƷϵÁеĺËÐÄÊý¾Ý¿â¹¦ÄÜ£¬²¢ÇÒ¿ÉÒÔÇáËɵØÉý¼¶ÖÁ Standard Edition »ò Enterprise Edition¡£Workgroup Edition ÊÇÀíÏëµÄÈëÃż¶Êý¾Ý¿â£¬¾ßÓпɿ¿¡¢¹¦ÄÜÇ¿´óÇÒÒ×ÓÚ¹ÜÀíµÄÌص㡣
SQL Server 2005 Developer Edition£¨32 λºÍ 64 룩


Ïà¹ØÎĵµ£º

SQL Server µÄÁ¬½Ó¡¢²éѯÓë¸üÐÂ

#Region " ÃüÃû¿Õ¼ä "
Imports System.Data
Imports System.Data.SqlClient
#End Region
Public Class DBCommon
Implements IDisposable
#Region " ³ÉÔ±±äÁ¿ "
Private conn As SqlConnection
Private cmd As SqlCommand
Private trans As SqlTransaction
#End Region
#Region " ¹¹Ô캯Êý "
......

SQL Server 2005: Recursive Hierarchies to XML

Suppose we have a recursive hierarchy stored in a relational database and we want to write it to XML.  This might be for a variety of reasons – e.g. as a pre-cached input to a UI control, to export to another system using a pre-defined format, etc.
 
In SQL Server 2000, in order to ......

SQL serverÑ­»·ÖÐÿ¸ôÒ»¶Îʱ¼ä,ÔËÐÐÒ»´ÎÓï¾ä

×î½ü×öÒ»¸öÏîÄ¿,˵ÆðÀ´±È½Ï¶ñ,ÊÇ´ÓÁíÒ»¸ö±íÖжÁÈ¡Êý¾ÝË͵½Õâ¸ö±íÖÐ.¶øÇÒÒªÓô¥·¢Æ÷Ñ­»·ÕâЩÄÚÈÝÔÙ·¢³öÈ¥.
¿ÉÊÇÈç¹ûÕâ¸öÊý¾ÝÁ¿ºÜ´óµÄ»°,»áÒ»ÏÂ×Ó¹ÒËÀ.ËùÒÔ¾ÍÏëµ½ÁË.Äܲ»ÄÜ,ÿ´ÎÎÒ´«Ò»µã,¸ô¼¸ÃëÔÙËÍÒ»µã.
ÏÂÃæÊÇÒ»¸ö¼òµ¥µÄÀý×Ó
declare @i int
set @i=1
while @i<101
begin
insert into Cname ([name],csex,Number) ......

sqlÓï¾ä

select *from student
select student_id from student
select student_id ,student_name from student
select student_id student_name from student  ½«student_name ×÷Ϊstudent_idµÄ±ðÃû´¦Àí
È磺   select student_id a from student
 select a=student_id from student
´Óstudent±íÖзֱð¼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ