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 4298
How do I compare two values when one value(data type) is char and the other is an integer?3 5922
What are the pros and cons of creating extended stored procedures?1 3823
I 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 4824
How to Check Whether a Global Temporary Exists in a SQL Database or not?2 5622
how to know Who Is Blocking Your SQL Server?4 8684
How to Get the last identity value used4 5246
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?1 3548
How to Run a Query on a Remote SQL Server?2 6060
How to Generate a Series of Random Integers With T-SQL?1 2915
What is normalization?9 6643
What is a Stored Procedure?8 6364
Can you give an example of Stored Procedure?4 6852
wat wil hapn if we give the both read and deny read permission to user?
what is isolation level at dead lock?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
how can u get last observation in an unknown dataset ?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
How do use Having,Group by,Group function in SQL?
Call by value and call by reference in procedure and function, with NOCOPY.
How we create SQL Server 2005 Reporting Services ? Give me Sample
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is the difference between online clustering and Offline clustering?
how many no of arguments can be passed in procedures and functions
Why we need to use secondry database file? though, we can do same work using primary database file also.
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?