| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| If you are working on a SQL database and if suddenly a
developer changes the code and your queries results start
giving errors,how will you check using a T-SQL query (on
system tables) that what has changed in the database. | Microsoft | 2 |
| CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType
varchar(50) )
go
create trigger hpms_create_Insert
on HPMS_CompetencyTypes
for insert
as
if Exists ( select * from [HPMS_CompetencyTypes] where
CompetencyType=(select * from [HPMS_CompetencyTypes]))
begin
Rollback tran
Raiserror ('duplicate value',12,6)
go
insert HPMS_CompetencyTypes (CompetencyType) values ('new')
I'm new to trigger can any one tell me where is the issue.
Please. | | 2 |
| What are the advantages of using views. Why do we need
views when we have SPs? | 247Customer | 3 |
| 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 |
| what is mean by crystal repoart? ahere we will mainly use
that? | | 1 |
| I need a query that retrieves info from an Oracle table and
a query that retrieves info from a SQL Server table. The
info has to be joined together according to Record ID
numbers. I have very limited access to the Oracle database
but full control of the SQL Server database.How do I join
two different queries from two different databases?
| | 1 |
| how to delete duplicate rows from table in sql server | HCL | 8 |
| How to determine the service pack currently installed on
SQL Server? | HCL | 4 |
| 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 |
| Explain Active/Active and Active/Passive cluster
configurations | | 1 |
| if we have a column (Key) in a table.
and values of that column is
Key
1
1
1
2
2
3
3
4
4
5
5
5
and we want to show the data after query..like..
1(3)
2(3)
3(2)
4(2)
5(3)
how many times a single term comes..
| Rolta | 5 |
| What is normalization and its forms? | Challenger-Financial | 3 |
| Please tell me some knowledge about Clustering and how to
add clustering? | | 1 |
| can we call stored Procedure in Function in Sql Server 2000
and vice versa. | eSoft | 2 |
| Which databases are part of SQL server default installation?
Explain the usage of each? | Accenture | 2 |
| IN Vs OR operator which is best to use sql server. | | 3 |
| What are the differences between stored procedure and
functions in SQL Server 2000? | TCS | 12 |
| what is difference between primary key and Unique | | 8 |
| Questions regarding Raiseerror? | | 1 |
| how insert selected column only ? | Robert-Half | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
