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 3470

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 8983

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

BoA,

1 2443




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

IBM,

800

logshipping is Any difference 2000 and 2005?

2 2561

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

914

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

2 2347

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

Oracle,

1 3051




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

Oracle,

1 3583

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 2555

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 12651

How do you read transaction logs

1 3116

How do you persist objects, permissions in tempdb

1 4804

How do you simulate a deadlock for testing purposes

1 8195

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 8991


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is RMS migrations?

922


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

672


What is data modeling and Reterminal integrity?

633


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1544


Delete duplicate rows without using rowid.

155






how can u get last observation in an unknown dataset ?

1106


If user is owning any SQL Objects, can we drop that user

828


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

755


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.

1573


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

1072


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.

748


sql database suspect We have a sql database that is showing as suspect. How can we recover?

687


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

563


How to trouble shoot if unable to connect SQL Server

743


Which is the best place or learning center for MS SQL?????In Bangladesh?????

848