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?

TCS,

3 12848

whate is advantages of sql server 2000

918




what is the purpose of creating view is sql server 2000

Wipro,

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?.

ABC,

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.

L&T, IBM,

1165

what is curser.

9 6524

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

TCS,

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

895


tell me the disaster recovery plan

1261


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

1124


application server is slow what may be the problem

1065


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

687






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

642


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?

835


how can u get last observation in an unknown dataset ?

1106


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

280


plss anybody specify tha constrian management system in dbms

789


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

854


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

688


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

357


New concepts of sql server 2005 use in your project.

1211


where the connection string store in the database

790