| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Can Having clause be used without Group by clause? | CTS | 4 |
| What is the difference between 2-Tier architecture and
3-Tier architecture | Oracle | 10 |
| If 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? | | 1 |
| Write a query to delete duplicate records in SQL SERVER | Infosys | 19 |
| How to find the last update record in SQL Server? | | 3 |
| Can I know,how to Execute Funcion and Trigger through
command(Manualy Execution) in MS SQL/SERVER 2005,give me
answer with Example. | | 1 |
| What are primary keys and foreign keys? | | 3 |
| What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE? | Yardi-Software | 4 |
| How to find the date and time of last updated table?
| Teledata | 4 |
| How to determine the service pack currently installed on
SQL Server? | HCL | 4 |
| What is the order in which the SQL query is executed? list
them in order. | CTS | 1 |
| can we call stored Procedure in Function in Sql Server 2000
and vice versa. | eSoft | 2 |
| from the table display the 2nd highest salary?
and also the least 2nd salay?
| | 6 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | | 1 |
| Difference between Function and Stored Procedure? | C1-India | 4 |
| SYNTAX FOR VIEWS WITH EXAMPLE
HOW TO LINK TWO TABLES | Microsoft | 1 |
| which query u can write to sql server doesn't work
inbetween 7.00PM to nextday 9.00AM | Wipro | 4 |
| How do you load large data to the SQL server database? | | 2 |
| What is the advantage of specifying WITH GRANT OPTION in
the GRANT command? | | 2 |
| 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
| vsworx | 7 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
