使用SQLServer2005

新客网 XKER.COM 2004-08-12 来源： 收藏本文

按如下方法（网上查到的）：

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

• ·身份证函数 查看身份证地区信息
• ·VS2008 第一次安装心得及使用
• ·ASP.NET 2.0跨网页提交的三法
• ·编程实例 WebGroupBox(Aspx控件)
• ·asp.net mvc脚手架代码生成工具
• ·用独立的DLL来存储图片(资源文件)
• ·ASP.NET中多国语言的实现方法
• ·实例 .net生成静态页方法总结
• ·ASP.NET控件学习笔记之ViewState
• ·用递归在TreeView价节点
• ·经验总结 关于.NET 中的Event机制
• ·.NET应用程序开发标准化(z)
• ·在DataTable中查询应该注意的问题
• ·LINQ 中调用存储过程自动绑定列名
• ·如何用.NET技术在线生成网站LOGO
• ·对于访问IIS元数据库失败的解决