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 39029

What is SQL Profiler what is the use of it?

2 13338

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

4 16587

How many types of cursors are there in SQL Server?

5 22486

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

5 9553

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 6394

Differences between functions and stored procedures?

8 15718

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

12 16551

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

3 6804

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

11 14493

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 4950

What is SQL Profiler and the use of it?

2 5037

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

1 4701

Post New 247Customer SQL Server Interview Questions

247Customer SQL Server Interview Questions

247Customer SQL Server Interview Questions (13)

Un-Answered Questions

What is the use of the drop option in the alter table command?

596

How will change the instance give type for the instances, which are the running in your applications tier and then using auto scaling. Where will you change it from areas?

164

Please explain what are the different types of locators in selenium?

917

write a C program that will determine whether a department -store customer ha exceeded the credit limit on a charge account. For each customer, the following facts are available: a. Account number (an integer) b. Balance at the beginning of the month c. Total of all items charged by this customer this month d. Total of all credits applied to this customer's account this month e. allowed credit limit The program should used a while statement to input each of this facts,calculate the new balance (=beginning balance=charges credits) and determine whether the new balance exceeded,the program should display the customer's account number, credit limit, new balance and the message "Credit Limit Exceeded".

3473

Who created npm?

922

How to identify current user in ssrs report?

403

How do I split a cell into two rows in excel?

636

How does non-cluster index functions?

1139

what exactly are iterator, iterable, and iteration?

916

wht type of intersting things sqa have or what is intersting abt sqa and how it will be advanategous for us as a sqa engineer?

1958

What is string concatenation?

992

What are the angular modules?

792

Explain the main difference between List and Stream in Scala Collection API? How do we prove that difference? When do we choose Stream?

Is nodejs scalable?

522

write a program to find out prime number using sieve case?

2100