Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



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 5007

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

3 6652

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

1 4350

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

TCS,

12 18450

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 5352

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

2 6301

how to know Who Is Blocking Your SQL Server?

4 9932

How to Get the last identity value used

4 6227

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

1 4100

How to Run a Query on a Remote SQL Server?

2 6757

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

1 3515

What's the purpose of Stored Procedure?

Wipro,

6 13804

What is normalization?

9 8138

What is a Stored Procedure?

8 7978

Can you give an example of Stored Procedure?

Wipro,

4 8039







Un-Answered Questions { SQL Server }

What are relationships and mention different types of relationships in the dbms

178


How to set the current database in ms sql server?

199


What does null mean?

238


what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

183


List some advantages and disadvantages of stored procedure?

198






What is the concept of optimization?

186


What is Federation and Federation Member?

34


What is isnull() operator?

198


What is user-defined multi-statement table-valued function?

288


Differentiate between mongodb vs. Sql server?

196


explain extended properties

205


What is delete query?

168


What are the advantages of having an index on the sql server?

196


What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

217


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

1274