Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



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 3989

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 10229

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

BoA,

1 2876

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

IBM,

1116

logshipping is Any difference 2000 and 2005?

2 3046

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

1220

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

2 2920

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

Oracle,

1 3535

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

Oracle,

1 4035

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 2987

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 14078

How do you read transaction logs

1 3523

How do you persist objects, permissions in tempdb

1 5281

How do you simulate a deadlock for testing purposes

1 8826

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 11394







Un-Answered Questions { SQL Server }

Why de-normalization required?

145


What is sql server profiler trace data file?

116


You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

138


What is usually the first word in a sql query?

171


how many triggers you can have on a table? : Sql server database administration

135






can an order by clause be used in a creation of a view?

200


What is @@rowcount in sql?

154


Give an example of SQL injection attack ?

161


Explain the difference between delete,drop and truncate in SQL Server?

177


What is inner join? Explain with an example?

160


What is read uncmmited?

129


What is a primary index?

125


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

136


How to execute a stored procedure in ms sql server?

151


When is the use of update_statistics command?

148