| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is Schema? and why we use schemas? | | 1 |
| please can anyone answer this query
Table 1 has 2 columns: EmployeeId,Age
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region who has the oldest person | | 7 |
| I am Having tables T1 and T2 both having same data how to
check (or) compare the data in both table are same? | | 2 |
| How many max. conditions can b written under the WHERE
clause?
Like select * from [tabnam] WHERE
(cond1...or..cond2....or...cond3...and.....so on.....???
(upto how much extent))????? | SAP-Labs | 2 |
| What is The Use Of TIMESTAMP DataType in SQL Server 2005?
| | 3 |
| how to rest identity columns in sql server | Matrix | 3 |
| As a part of your job, what are the DBCC commands that you
commonly use for database maintenance? | HCL | 1 |
| What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
| HCL | 3 |
| How can we write or define DDL statements in Sql server and
DML statements? | | 2 |
| Using query analyzer, name 3 ways you can get an accurate
count of the number of records in a table? | eFunds | 5 |
| Can you tell me the difference between DELETE & TRUNCATE
commands? | | 11 |
| What is the use of placing primary key and foreign key
constrains on columns. | Value-Labs | 2 |
| Explain sp_configure commands, set commands? | | 3 |
| how to select 5 to 7 rows from a table, which contains 10 rows? | IBM | 14 |
| i want table name basis on column name. | | 5 |
| How to count the number of duplicate items in a table? | | 1 |
| How would you Update the rows which are divisible by 10,
given a set of numbers in column? | | 1 |
| What is the system function to get the current user's user
id? | HCL | 1 |
| How do you check the performance of a query and how do you
optimize it? | | 1 |
| What is normalization? | | 6 |
| |
| For more SQL Server Interview Questions Click Here |