| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| to explain sql server 2000 architecture & authentication | HCL | 1 |
| 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 | 6 |
| I have a huge amount of data which is displayed in a
report. The data is viewed every day. Every day the data is
displayed in 30 secs but suddenly today it is giving an
timeout message today. Data has not been changed. The
situation is same as yesterday. What might be the reason???
Please Answer. | Satyam | 4 |
| what is the difference between sql query and google query? | TCS | 10 |
| What types of integrity are enforced by a foreign-key
constraint
| | 1 |
| How can u convert the Date to String? | TCS | 6 |
| how to get the automatic backup of the database in the sql
server | | 4 |
| what are the new features of sql server 2005? | HP | 8 |
| What is the difference between temp table and table variable? | Microsoft | 7 |
| How To delete duplicate record from a particular table? | eXensys | 11 |
| Can we use Truncate command on a table which is referenced
by FOREIGN KEY? | | 2 |
| WHAT OPERATOR PERFORMS PATTERN MATCHING? | CTS | 2 |
| What is MSDE? | | 2 |
| What are the advantages of using views. Why do we need
views when we have SPs? | 247Customer | 3 |
| why we use cursor? | Melstar | 3 |
| What is the difference between login and a user? | TCS | 10 |
| What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE? | Yardi-Software | 6 |
| If suppose in a table ship(name,year),find ship name having
first and last name(i.e having space in between)
ex: SAINT LOUIS,JET LAKE. | | 4 |
| what is call by value & call by reference ? | Cap-Gemini | 2 |
| hi,i want t0 knom d syntax for a super key with an example | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
