what are the limitations of parameters in a storedprocedure1 1686
last function used in MS Access to convert sql what function will use in sql781
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?1143
hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?7 7879
if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?1 1837
if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?2 1616
if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?5 4558
How to delete the duplicate rows from a table in SQL Server ??3 3891
Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz3 2427
WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?3 1984
what is integrated security (SSPI). why we use in the connection string?2 4156
What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?3 5332
What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?15 10879
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is best institute to Learn DotNET And SQL in chennai?
Explain Capacity planning to create a database? and how to monitor it?
What is the query optimization statistics?
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
If the job running very slow what is the action you do
New concepts of sql server 2005 use in your project.
what is checksum in sql server.........???
whats the maximum size of view state??
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
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
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions