Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 룩


Ïà¹ØÎĵµ£º

Discuz!NT 3.0 SQL×¢Èë©¶´

 ·¢±íϱ¾È˽øÐЩ¶´ÍÚ¾òµÄÊׯªÔ­´´ÎÄÕ£º
¶ÔDiscuz nT3.0½øÐÐÁË·ÖÎö£¬·¢ÏÖspacemanage.aspxÒ³Ãæ´æÔÚÒ»¸ö×¢Èë©¶´£¬
¸ÃÒ³ÃæÎ»Öãºdnt3_src\dnt3\Discuz.Web\space\Admin
´úÂëÈçÏ£º
public void BindData()
{
DataGrid1.AllowCustomPaging = true;
string username = Usernam ......

һЩ»ù±¾µÄSQLÃüÁî

--ÏÔʾ°æ±¾ºÅ£¬µ±Ç°ÈÕÆÚ
SELECT VERSION(),CURRENT_DATE(),NOW();
--Ãâ·ÑµÄ¼ÆËãÆ÷
SELECT (20+5)*4 AS RESULT,SIN(PI()/3);
--´´½¨Êý¾Ý¿â
CREATE DATABASE databasename;
--ɾ³ýÊý¾Ý¿â
DROP DATABASE databasename;
--ÏÔʾµ±Ç°´æÔÚµÄÊý¾Ý¿â
SHOW DATABASES;
--Ñ¡ÔñÊý¾Ý¿â
USE ......

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ºÅ