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 3427

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 8881

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

BoA,

1 2405




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

IBM,

781

logshipping is Any difference 2000 and 2005?

2 2527

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

889

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

2 2317

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

Oracle,

1 3020




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

Oracle,

1 3547

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 2531

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

HCL, ABC,

6 12527

How do you read transaction logs

1 3093

How do you persist objects, permissions in tempdb

1 4767

How do you simulate a deadlock for testing purposes

1 8119

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 8896


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Does any body please help me what question's have asked for SSRS in the interview?

794


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1217


How to restore performance issues and how to check?

798


How you trouble shoot when any job fails

629


Why we need to use secondry database file? though, we can do same work using primary database file also.

4137






What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

2579


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

763


How to convert a table data in XML format in sql server?

1351


plss anybody specify tha constrian management system in dbms

771


How retrieve field names from the table in SQL through JAVA code?

649


What is the difference between online clustering and Offline clustering?

1175


tell me the disaster recovery plan

1237


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

605


How we create SQL Server 2005 Reporting Services ? Give me Sample

867


You are doing log shipping due to some reasons it is failing. How you will proceed from there

771