What is subquery? Explain the properties of a subquery?
Is index a datbase objects in sql server?
What is the difference between views and stored procedures? Can we have input parameters for views?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
Explain system views?
How we Resize table,temp table, database and log file size in SQL Server 2005
What are types of scd? : sql server analysis services, ssas
write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?
What is a print index?
What are triggers? How do you invoke a trigger on demand?
System variable and temporary variables
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?