繁體中文当前位置: 首页 > 图文教程 > 网络编程 > ASP.NET > 开始使用SQLServer2005,没用过MSDE,一开始还不知道怎么下手呢，呵呵
- ASP.NET
- ASP.NET创建XML Web服务全接触(3)
- ASP.NET创建XML Web服务全接触(4)
- ASP.NET创建XML Web服务全接触(5)
- ASP.NET创建XML Web服务全接触(6)
- ASP.NET创建XML Web服务全接触(7)
- ASP.NET创建XML Web服务全接触(8)
- ASP.NET创建XML Web服务全接触(9)
- ASP.NET创建XML Web服务全接触(10)
- ASP.NET创建XML Web服务全接触(11)
- ASP.NET创建XML Web服务全接触(12)
- ASP.NET创建XML Web服务全接触(13)
- ASP.NET创建XML Web服务全接触(14)
- ASP.NET创建XML Web服务全接触(15)
- asp.net高级教程（一）-asp.net or asp+
- asp.net高级教程（二）-转换编程思维
- asp.net高级教程（三）-对象
- asp.net高级教程（四）-实战篇
- asp.net高级教程（五）-实战篇(中)
- ASP.NET 打造互联网未来空间站(1)
- ASP.NET 打造互联网未来空间站(2)
ASP.NET 中的 开始使用SQLServer2005,没用过MSDE,一开始还不知道怎么下手呢，呵呵
出处:互联网 整理: 软晨网（RuanChen.com） 发布: 2009-11-03 浏览: 94 ::
收藏到网摘: n/a
按如下方法（网上查到的）： So onto the Command Prompt ! (wooohooo) SQLCMD.exe will be your friend to explore the Beta 1 build of SQL Express. Here's how: - Open a Command Prompt - SQLCMD -E -S servername\instancename (e.g. SQLCMD -E -S guntherb01\sqlexpress) - select name from sys.databases - go You'll find a list of the default databases in your SQL Express installation (master, tempdb, model, msdb). However, no sample databases - nothing ! So here's an (unofficial) tip to get some sample data in SQL Express (finally, this post is way to long) :-) - Download and install Pubs & NWind T-SQL scripts: http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46a0-8da2-eebc53a68034&DisplayLang=en - SQLCMD -S servername\instance -E (or -U sa -P password) - :r "C:\Program Files\Microsoft SQL Server 2000 Sample Database Scripts\instpubs.sql" - :r "C:\Program Files\Microsoft SQL Server 2000 Sample Database Scripts\instnwnd.sql"
To verify you have successfully loaded the db's : - select name from sys.databases- go- Use pubs- select * from authors- go
Note that these T-SQL scripts were designed for SQL2000 (hence unsupported), but hey, they seemed to run perfectly on my SQL Express machine.
Now start enjoying SQL Express 2005 beta 1 !!!
这个版本的SQLServer2005 express 不包括full-text index
评论 (0) All
