SQL Server Interview Questions
Questions Answers Views Company eMail

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 4483

How do I compare two values when one value(data type) is char and the other is an integer?

3 6092

What are the pros and cons of creating extended stored procedures?

1 3969




Is it possible to delete duplicate rows in a table without using a temporary table ?

TCS,

12 15658

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 4969

How to Check Whether a Global Temporary Exists in a SQL Database or not?

2 5783

how to know Who Is Blocking Your SQL Server?

4 8961

How to Get the last identity value used

4 5445




How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 3720

How to Run a Query on a Remote SQL Server?

2 6249

How to Generate a Series of Random Integers With T-SQL?

1 3067

What's the purpose of Stored Procedure?

Wipro,

6 12179

What is normalization?

9 6912

What is a Stored Procedure?

8 6695

Can you give an example of Stored Procedure?

4 7063


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is the difference between online clustering and Offline clustering?

1287


where the connection string store in the database

898


1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

1430


how to take backup bcp out for a column in table in sql server?

924


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

853






in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

380


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

894


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

930


How can we call UDF(User Define Function) using C# code in ASP.net ?

4823


How to trouble shoot if unable to connect SQL Server

853


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4881


how to do partition in sqlserver

1372


How to restore performance issues and how to check?

918


What is Lock table in SQL?

354


Scalability, Availability, Integration with internet, etc.)?

1740