Is it possible to create a stored procedure that runs a query and outputs

Advertise your Business Here

Refer this Site

Login | Sign Up


	Ask Questions on ANYTHING, that arise in your Daily Life at FORUM9.COM

Categories >> Software >> Databases >> SQL Server

Oracle Interview Questions

SQL Server Interview Questions

MS Access Interview Questions

MySQL Interview Questions

Postgre Interview Questions

Sybase Interview Questions

DB Architecture Interview Questions

DB Administration Interview Questions

DB Development Interview Questions

SQL PLSQL Interview Questions

Databases AllOther Interview Questions

Question

Is it possible to create a stored procedure that runs a 
query and outputs the results to a text file and allows me 
to add extra delimeters and static field info. If so How?

Question Submitted By :: Guest

I also faced this Question!!

Rank

Answer Posted By

Re: Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

Answer
# 1

SQL Server has no native command for outputting query
results to a file. You can use the extended 
stored procedure xp_cmdshell and call isql (command-line
SQL) with your query and output the results to a file. Any
delimiters would need to be part of the SELECT string: 

DECLARE @isqlString varchar(255)

SELECT @isqlString = 'isql -Q "SELECT DateCol FROM
NorthwindTest.dbo.Test" -E -o C:\Results.txt'

EXEC master..xp_cmdshell @isqlString

Is This Answer Correct ?

0 Yes

0 No

Guest

Question	Asked @	Answers
Other SQL Server Interview Questions


What is a view?		1
hi i gone though satyam interview. what is Acid Properties?	Satyam	2
Is trigger fired implicitely?		2
in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.		7
i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..		1
How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?		1
What are defaults? Is there a column to which a default can't be bound?		2
you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required		2
Advantages and Disadvantages of Cursor?	Zenith	4
What is normalization?		5
When do you create cluster and noncluster index?	Satyam	4
What r sql reporting services and analysis services? how can we use it.		2
What is Covering Indexes? Plz explain with example		1
Which virtual table does a trigger use?		3
What is the difference between a stored procedure and a user defined function in sql server?	Millennium	2
What is the system function to get the current user's user id?	HCL	1
what is the difference between sql query and google query?	TCS	2
What is a transaction and what are ACID properties?	IBM	2
one table has four field id,name,design,salary. i have to find maximum salary .		6
Why we need a group by clause?		3

For more SQL Server Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com