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 3414

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

ABCO,

2 6243

What Is The Difference Between Primary Key & Super Key

Accenture,

3 4238




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

Wipro, HCL,

1047

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 4373

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 2914

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

821

what is Equity join?

ADP,

2 3717




How to get number of days in a given year?

ADP,

4 3492

Differencr Between DELETE and TRUNCATE?

ADP,

3 3799

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

ADP,

2 2914

How to get number of days in a given year?

ADP,

4 4511

Explain SELF JOIN ?

ADP,

3 3805

What is Index ? Explain its Types?

ADP,

2 4628

Define Foreign Key?

ADP, College School Exams Tests,

3 5363


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is the query optimization statistics?

1178


Which is the best place or learning center for MS SQL?????In Bangladesh?????

829


how can u get last observation in an unknown dataset ?

1083


on line cluster can we make if yes tell me the procedure

793


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

830






what exactly sql injuction.how to overcome.....

1263


How much memory that we are using in Logshipping Concept?

661


last function used in MS Access to convert sql what function will use in sql

808


Tell about MOM Tool(Microsoft Operator Manager)?

634


Explain Capacity planning to create a database? and how to monitor it?

2712


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

1195


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

1450


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

889


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

1590


How to restore performance issues and how to check?

798