write the query for find the top 2 highest salary in sql server36 49631
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 6770
Which data type can be used only on OUTPUT parameters of the stored proceduer?2 4261
Alternative way to DetDate() function?5 5539
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 36482
How to delete an attribute from the emp table4 6103
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 2276
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 4061
System variable and temporary variables
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
How to restore performance issues and how to check?
Why do you want to join software field as you have done your BE in Electronics?
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?
how to take backup bcp out for a column in table in sql server?
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?
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.
How retrieve field names from the table in SQL through JAVA code?
What is data modeling and Reterminal integrity?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
If user is owning any SQL Objects, can we drop that user
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
role of sql sever 2005 in database rather than any other database
You are doing log shipping due to some reasons it is failing. How you will proceed from there