Preetham

Preetham

  • NA
  • 6
  • 13.6k

SQL - extracting individual query from a SQL file

Aug 8 2010 3:17 AM

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