| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 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 some one please help with a query which will take only
max value of a column in a join. | | 2 |
| can anyone explain me the concept of Serialization in Detail
and Clear? plz its urgent i have interview on friday (15th feb) | | 1 |
| What about UPDATESTATISTICS ? | Intelligroup | 2 |
| What is the difference Between Sql-server 2000 & 2005 | Value-Labs | 2 |
| how we can count records as a group of days like sum of
records for(four mondays),(four tuesday)........ in a month.
group the column for weekdays.
| | 1 |
| how to get the rowid/rownumbes of a table in sqlserver | IBM | 5 |
| write down the code for "how we delete a table without
using of Drop command " ? | Sonata | 2 |
| i want to create procedure for create table in sql server
2005
for example
create procedure create_table
@table varchar(20)
as
create @table(
id int,
name char(20)
)
but it will get error
what is solution?
| Aptech | 4 |
| Explain some DBCC commands? | | 4 |
| What is bit datatype and what's the information that can be
stored inside a bit column? | | 1 |
| Write a query to delete duplicate records in SQL SERVER | Infosys | 19 |
| can you any body tell me suppose database is suspect mode.
how can take to normal? | Teledata | 1 |
| 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 |
| How m-m relationships are implemented? | | 1 |
| What is the difference between HAVING clause and the WHERE
clause? | | 4 |
| why cluster and non clusterindex are used in sqlserver 2000?
explain with example | | 1 |
| Explain sp_configure commands, set commands? | | 3 |
| After using delete statement in sql query to delete some
records...to retrieve the deleted records we can get using
rollback command but till that where it stores means
particular location name i need....(after deleting and
rollback ) | iGate | 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 |
| |
| For more SQL Server Interview Questions Click Here |