write the query for find the top 2 highest salary in sql server36 55618
there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C9 7930
Which data type can be used only on OUTPUT parameters of the stored proceduer?2 4777
Alternative way to DetDate() function?5 6561
How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ firstname.lastname@example.org 41173
How to delete an attribute from the emp table4 6876
If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?2 2703
How we create SQL Server 2005 Reporting Services ? Give me Sample
wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform
how to find out the repeated value from table using groupby function?4 4759
What is the temp table?
what kind of lan types do you know? : Sql server database administration
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
How can you swap values between two rows in a table using single- SQL statement?
Can sub report data source be different from that of the parent report?
Mention the different authentication modes in sql server.
What is difference between order by and group by?
Explain the functionalities that views support?
What is set nocount on and what is set nocount off?
What is model database in sql server?
what are the Prerequisites for Replication?
Explain logical operators in sql server?
What is the data type of time?
What are the extra roles available in msdb? : sql server security
When would you use a before or after trigger?