| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to work on DTS?what is the main requirement? | ivan | 1 |
| Write an SQL query if u want to select the data from one
block which intern reflects in another block ?
thanx,do reply | Covansys | 1 |
| What are three SQL keywords used to change or set someone?s
permissions? | | 3 |
| what is web server?
| Satyam | 3 |
| What is the difference between having and where clause? | | 4 |
| Hi SQL gurus,
i am working for an MNC...
My team is having a problem in sql server. when user slects
date prompts from jan 1st to april 30, it should display
all months data like :
jan aa
feb bb
mar cc
but when it comes to april its taking data like :
jan aa
feb bb
mar cc
apr dd...and so on
means its taking data again from jan to april which we dont
want. we want the data only april month as we are getting
jan, feb and mar...
can any one write the code to relsove the issue please
would be greatful if you can send to shiva_sans@yahoo.co.in
and also please send your email also ...so that we will be
in touch for any kind of queries ...
Thanks a lot in Advance !!!
| | 1 |
| WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT? | | 5 |
| how to give input dynamically to a insert statement in
sqlserver | HCL | 2 |
| 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 |
| plz tell me the new features of
sqlserver2000,sqlserver2002,sqlserver2005 | | 3 |
| write the query for taking database backup in sql | Logica-CMG | 6 |
| what is maximum size of temp db? | iSoft | 4 |
| what is the Enterprise manager(2000) and management studio
(2005)? | | 2 |
| What do you mean by COLLATION? | | 4 |
| What are user defined datatypes and when you should go for
them? | | 1 |
| How To delete duplicate record from a particular table? | eXensys | 10 |
| What are the advantages of using sql server over ms access
or why should one use sql instead of ms access | Impetus | 1 |
| How to display n-1 columns from n number of columns, from a
single table in MS SQL server 2005? | | 1 |
| What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL? | | 1 |
| How can count the string ?
for ex: If i have string like 'bhaskar' then i need like
b:1
h:1
a:2
s:1
k:1
r:1
please give any idea on that
| TCS | 5 |
| |
| For more SQL Server Interview Questions Click Here |