| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| We create an index to fast the search. How it fast the
query? Do we write any special keyword with query? | | 3 |
| i have 4 tables.. T1, T2, T3, T4..
these tables have the same structure and they store the
information entered in different years..
T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored
2005..
i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and
T4 to T1..
how do i do that? Temp tables cannot be used.. | | 2 |
| how to select a field with firstletter as capital and
remaining are small letters | | 8 |
| can you any body tell me why are go for the rebuild the
master database.what is the reason? | | 1 |
| what is physical sort data and logical sort data in index? | | 2 |
| logshipping is Any difference 2000 and 2005? | | 1 |
| Accidentally i deleted my table. How can i get that table? | | 4 |
| 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 types of integrity are enforced by a foreign-key
constraint
| | 1 |
| What is normalization and what are the different forms of
normalizations? | | 1 |
| UPDATE statement can on a single table or on the multiple
table? | iGate | 5 |
| How can i give the restrictions for the data entry, if i
wish to enter only I ,II, III, IV in the grade actegory of
student table? | | 3 |
| 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 |
| 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 |
| I have a table in which phno is one of the columns.i do have
some values in tht phno column.i need to update phno column
values with 0(zero) as prefix.give me a correct solution plz... | Value-Labs | 5 |
| Write an SQL query if u want to select the data from one
block which intern reflects in another block ?
thanx,do reply | Covansys | 1 |
| How do we get current date in SQL Server 2000, Oracle, MS
Access? | | 11 |
| Can store procedure call by user define function in SQL
server? | HCL | 6 |
| I am Having tables T1 and T2 both having same data how to
check (or) compare the data in both table are same? | | 2 |
| Display a roll having miminum marks in two subjects? | Patni | 7 |
| |
| For more SQL Server Interview Questions Click Here |