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 6534I 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 6723
How can you find out which stored procedures are recompiling?
What are dml triggers and types of dml triggers?
What is your recommendation for a query running very slow? : sql server database administration
What is self contained scalar sub query?
Are connections to sql server encrypted?
What is difference between aggregate and analytic function?
What are the types of resultset?
How to insert multiple rows with a subquery?
What is simple indexing method?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
explain databases and sql server databases architecture? : Sql server database administration
What do you mean by stored techniques? How would we use it?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What is the difference between char and varchar2 datatype in sql?
What do you mean by subquery?