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 3516

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 9071

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

BoA,

1 2495




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

IBM,

831

logshipping is Any difference 2000 and 2005?

2 2599

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

940

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

2 2399

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

Oracle,

1 3088




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

Oracle,

1 3633

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 2591

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 12784

How do you read transaction logs

1 3172

How do you persist objects, permissions in tempdb

1 4858

How do you simulate a deadlock for testing purposes

1 8280

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 9119


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

874


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

969


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

2677


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

818


how to overcome kernel isssues

469






ow to bring suspect mode datbase online from scratch

686


optimization techinques

1330


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

1618


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

904


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

847


whats the maximum size of view state??

949


what exactly sql injuction.how to overcome.....

1311


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?

612


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?

1256


How can we call UDF(User Define Function) using C# code in ASP.net ?

4679