| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Let’s say the table in the database is named as
TBL_Register. The fields in this table include:
1. User_Name,
2. User_Telephone,
3. Register_Date
The field Register_Date stores the current date and time of
the registration.
Write the SQL statement that inserts the data into the
table. | Techno-Solutions | 2 |
| i have table students with fields classname,studname
select * from students
classname studname
1 xxxxx
1 yyyy
1 zzzz
2 qqqq
2 tttt
3 dsds
3 www
i want the output should be
No of students in class 1 : 3
No of students in class 2 : 2
No of students in class 3 : 2
| HCL | 2 |
| What is an execution plan? When would you use it? How would
you view the execution plan? | | 1 |
| How To Make password Protected SQL Server 2005 Database
i.e when i open SQL Server database then ask for password.
| | 1 |
| How to Display, Amount of Disk Activity Generated by
Transact-SQL Statements?
| | 1 |
| what is mean by crystal repoart? ahere we will mainly use
that? | | 1 |
| What are the two types of concurrency? | | 2 |
| What is the basic functions for master, msdb, tempdb databases? | CSC | 2 |
| What is a table called, if it does not have neither Cluster
nor Non-cluster Index? | | 1 |
| can you any body tell me while running BCP Out in instance
in sql server 2000 is getting error.
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
Server does not exist or access denied.?
| | 1 |
| How to Debug a Stored Procedure? | Allianz | 4 |
| how can i store resumes in database? | HCL | 2 |
| What are primary keys and foreign keys? | | 3 |
| When do we use the UPDATE_STATISTICS command? | | 3 |
| How to create logins using windows Authentication mode? | | 2 |
| what are batch in sql server?
| Satyam | 2 |
| What is a stored procedure? | | 3 |
| What are sub-queries? Give example? In which case
sub-queries are not feasible? | Infosys | 3 |
| What are the pros and cons of creating extended stored
procedures? | | 1 |
| Can you have a nested transaction? | HCL | 3 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
