繁体中文
设为首页
加入收藏
当前位置:.Net技术首页 >> Asp.Net开发 >> 使用SQLServer2005

使用SQLServer2005

2007-05-15 08:00:00  作者:  来源:互联网  浏览次数:0  文字大小:【】【】【
简介:按如下方法(网上查到的): 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 ser...
关键字:SQLServer2005

按如下方法(网上查到的):

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

责任编辑:admin
相关文章