| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is extended StoreProcedure ?
| Satyam | 3 |
| What are Sql Reporting Services and analysis services? Can
u Explain | | 1 |
| Wht is the difference between stored procedure and trigger | TCS | 4 |
| How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
| Oracle | 18 |
| how to find out the repeated value from table using groupby
function? | | 3 |
| How can we write or define DDL statements in Sql server and
DML statements? | | 2 |
| What's the difference between a primary key and a unique key? | Wipro | 8 |
| 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? | | 1 |
| Explain the new features of SQL server 2000? | | 1 |
| How can u convert the Date to String? | TCS | 4 |
| How can you get @@error and @@rowcount at the same time? | | 5 |
| what is curser. | | 8 |
| What is a join and their types? | Challenger-Financial | 2 |
| What do u mean by orphan users, how will u list them in the
DB | IBM | 2 |
| is it possible to use a variable in a query with the IN
clause (a,b,c..z), without getting quotes or conversion
errors? | | 2 |
| 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 the diff between Static Queries and Dynamic queries
give me some examples | CSC | 1 |
| How to give a user the option of importing Excel and a
delimited text file into a SQL Server Database without
manually using SQL DTS?
| GE | 1 |
| How to Check Whether a Global Temporary Exists in a SQL
Database or not? | | 2 |
| Which TCP/IP port does SQL Server run on? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
