1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


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 6225

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

ABCO,

2 8416

What Is The Difference Between Primary Key & Super Key

Accenture,

3 6179

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,

1785

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 5810

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 4784

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

 1642

what is Equity join?

ADP,

2 5776

How to get number of days in a given year?

ADP,

4 6053

Differencr Between DELETE and TRUNCATE?

ADP,

3 6197

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

ADP,

2 4651

How to get number of days in a given year?

ADP,

4 7122

Explain SELF JOIN ?

ADP,

3 6107

What is Index ? Explain its Types?

ADP,

2 6729

Define Foreign Key?

ADP, College School Exams Tests,

3 7439

Un-Answered Questions { SQL Server }

Difference between LEN() and DATALENGTH() in sql server ?

582

What are the types of ssrs?

108

What is hot add cpu in sql server 2008?

508

Is the order of columns in the set clause important in ms sql server?

505

What is a matrix in ssrs?

101




hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

1547

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

557

Explain transaction isolation levels in sql server?

536

What are dml triggers and types of dml triggers?

539

Explain what are the basic functions for master, msdb, model, tempdb databases?

519

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

557

What are the system database in sql server 2008?

566

How do you use a subquery to find records that exist in one table and do not exist in another?

538

how many type of indexing in database?

563

Do you know what is blocking?

532

For More Un-Answered { SQL Server } Questions Click Here