| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is SQL server agent? | SAP-Labs | 2 |
| WHAT IS DIFFRENCE BETWEEN TRUNCATE AND DELETE STATEMENT | | 8 |
| write down the sql query?
Table Name : emp1
empid empname
1 bala
2 guna
Table Name : emp2
empid empname
1 <Null>
2 <Null>
Solution : emp1 names are updated in emp2, write a query?
| | 3 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | | 1 |
| i want table name basis on column name. | | 2 |
| What are the pros and cons of creating extended stored
procedures? | | 1 |
| how to rename the table | | 1 |
| What is the appropriate number of test cases that you can
write on a database? | Microsoft | 1 |
| What are the steps you will take, if you are tasked with
securing an SQL Server?
| HCL | 1 |
| what is the importence of the trigger in sqlserver2000? | ATI | 1 |
| can we call stored Procedure in Function in Sql Server 2000
and vice versa. | eSoft | 1 |
| SQL stops working in every 15 days displaying message that
database log file is full. Log file size is 3.95 GB. It is
happening after shrinking the database also. What is
solution to overcome this problem. Please help me as it's
urgent. | | 2 |
| How do SQL server 2000 and XML linked? | | 1 |
| how to select a field with firstletter as capital and
remaining are small letters | | 7 |
| Questions regarding Raiseerror? | | 1 |
| What is normalization and its forms? | Challenger-Financial | 3 |
| Which is the subset of SQL commands used to manipulate
Oracle Database structures, including tables? | | 1 |
| is there more the two primary key in a single table? | Systematix | 20 |
| Difference Between varchar and nvarchar datatype? | Satyam | 2 |
| Which is best Subquery (or) joins in sql server? explain why | | 1 |
| |
| For more SQL Server Interview Questions Click Here |