How to change the password of a login name in ms sql server?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
Differentiate between SQL and ORACLE joins and write their syntax.
What is the difference between a Local temporary table and a Global temporary table? How is each one used?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
Explain the advantages of merge replication?
What is PROJECTION Operation?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What are the advantages of user defined function?
How many ways to create table-valued functions?
What is transaction server implicit?
Why transaction is important?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.