| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how to get 25th row in any table in sqlserver can u tell me
syntax | | 4 |
| what is meant by sql injection with example and one more
question how to catch the errors in sqlserver | | 1 |
| What is The Use Of TIMESTAMP DataType in SQL Server 2005?
| | 3 |
| How to Display, Amount of Disk Activity Generated by
Transact-SQL Statements?
| | 1 |
| Hi..here i would like to know the Backup and Restore models? | HCL | 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 |
| how can do you the system monitoring? | | 1 |
| hi, may i know what is the command to get abstract the
current month, current year and current day from a given
date.i want these three in a isolated way..seperatedly is
that any way in sql server 2000 | | 3 |
| What is a NOLOCK? | | 3 |
| What is a Stored Procedure? | | 7 |
| Can you explain the types of Joins that we can have with Sql
Server? | | 2 |
| WHAT IS DIFFRENCE BETWEEN TRUNCATE AND DELETE STATEMENT | CTS | 10 |
| can foreign key take role of primary key?
| TCS | 4 |
| 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 are SQL Server databases physically stored under
Windows 2000? | | 1 |
| is it possible to use a variable in a query with the IN
clause (a,b,c..z), without getting quotes or conversion
errors? | | 2 |
| Can Somebody tell me the difference between Clustered & Non-
Clustered Index?? | Progressive | 3 |
| What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table | HP | 15 |
| can you any body tell me the difference between candidate
key and primary key | | 4 |
| 1.what is stored procedure?Its significance with example?
2.Explain about index with syntax and example?
plz do reply......... | | 1 |
| |
| For more SQL Server Interview Questions Click Here |