starclick

Friday 8 March 2013

SQL Database Create and query execuate in cmd

Start - Run-
osql -E
use master
go
create database selva(database name)
go
exit

chk db is created

for multi instance systems
------------------------------
osql.exe -E -S .\SQLExpress

query execute
-------------

sqlcmd -s sys41\sqlexpress -i C:\fees.sql -d selva

before using command prompt u have share sql server - pipe and tcp/ip

No comments:

Post a Comment

Every Admin Should Know These Commands Active Directory 1.   To quickly list all the groups in your domain, with members, run this c...