write the query for find the top 2 highest salary in sql server36 48720
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 6575
Which data type can be used only on OUTPUT parameters of the stored proceduer?2 4147
Alternative way to DetDate() function?5 5365
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 @ email@example.com 35740
How to delete an attribute from the emp table4 5951
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 2179
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 3930
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
If a stored procedure is taking a table data type, how it looks?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
where the connection string store in the database
How much memory that we are using in Logshipping Concept?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
How you trouble shoot when any job fails
what is isolation level at dead lock?