there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C
9 12292How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com
35 61547If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?
2 4652wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform
Idea,
1 8949
What is role playing dimension with two examples? : sql server analysis services, ssas
What is equi join with example?
Explain forward - only cursors?
Difference between DELETE and TRUNCATE?
What do you know about normalization and de- normalization?
What are the 3 types of schema?
What is dynamic cursor in SQL SERVER?
What is bookmark link in ssrs?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
How to execute stored procedure in select statement sql server?
Why transaction is important?
Why truncate is ddl?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is report snapshot in ssrs?
is it important for a database administrator to understand the operating system and file access? : Sql server administration