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 3377

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 8773

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


1 2371

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



logshipping is Any difference 2000 and 2005?

2 2487

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


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

2 2280

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


1 2976

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


1 3515

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 2498

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


6 12377

How do you read transaction logs

1 3052

How do you persist objects, permissions in tempdb

1 4719

How do you simulate a deadlock for testing purposes

1 8026

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


13 8738

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

How do you Implement SSIS Packages in your Project?


Delete duplicate rows without using rowid.


how can u get last observation in an unknown dataset ?


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


query processing


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that


What is data modeling and Reterminal integrity?


Explain Capacity planning to create a database? and how to monitor it?


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you


where the connection string store in the database


What are the dis_advantages of stored procedures, triggers, indexes?


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


What is the difference between NOROW and LOCKROW?