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 5713

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 14425

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

BoA,

1 4417

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

IBM,

2000

logshipping is Any difference 2000 and 2005?

2 4839

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

2021

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

2 5123

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

Oracle,

1 5102

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

Oracle,

1 5569

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 4386

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 17888

How do you read transaction logs

1 4791

How do you persist objects, permissions in tempdb

1 6680

How do you simulate a deadlock for testing purposes

1 10291

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 19517

Un-Answered Questions { SQL Server }

How network traffic be reduced by using the stored procedure?

1118

How to create a local temporary stored procedure?

998

Write the syntax for stuff function in an sql server?

1025

Explain what are the database objects? : SQL Server Architecture

1077

What is the log shipping?

1001

What is difference between index seek vs. Index scan?

1155

How do you rebuild an identity column?

949

What is analysis service repository?

1023

Explain the relational database management system (rdbms)?

1097

What xml support does the sql server extend?

1011

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1034

What are the lambda triggers?

904

What is the purpose of the tempdb database?

1000

Your table has a large character field there are queries that use this field in their search clause what should you do?

884

Difference between report and query parameter. Why do we need different type of parameter?

953

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