| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how will u create "n" possible tables in sql...
| Oracle | 1 |
| How to retrieve data from log files in SQL SERVER ????? | | 1 |
| hi,
i have a table called names and field name
select * from names
name
a
b
c
d
i want to display like this
name
a,b,c,d
how it is possible
Regards
Baiju | | 3 |
| what is for foreign key ?? | Sabic | 3 |
| Which data type can be used only on OUTPUT parameters of the
stored proceduer? | | 2 |
| WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE
RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,... | TVS | 2 |
| what is extended StoreProcedure ?
| Satyam | 3 |
| how can i store resumes in database? | HCL | 2 |
| Hi Can any one tell me the Good institute to learn SQL esp
for Data Base Testing or SQL from scratch to the
proficiency level in Hyederabad and facult also. Thankyou
well in advance | | 6 |
| Can Having clause be used without Group by clause? | CTS | 4 |
| Explain the architecture of SQL Server? | | 2 |
| 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 |
| Can you give an example of Stored Procedure? | | 2 |
| 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 |
| What are the type of joins? When do we use Outer and Self joins? | | 3 |
| What is data integrity? Explain constraints? | Thinksoft | 1 |
| What is normalization and what are the different forms of
normalizations? | | 1 |
| WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT? | | 5 |
| IN Vs OR operator which is best to use sql server. | | 3 |
| What is a trigger? | | 6 |
| |
| For more SQL Server Interview Questions Click Here |