Diffrences between sql server 2000 vs 2005
Answer Posted / naren
New data type XML, Binary
SSIS,SSRS,SSAS
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is sub-query in sql server? Explain its properties.
What is SubQuery in SQL Server 2008
how to take backup bcp out for a column in table in sql server?
How to locate and take substrings with charindex() and substring() functions?
Explain unique key in sql server?
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
Delete duplicate rows without using rowid.
What is the recovery model? List the types of recovery model available in sql server?
Explain what is raid and what are different types of raid levels?
What are orphan records?
How is SQL Azure different than SQL server?
What is sql server management studio? : sql server management studio
Mention the command used to rename the database.
What is database black box testing?
Do you know what are acid properties of transaction?