| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how insert selected column only ? | Robert-Half | 2 |
| how to retrive only second row from table in sql server
2000? | CTS | 7 |
| Wht is the difference between stored procedure and trigger | TCS | 4 |
| What are functions | | 3 |
| How to Check Whether a Global Temporary Exists in a SQL
Database or not? | | 2 |
| What are the main control-of-flow T-SQL constructs?
| | 1 |
| Questions regarding Raiseerror? | | 1 |
| Questions on identity? | Infosys | 1 |
| Explain Trigger with an example?
| | 1 |
| how to find number of columns in a table in sql server 2000
and 2005 also | Virtusa | 7 |
| when inserting to a table how many rows will be effected
using triggers
| | 1 |
| what is meant by sql injection with example and one more
question how to catch the errors in sqlserver | | 1 |
| i have table students with fields classname,studname
select * from students
classname studname
1 xxxxx
1 yyyy
1 zzzz
2 qqqq
2 tttt
3 dsds
3 www
i want the output should be
No of students in class 1 : 3
No of students in class 2 : 2
No of students in class 3 : 2
| HCL | 2 |
| Can you link only other SQL Servers or any database servers
such as Oracle? | | 1 |
| you are provided with the single table having say 4 col ie
fname lname age city , now the all records with displying of
only fname and lname is required but in this format say my
name is abhay khanna it will come like this
abhay-khanna
rahul-roy
gaurav-singh
the above format is required | | 2 |
| how to get 25th row in any table in sqlserver can u tell me
syntax | | 4 |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 4 |
| system date format is "yy-mm-dd"
"select getdate()" ----> 2009-01-24 20:03:28.513
if i write "select dateadd(dd,2,getdate())
".it returns "2009-01-26 19:59:38.340"...my question is dat
could it be possible to retrive da date in da format "26
jan 2009 ...."??
| | 8 |
| What are the different types of joins and what does each do? | | 2 |
| what command is used to create a table by copying the
structure of another table? | | 5 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
