Interested to Buy Any Domain ? << Click Here >> for more details...
What are sub-queries? Give example? In which case
sub-queries are not feasible?
- 4 Answers
- 11743 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
Mention the command used to rename the database.
What is 'write-ahead log' in sql server 2000 ?
How many categories of data types used by sql server?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Explain four layers of abstraction microsoft architectured?
What are the advantages of log shipping?
If a table does not have a unique index, can a cursor be opened on it?
Would you store your query in a ssrs report or a database server? State the reason why?
What is identity?
What is database replication?
Explain about SQL server 2005?
Explain about Views?
How to find the login name linked to a given user name?
Do you know the cursor types?
how can you attach more than 20 ldf files in sql server
