Not sure what you are asking
You can run the following in a query window in management studio and get the output - but will be left with the table in a database
CREATE TABLE department
(
dept_no CHAR(4) NOT NULL,
dept_name CHAR(25) NOT NULL,
location CHAR(30) NULL
)
go
insert into department values ('d1', 'developer', 'Dallas')
insert into department values ('d2', 'tester', 'Seattle')
insert into department values ('d3', 'marketing', 'Dallas')
select * from department
What you have there looks like it was the output from something like osql
Cursors never.
DTS - only when needed and never to control.