247Customer SQL Server Interview Questions Answers, 247Customer Placement Papers, 247Customer Technical, HR Interview Questions, 247Customer Aptitude Test Questions, 247Customer Campus Placements Exam Questions

Company Name Starts with ...

# A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

247Customer SQL Server Interview Questions

Questions Answers Views Company eMail

What is the datatype returned by count(*)

22 39598

What is SQL Profiler what is the use of it?

2 13435

What are the advantages of using views. Why do we need views when we have SPs?

4 16723

How many types of cursors are there in SQL Server?

5 22627

What is the difference between the following two sql statements select count(*) from select count(col_name) from

5 9716

What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.

3 6530

Differences between functions and stored procedures?

8 15954

Can we have more than one NULL in a column having unique constraint?

12 16911

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 6931

please tell me the query to get details of the employee having the second largest salary

11 14844

How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

2 5041

What is SQL Profiler and the use of it?

2 5129

What are SQL Jobs, please mention the use of it and how to create them.

1 4773

Post New 247Customer SQL Server Interview Questions

247Customer SQL Server Interview Questions

247Customer SQL Server Interview Questions (13)

Un-Answered Questions

How would you reverse the characters of an array?

971

Which is better angular material or bootstrap?

919

Difference between bump map and normal map?

1259

What is a link rel?

860

Can you explain data preparation?

380

function of body system

2086

What are possible types of Channel Selectors?

105

What is the value returned by a method when it executes successfully?

1135

what is pile and deam foundation

2404

What are the different ways to display text with silverlight?

How long would you stay with Laura Ashley?

1178

1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????

1973

Why is angular called angular?

831

What are global installations of dependencies?

497

Explain the different row versions available in table?

1115