| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are statistics, under what circumstances they go out
of date, how do you update them? | HCL | 2 |
| How To Make password Protected SQL Server 2005 Database
i.e when i open SQL Server database then ask for password.
| | 1 |
| What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same? | Microsoft | 2 |
| How to link up the text file to a Database table? | Allianz | 1 |
| Wht is the difference between stored procedure and trigger | TCS | 4 |
| what is the difference between group and having
give an example with query and sample output | | 2 |
| i want to join two queries....and i want to run them as one
after another that is want output of first query then
second , then again output of first query then second and
so on... | | 2 |
| Can Somebody tell me the difference between Clustered & Non-
Clustered Index?? | Progressive | 3 |
| create index a on employee(dno)
In this,which index was created? | | 2 |
| 1.Describe way(s) to tune the SQL table in order to
optimize performance.
2. Explain SQL Injection and how can you prevent them? | Techno-Solutions | 1 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | | 1 |
| How to Execute an Operating System Command From Within SQL
Server ? | | 2 |
|
CLR Integration ?
what is Notification services ?
| Satyam | 1 |
| How can you see what type of locks used? | | 1 |
| system date format is "yy-mm-dd"
"select getdate()" ----> 2009-01-24 20:03:28.513
if i write "select dateadd(dd,2,getdate())
".it returns "2009-01-26 19:59:38.340"...my question is dat
could it be possible to retrive da date in da format "26
jan 2009 ...."??
| | 8 |
| Is it possible to create tables in stored procedures using
a variable for the table name? | | 2 |
| 1.what is the purpose of using alias name in sql server?
with certain example?
2.what is cursor?will u plz explain me in detail with
certain example? | | 3 |
| Can you explain the types of Joins that we can have with Sql
Server? | | 2 |
| Assume,there are three tables in a database, Can i have
both primary key and foreign key for each table in the same
database? | | 4 |
| How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table? | Leo-Technologies | 12 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
