IN Vs OR operator which is best to use sql server.4 8248
why cluster and non clusterindex are used in sqlserver 2000? explain with example1 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 20003 3818
how to select a field with firstletter as capital and remaining are small letters11 11679
How to write stored procedure to update the data in 10 tables4 10655
How to write query to Delete the records in child table and corresponding records in parent table11 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 curser.9 6524
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