| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How the data stores in a page? | | 1 |
| What are the types of backup and tell me the difference
between full and differential backup? | TCS | 3 |
| how can u select the Distinct values in the table, table
having 20 columns , i want all columns | | 1 |
| How to determine the service pack currently installed on
SQL Server? | HCL | 4 |
| select empid empname from employee
What is the result for the about query? | | 4 |
| one table has four field id,name,design,salary. i have to
find maximum salary . | | 6 |
| Assume,there are three tables in a database, Can i have
both primary key and foreign key for each table in the same
database? | | 4 |
| wht is normalization?can u explain me in detail? | TCS | 6 |
| How To Make password Protected SQL Server 2005 Database
i.e when i open SQL Server database then ask for password.
| | 1 |
| 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 |
| How to Create Login and User through query in Sql server
2005.and also how to delete Login and User through query? | | 2 |
| what are the new features of sql server 2005? | HP | 5 |
| IN Vs OR operator which is best to use sql server. | | 3 |
| 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 |
| How do you check the performance of a query and how do you
optimize it? | | 1 |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 4 |
| Well sometimes sp_reanmedb may not work you know because if
some one is using the db it will not accept this command so
what do you think you can do in such cases? | | 2 |
| Can you explain the types of Joins that we can have with Sql
Server? | | 2 |
| employee table has employee id
-----------
empid
----------------
1
2
3
3
3
4
5
5
5
6
6
6
7
here the values r repeated two times.how to select the
repeated values only.i.e 3,5,6 should alone come. | | 2 |
| how to count datewise data in sqlserver | IndusInd-Bank | 3 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
