write the query for find the top 2 highest salary in sql server36 49105
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 6661
Which data type can be used only on OUTPUT parameters of the stored proceduer?2 4207
Alternative way to DetDate() function?5 5429
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 36035
How to delete an attribute from the emp table4 6017
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 2227
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 3982
Call by value and call by reference in procedure and function, with NOCOPY.
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
Working with TLogs
whats new about truncate in sql server 2008?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
System variable and temporary variables
on line cluster can we make if yes tell me the procedure
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
Delete duplicate rows without using rowid.
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
Any one plz send me SQL Server Developer/DBA resume for 4 years experience