SQL Server Interview Questions
Questions Answers Views Company eMail

IN Vs OR operator which is best to use sql server.

4 8248

Can anybody explain me cold backup and hot backup?


3 12848

whate is advantages of sql server 2000


what is the purpose of creating view is sql server 2000


13 12375

why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 3150

hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 3818

how to connect sybase to sql server 2005?.


1 2895

how to select a field with firstletter as capital and remaining are small letters

11 11679

How to write stored procedure to update the data in 10 tables

4 10655

How to write query to Delete the records in child table and corresponding records in parent table

Semantic Space,

11 26714

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 4191

Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?

4 5185

what is difference between view and Dip.



what is curser.

9 6524

what is Data Transformation Services (DTS) ?can u explain me in detail?


5 9776

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

can any body tell me how to know the password of current user in sql server


tell me the disaster recovery plan


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?


application server is slow what may be the problem


If the job running very slow what is the action you do


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?


how can u get last observation in an unknown dataset ?


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it


plss anybody specify tha constrian management system in dbms


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?


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


what is checksum in sql server.........???


New concepts of sql server 2005 use in your project.


where the connection string store in the database