sqlcmd is a command line tool for interacting with Sql Server.
Invoke the command prompt.
If your's is a low configuration machine sqlcmd is best tool since Sql Server Management studio is resource hungry.
sqlcmd -S .\sqlexpress
>create database ShalvinPDBlog
>go
>use ShalvinPDBlog
>create table Categories (
CategoryId int primary key identity(1,1),
CategoryName varchar(20), Description varchar(60))
>go
Here -S points to the server name.
Related Blog
Transact Sql
For more information : http://msdn.microsoft.com/en-us/library/ms162773.aspx
The owner of this blog has a strong personality because it reflects to the blog that he/she made.
ReplyDelete