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 3620

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 9282

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

BoA,

1 2578




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

IBM,

899

logshipping is Any difference 2000 and 2005?

2 2707

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

999

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

2 2520

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

Oracle,

1 3196




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

Oracle,

1 3722

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 2690

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 13112

How do you read transaction logs

1 3252

How do you persist objects, permissions in tempdb

1 4949

How do you simulate a deadlock for testing purposes

1 8454

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 9544


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

2751


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?

1331


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

380


whats the maximum size of view state??

1022


What is best institute to Learn DotNET And SQL in chennai?

1042






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.

853


How to restore performance issues and how to check?

918


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1113


how to do partition in sqlserver

1372


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

690


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.

1319


Tell about MOM Tool(Microsoft Operator Manager)?

761


tell me the disaster recovery plan

1358


how many no of arguments can be passed in procedures and functions

3633


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

930