write the query for find the top 2 highest salary in sql server36 48311
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 6533
Which data type can be used only on OUTPUT parameters of the stored proceduer?2 4106
Alternative way to DetDate() function?5 5304
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 35529
How to delete an attribute from the emp table4 5898
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 2148
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 3890
how to do partition in sqlserver
Does any body please help me what question's have asked for SSRS in the interview?
what is checksum in sql server.........???
how to use DTS package in 2000,2005,2008 in sql server
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
What are the dis_advantages of stored procedures, triggers, indexes?
how many no of arguments can be passed in procedures and functions
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.
1 01 101 01010
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
OPTIMIZATION OF SP,CURSOR,TRIGGERS
How do you Implement SSIS Packages in your Project?
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?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail