| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 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 |
| Questions on identity? | Infosys | 1 |
| How would you Update the rows which are divisible by 10,
given a set of numbers in column? | | 1 |
| Assume,there are three tables in a database, Can i have
both primary key and foreign key for each table in the same
database? | | 4 |
| what are three different authentications to connect linked
servers? | CitiGroup | 1 |
| HOW TO RENAME A COLUMN NAME | | 2 |
| how to get 25th row in any table in sqlserver can u tell me
syntax | | 4 |
| What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they. | IBM | 5 |
| what are batch in sql server?
| Satyam | 2 |
| What is cursor ? And what is difference between Trigger ? | HCL | 1 |
| What are the magic tables in SQL Server 2000? | Infogain | 5 |
| What is the difference between a Local temporary table and a
Global temporary table? How is each one used? | | 1 |
| What is the appropriate number of test cases that you can
write on a database? | Microsoft | 1 |
| Let’s say the table in the database is named as
TBL_Register. The fields in this table include:
1. User_Name,
2. User_Telephone,
3. Register_Date
The field Register_Date stores the current date and time of
the registration.
Write the SQL statement that inserts the data into the
table. | Techno-Solutions | 2 |
| what is syntex second or third highest salary.
thanks & Regards
Dhirendra sinha | | 4 |
| what operator performs pattern matching? | | 1 |
| What are the types of model in sql server and explain | TCS | 1 |
| Say if we have a table that contains only a single column ,
say OrderID, which has IDENTITY attribute defined on it. So
how can we insert data in this table.
I am reframing my question, that how can we make the table
to increment the column "OrderID" value several times??? | | 3 |
| What is the use of CASCADE CONSTRAINTS? | | 2 |
| Which data type can be used only on OUTPUT parameters of the
stored proceduer? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
