SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 5813

system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??

8 14787

how can we use a composite key for two tables and how can we represent it

BoA,

1 4490

how can you attach more than 20 ldf files in sql server

IBM,

2052

logshipping is Any difference 2000 and 2005?

2 4946

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

2064

when inserting to a table how many rows will be effected using triggers

2 5203

write coding for importing sql data into a word excel...

Oracle,

1 5212

how will u create "n" possible tables in sql...

Oracle,

1 5641

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 4479

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

ABC, HCL,

6 18100

How do you read transaction logs

1 4880

How do you persist objects, permissions in tempdb

1 6747

How do you simulate a deadlock for testing purposes

1 10377

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

DELL,

13 20003

Un-Answered Questions { SQL Server }

What is index, cluster index and nonclustered index?

1052

How can we delete Duplicate row in table?

1115

Explain aggregate functions?

1143

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

1195

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1226

How to create dbo table in sql server?

1009

What are different types of views?

990

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

319

What is the difference between commit and rollback?

994

What is the contrast between sql and pl/sql?

1201

What is unpivot?

1078

What is statement level trigger?

1050

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?

1385

Can two tables have the same primary key?

1272

How do I find the sql server version?

1081

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