| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| create procedure proc1 (@a int)
as
begin
if @a=1
create table #temp(a1 int)
else
create table #temp(a1 int)
end
while executeing the above code it shows error
like '#temp already exist' .why it shows an error? | IBM | 5 |
| What is the difference between windows authentication and
sql server authentication | HCL | 4 |
| Can you explain the role of each service? | | 1 |
| Explain the basic concepts of SQL server architecture? | | 2 |
| How do you find the number of rows in a table? | | 5 |
| plz send every query in sql server2000 | Infosys | 1 |
| What is the basic difference between clustered and a
non-clustered index? | | 3 |
| How would you Update the rows which are divisible by 10,
given a set of numbers in column? | | 1 |
| Please give me the SP for the below scenario. I have two
tables named Table1 and Table2...I need to fetch record by
record from Table1 and insert the record in to table2 where
the value in the sno column of the table1 is even number. | Value-Labs | 4 |
| Which databases are part of SQL server default installation?
Explain the usage of each? | Accenture | 2 |
| wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records | | 16 |
| how to dispaly a particular row details from a given table | | 1 |
| what is the query and condition to delete datas in sql
server. | | 2 |
| how to count datewise data in sqlserver | IndusInd-Bank | 3 |
| What are the advantages of using sql server over ms access
or why should one use sql instead of ms access | Impetus | 1 |
| what is the importence of the trigger in sqlserver2000? | ATI | 1 |
| What is a Join in SQL Server? | | 2 |
| IN Vs OR operator which is best to use sql server. | | 3 |
| can primery key be a non clustered index? | | 8 |
| If you are working on a SQL database and if suddenly a
developer changes the code and your queries results start
giving errors,how will you check using a T-SQL query (on
system tables) that what has changed in the database. | Microsoft | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
