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

hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table

Indecomm,

7 4499

write a query to remove duplicate records without using primary key column?

ABCO,

2 7467

What Is The Difference Between Primary Key & Super Key

Accenture,

3 5014

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

HCL, Wipro,

1413

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 5019

I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access

4 3676

I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

1222

what is Equity join?

ADP,

2 4453

How to get number of days in a given year?

ADP,

4 4397

Differencr Between DELETE and TRUNCATE?

ADP,

3 4543

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

ADP,

2 3554

How to get number of days in a given year?

ADP,

4 5511

Explain SELF JOIN ?

ADP,

3 4803

What is Index ? Explain its Types?

ADP,

2 5567

Define Foreign Key?

ADP, College School Exams Tests,

3 6183







Un-Answered Questions { SQL Server }

What is primary key and example?

100


Tell me in brief how sql server enhances scalability of the database system?

134


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

149


What do you mean by subquery?

173


wat wil hapn if we give the both read and deny read permission to user?

1247






What are various ways to enhance the ssrs report?

139


What are the restrictions while creating batches in sql server?

150


What is an identity column in insert statements?

138


Do you know sql server 2008 introduces automatic auditing?

125


What are the disadvantages of using the stored procedures?

149


Do you know what is a linked server in sql server?

152


What is the full form of dql?

113


What is sql service broker?

151


What is row-level compre?

117


Explain time data type in sal server 2008?

127