Interested to Buy Any Domain ? << Click Here >> for more details...
What is the datatype returned by count(*)
- 22 Answers
- 38036 Views
- 247Customer, Asian CERC, I also Faced
- E-Mail Answers
Answer Posted / vikram k mahapatra
It return Int datatype
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain what is log shipping?
Explain try...catch with sql server?
What are the events recorded in a transaction log?
How to create sub reports?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
Which Model uses the SET concept
How much is a sql server license?
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.
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
What do you understand by physical_only option in dbcc checkdb?
Which table keeps information about stored procedures?
What is difference between count (*) and count 1?
Difference between Logical Page and Physical Page in SSRS.
Explain insert into select statement?
How to grant a permission in ms sql server using "grant execute" statements?
