| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Which databases are part of SQL server default installation?
Explain the usage of each? | Accenture | 2 |
| Can some one please help with a query which will take only
max value of a column in a join. | | 2 |
| How to select Distinct columns from the table, table having
20 columns and i want all coulmns | Wipro | 3 |
| Hi Friends,
I have a table in which there are thousands of records and
in city field there is NULL value for all records now i want
to change that null value with distinct values in each
record say delhi, bihar, agra, jaipur etc, what will be the
query for that?????
its not possible to update thousands of records one by one.
is there any alternative ...?
Plz help ... its urgent
Thanx in advance | | 1 |
| How to Check Whether a Global Temporary Exists in a SQL
Database or not? | | 2 |
| What is normalization and its forms? | Challenger-Financial | 3 |
| From where can you change the default port? | | 3 |
| wt is mean by acid property? i know it is
atomocity,consistency,isolation and durabulaty but wt is
these mean and wt actions it's perform | Idea | 1 |
| What is a stored procedure? | | 3 |
| how to give input dynamically to a insert statement in
sqlserver | HCL | 2 |
| There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better?
| HCL | 1 |
| 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
author? | | 3 |
| Which TCP/IP port does SQL Server run on? | | 2 |
| Hi..here i would like to know the Backup and Restore models? | HCL | 2 |
| What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance.... | Siemens | 6 |
| Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not? | | 3 |
| When do we use the UPDATE_STATISTICS command? | | 3 |
| Explain the architecture of SQL Server? | | 2 |
| What are the type of joins? When do we use Outer and Self joins? | | 3 |
| 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. | | 3 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
