| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is a Stored Procedure? | | 7 |
| What is row by row processing ? | | 1 |
| Explain different isolation levels? | | 3 |
| Please give me the SP for the below scenario. I have two
tables named Table1 and Table2...I need to fetch record by
record from Table1 and insert the record in to table2 where
the value in the sno column of the table1 is even number. | Value-Labs | 4 |
| PC(code, model, speed, ram, hd, cd, price)
Find the hard drive sizes that are equal among two or more
PCs.
| APX | 2 |
| What is the diff between Dynamic queries and static queries
| ICS-Integrated-Computer-Solutions | 1 |
| How to list all tables having unique constraints in any of
the columns in a database. | | 1 |
| WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE
RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,... | TVS | 2 |
| what is the difference between sql query and google query? | TCS | 6 |
| Explain DBMS, RDBMS? | | 4 |
| How can I create a plain-text flat file from SQL Server as
input to another application? | | 2 |
| What are three SQL keywords used to change or set someone?s
permissions? | | 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 |
| What is the use of MOVE keyword in restore command | IBM | 2 |
| what is difference between having and where clause ? | | 2 |
| write the query for taking database restore in sql? | | 2 |
| 9. Write a query to list a new column with the
difference in temp of the cities Delhi and Mumbai, Mumbai
and Jammu and soon. Consider the following table :
City_id City Temp.
1 delhi 40
2 Mumbai 35
3 Jammu 32
4 Pune 18
| | 2 |
| What is the difference between a Local temporary table and a
Global temporary table? How is each one used? | | 1 |
| how to select 5 to 7 rows from a table, which contains 10 rows? | IBM | 14 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
