使用SQLServer2005
2024-07-21 02:25:08
供稿：網友
按如下方法（網上查到的）：
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
