Skip to main content

Running .Sql file from command prompt


In this article I am demonstrating the running the .sql files form command prompt.

Step -1
create the table using the sql management studio.

CREATE TABLE tbl_Student
(
ID INT IDENTITY(1,1) PRIMARY KEY,
Fname VARCHAR(100),
Lname VARCHAR(100),
Salary INT
)

Step-2

INSERT INTO tbl_Student (Fname,LName,Salary) VALUES('Rakesh','Kalluri',10000)
INSERT INTO tbl_Student (Fname,LName,Salary) VALUES('Srujan','Kumar',15000)
INSERT INTO tbl_Student (Fname,LName,Salary) VALUES('Raju','Bhai',17000)
INSERT INTO tbl_Student (Fname,LName,Salary) VALUES('Dany','Mark',18000)

The above script file is saved in Desktop with the file name of Student.sql . The file is saved in desktop now just we need to run the file from command prompt.

Step-3

Go to run - -> Type CMD - → Click OK














Then command prompt will be opened.

Step -4

Syntax:

sqlcmd -S [Servername] -d[Databasename] -i [Filepath]

Syntax:(For Sql Authentication)

sqlcmd -S[Servername] -U[Username] -P[Password] -d[Databasename] -i[Filepath]












After that check the table how many row affected.

For More information about sqlcmd

Type sqlcmd -? in command prompt















K.Rakesh
Headfirstsql.blogspot.in
Labels:

Comments

Post a Comment

Popular posts from this blog

Rank Functions in SQL SERVER

1 . ROW_NUMBER () OVER ( [PARTITION BY CLAUSE] < ORDER BY CLUASE >): Returns the sequantial number of a row within the a partition of result set at 1 for the first row of the each partition. 2. RANK () OVER ( [PARTITION BY CLAUSE] < ORDER BY CLUASE >): Returns rank for rows within the partition of result set. 3. DENSE_RANK () OVER ( [PARTITION BY CLAUSE] < ORDER BY CLUASE >): Returns rank for rows within the partition of result set.With out any gaps in the ranking. 4. NTILE ( INTEGER_EXPRESSION ) OVER ( [PARTITION BY CLAUSE] < ORDER BY CLUASE >): Distributes the rows in an ordered partition into a specified number of groups. Examples: --create Employee table create table Employee (                 EmpId int identity ( 1 , 1 ) primary key ,              ...
1 comment
Read more

Difference between LEN and DATALENGTH

LEN: LEN function returns the number of characters in a variable .it also removes the trailing spaces and then then return the length. Example-1: DECLARE @Name VARCHAR ( 20 )= 'rakesh' SELECT LEN ( @Name ) as [len] Output: Example-2: DECLARE @Name VARCHAR ( 20 )= 'rakesh ' SELECT LEN ( @Name ) as [len] Output: When we observe above variable assigned 'rakesh ' string after that added 3 spaces . Len function removes trailing spaces not leading spaces. DATALENGTH : DATALENG function returns the number of bytes occupy in a variable .it also considered the spaces also. Example-1: DECLARE @Name VARCHAR ( 20 )= 'rakesh' SELECT DATALENGTH ( @Name ) as [DataLength] Output: Example-2: DECLARE @Name VARCHAR ( 20 )= ' rakesh ' SELECT DATALENGTH ( @Name ) as [DataLength] Output: In above example before ' r ' and after ...
Post a Comment
Read more