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?
1 6454I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?
1 6622
Name three of the features managed by the surface area configuration tool? : sql server security
What is a non clustered primary key?
What is apply operator in sql?
 Explain what is sql override for a source taLle in a mapping?
How to filter records of table in SQL SERVER?
How to count duplicated values in a column in ms sql server?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
How to update values in a table with update statements in ms sql server?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
What is the difference between local and global temporary tables?
Explain the categories of stored procedure?
How to run sql server 2005 books online on your local system?
What is Replication?
What is the difference between lock, block and deadlock? : sql server database administration
Is the log file is a part of file group?