Interested to Buy Any Domain ? << Click Here >> for more details...
select top 5 * from emp order by newid()
my question is , how this query get executed?
- 5 Answers
- 11335 Views
- I also Faced
- E-Mail Answers
Answer Posted / kb
Random 5 rows are selected when newid() is used.
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
Can foreign key be duplicate?
How to find the list of fixed hard drive and free space on server?
What will be query used to get the list of triggers in a database?
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.
what is denormalization? : Sql server database administration
Comment,Datatypes are unlimited
Explain forward - only cursors?
What is blocking?
What is fill factor and pad index?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What are trace flags?
How to delete duplicate rows in sql server?
What is acid properties?
Explain what is lock escalation?
What are the features of Embedded SQL
