What are sub-queries? Give example? In which case
sub-queries are not feasible?
- 4 Answers
- 10334 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / akhil
text and image datatypes are not allowed in
subqueries.Subqueries cannot manipulate their results
internally, that is, a subquery cannot include the order by
clause, the compute clause, or the into keyword.
Correlated (repeating) subqueries are not allowed in the
select clause of an updatable cursor defined by declare cursor.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are sparse columns?
What is the usage of sign function?
What is difference between createstatement and preparedstatement?
Can foreign key be duplicate?
what are database files and filegroups? : Sql server database administration
how to use DTS package in 2000,2005,2008 in sql server
What is log cache in sql server?
What is a full text index?
Is ssrs support other database except ms sql server?
How dts is used to extract, transform and consolidate data?
What are exact numeric data types in ms sql server?
Can we add our custom code in ssis?
What are views in ms sql server?
What is a result set object returned by mssql_query()?
Explain system rowset functions?
