Write an SQL query if u want to select the data from one
block which intern reflects in another block ?
thanx,do reply
- 1 Answers
- 6316 Views
- Covansys, I also Faced
- E-Mail Answers
Answer Posted / jerald
select * into table1 from table
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
How do I create a trace in sql server?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How can we solve concurrency problems?
List the ways in which dynamic sql can be executed?
How to remove duplicate rows from table except one?
How can I check that whether automatic statistic update is enabled or not?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How to enter binary string literals in ms sql server?
What is a coalesce function?
What is subquery? Explain the properties of a subquery?
What is an indexed view?
Is it possible to have clustered index on separate drive from original table location?
Can we do dml on views?
When should you use an instead of trigger?
What is temporary table in sql server? Why we use temp table?
