What is difference between stored procedure and user defined function?
No Answer is Posted For this Question
Be the First to Post Answer
I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?
What is meant by indexing?
In what version of sql server were synonyms released?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Does group by sort data?
What is the purpose of sql profiler in sql server? : sql server database administration
What are the types of lock supported by ?
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.
What are the recovery models for a database?
What are the different types of triggers in SQL SERVER?
How to drop existing indexes in ms sql server?
What is the use of placing primary key and foreign key constrains on columns.