Cool SQL Server and SQL Express Command-Line Utility
page 1 of 2
Published: 15 Dec 2005
Unedited - Community Contributed
Abstract
In this article, Scott examines SQL Server 2005 and SQL Express 2005 command line utilities with the help of examples.
by Scott Guthrie
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 13956/ 20
Article Contents:

Introduction

Republished With Permission - Original Article

Brad on my team recently pointed me at a cool command-line SQL/SQL Express utility that might be useful for people to keep in the tool chest.  It is free and you can download it here.

It includes a useful doc-file that walks-through the various commands it provides.  I also found this link useful in walking through how to use common SQL commands for creating new databases.

Here is a simple set of steps that demonstrate how to use it to create a SQL Express database file, attach to it, create a database in it, then add a table, then add values into the table, then do a select query against it (note: all commands I typed are in bold below):

C:\SQLUtility>sseutil -c

Console mode. Type 'help' for more information.

1> !create c:\sqlutility\testing123.mdf

Command completed successfully.

1> !attach c:\sqlutility\testing123.mdf

Command completed successfully.

1> use "c:\sqlutility\testing123.mdf"

2> go

Command completed successfully.

1> create database people

2> go

Command completed successfully.

1> use people

2> go

Command completed successfully.

1> create table names

2> (id INTEGER NOT NULL,

3> name VARCHAR(50) NOT NULL)

4> go

Command completed successfully.

1> insert into names values(1, 'bill gates')

2> go

1 row(s) affected.

1> select * from names

2> go

id   name

------------------

1    bill gates

1 row(s) affected.

1> quit

Of course, an easier way to-do this from scratch would be to use Visual Web Developer or VS 2005 and select Add New Item->Database file, name it, and then use the server explorer to create and add the table.  But the nice thing about the above approach is that you can use it execute a SQL script file to quickly create/re-create your database without needing a tool on your system (or a user who knows how to use it).


View Entire Article

User Comments

Title: mr   
Name: olumarcus
Date: 2008-06-18 9:39:13 PM
Comment:
really cool






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-03-29 1:43:19 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search