| Other SQL Server Interview Questions |
|| Asked @
|What is the difference between the following two sql
select count(*) from <tablename>
select count(col_name) from <tablename>
|Define Check points and End Points?
|What is Transaction?
|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...
|What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same?
|IN Vs OR operator which is best to use sql server.
|How to swap the data of two columns in a table. both the
columns containing varchar values.
|can foreign key take role of primary key?
|Differences between Standby Vs No recovery?
|what is the difference between sql query and google query?
|i have a table #temp1(id, Name groupname ) and record
like this 1 R1 S
2 R3 S
3 R2 S
4 R4 D
5 R5 D
6 R6 K
7 R7 K
8 R8 L
9 R9 L
10 R10 L
11 R11 K
and i want to display record based on user defind sorting
1 R4 D
2 R5 D
3 R6 K
4 R7 K
5 R11 K
6 R1 S
7 R3 S
8 R2 S
9 R8 L
10 R9 L
11 R10 L
|If suppose in a table ship(name,year),find ship name having
first and last name(i.e having space in between)
ex: SAINT LOUIS,JET LAKE.
|For more SQL Server Interview Questions Click Here |