0
Answer

SQL - extracting individual query from a SQL file

Ask a question
Preetham

Preetham

14y
1.5k
1

Hi, I have set of queries in a file like
/*Start of file*/
Select * from Employee
Update EmpDetails Set Location = 'NY'
Insert into Employee1 Select * From Employee
Insert into EMployee1 Values ('1', 'Mick', 'John')
Delete from Emplooyee1 Where 1 = 2
Select From Employee
Union All
Select From Employee1
/*Send of file*/
I need to break into
/*File1*/
Select * from Employee
/*File2*/
Update EmpDetails Set Location = 'NY'
.
.
.
/*FileN*/
Select From Employee
Union All
Select From Employee1