Why we need a group by clause?4 6567
What is the difference between referencing and joining?1 2214
What is ACID Property of Transaction?10 29725
What is a cursor in SQL Server 2000 and their types?8 13589
How do we get month name in SQL Server 2000, Oracle, MS Access?11 45512
How do we return a record set from a Stored Procedure in SQl server 2000?3 3582
How do we get current date in SQL Server 2000, Oracle, MS Access?13 42908
What are the differences between stored procedure and functions in SQL Server 2000?25 96121
Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???3 3684
Which is best Subquery (or) joins in sql server? explain why2 8891
What is best institute to Learn DotNET And SQL in chennai?
how to use DTS package in 2000,2005,2008 in sql server
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
Which is the best place or learning center for MS SQL?????In Bangladesh?????
on line cluster can we make if yes tell me the procedure
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
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?
New concepts of sql server 2005 use in your project.
last function used in MS Access to convert sql what function will use in sql
application server is slow what may be the problem
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
How to restore performance issues and how to check?
how can you attach more than 20 ldf files in sql server
What is data modeling and Reterminal integrity?