Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
allen_k85
Starting Member
3 Posts |
 Posted - 2009-12-07 : 23:24:31
|
| Hey everyone, below are some of my questions. Would really appreciate if anyone can answer it. 1) can u please let me know the limitation of using "Select * from tablename" statement. i mean,how much maximum rows it can return if i use this statement.2) Will the statement "Select getdate()" (no from clause) work in sql..dont have sql at home.With Regards,AllenAllen |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-12-08 : 00:26:06
|
1) all the rows in the table. No limit at all2) yes. It will return you the current date & time
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-12-08 : 01:40:53
|
| 1 It returns as many as it has. But limit it by where clause for better performance2 It will work. Only in ORACLE you need FROM DUALMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Limitation of " Select * " statement