| Other SQL Server Interview Questions |
|| Asked @
|What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
|i need some interview questions on sql server developer plz
any onee send some links.
|A successfully created SSIS package in SQL Server 2005 runs
fine in MS BIDS and Integration Services. But gives error
when run through an SQL-Job. What are the possible reasons?
|I am having table Title with TITLE id,Author ID, Publiser
ID , table AUTHOR with Author ID, Author Name, table
PUBLISER with Pub ID, Pub name Here hot to find out the
publiser id who have relesed the books of patriticular
|how to get the maximum among two tables,for example table 1
(dep1) have (emp_id,emp_name,salary) columns and table 2
(dept2) have (emp_id,emp_name,salary) columns,i want which
employee have the maximum salary among two tables?
|What is Index ? Explain its Types?
|How to Install SQL SERVER 2005 remotely?
|one of my database size is 2gb and Unrestricted Growth for
Data file up to 10%.But every day after day I am getting
Primary Data file is full 99.999 please take appropriate
actions.Why it is? Even disk space is also not full,but
still I am getting the alerts.
|is there more the two primary key in a single table?
|What is normalization and what are the different forms of
|What is the default value of CHAR type?
|What is an extended Stored Procedure?
|For more SQL Server Interview Questions Click Here |