|
Related Questions |
View Answer |
|
Give some examples of Analytical functions?
|
View Answer
|
|
What is the difference between "translate" and "replace"?
|
View Answer
|
|
How functional dependency is related to database table design?
|
View Answer
|
|
What is DYNAMIC SQL method ?
|
View Answer
|
|
What is the query used to display all tables names in SQL Server (Query analyzer)?
|
View Answer
|
|
What is the query used to display all tables names in SQL Server (Query analyzer)?
|
View Answer
|
|
What is a dirty page and dirty report?
|
View Answer
|
|
What are the new enhancements in SQL server 2005?
|
View Answer
|
|
Difference between a "where" clause and a "having" clause?
|
View Answer
|
|
Write sql query for retrieving employee names from employee table who are having salary greater than 5000 without using where clause?
|
View Answer
|
|
Explain real time situation where you would use clustered and Non-clustered Indexes?
|
View Answer
|
|
What is the pivot operator in MS SQL Server2005? What is the use of it and how do we use it
|
View Answer
|
|
What are "HINTS"? What is "index covering" of a query?
|
View Answer
|
|
What are data objects?
|
View Answer
|
|
What is the difference between User Identification and Authentication?
|
View Answer
|
|
How to display the table data in XML format using SQL Server.
|
View Answer
|
|
What is XMLA in SQL Server 2005
|
View Answer
|
|
How many types of system privileges are there, Can we add or delete privileges?
|
View Answer
|
|
Write a SQL Stored Procedure to create a GUID and add it to a table. Make that GUID an OUTPUT of that Procedure
|
View Answer
|
|
Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no.
|
View Answer
|