Question { Choice Solutions, 6589 }
Regarding joins what are the differences you observed in
oracle 9i and sql server?
Answer
Is This Answer Correct ? | 0 Yes | 1 No |
Question { 19033 }
what is explain plan?
Answer
Is This Answer Correct ? | 11 Yes | 1 No |
Question { 3926 }
when inserting to a table how many rows will be effected
using triggers
Answer
Is This Answer Correct ? | 1 Yes | 0 No |
Question { 7908 }
what is the difference between group and having
give an example with query and sample output
Answer
Is This Answer Correct ? | 3 Yes | 0 No |
i want to create procedure for create table in sql server
2005
for example
create procedure create_table
@table varchar(20)
as
create @table(
id int,
name char(20)
)
but it will get error
what is solution?
Answer
Is This Answer Correct ? | 1 Yes | 0 No |
Question { 247Customer, 3946 }
How to handle errors in Stored Procedures. I want to display
a message to the user in the .aspx page that is calling a
stored procedure in it's code behind. please help me.
Answer
Is This Answer Correct ? | 1 Yes | 0 No |
Question { 3029 }
Define Check points and End Points?
Answer
Is This Answer Correct ? | 4 Yes | 0 No |
Question { 7307 }
What is Schema? and why we use schemas?
Answer
Is This Answer Correct ? | 8 Yes | 0 No |
Question { 7720 }
what is syntex second or third highest salary.
thanks & Regards
Dhirendra sinha
Answer
Is This Answer Correct ? | 1 Yes | 0 No |
Question { 5924 }
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
order e.g.
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
Answer
Is This Answer Correct ? | 2 Yes | 0 No |
Question { 10848 }
Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)
Answer
Is This Answer Correct ? | 1 Yes | 1 No |
how to get the maximum among two tables,for example table 1
(dep1) have (emp_id,emp_name,salary) columns and table 2
(dept2) have (emp_id,emp_name,salary) columns,i want which
employee have the maximum salary among two tables?
Answer
Is This Answer Correct ? | 3 Yes | 0 No |
What is the joins and how many types of Joins in sql server
a diffrentiate ever one give a suaitable query
Answer
Is This Answer Correct ? | 3 Yes | 1 No |