select * into table1 from table

Write an SQL query if u want to select the data from one
block which intern reflects in another block ?

thanx,do reply

Question Posted / jerald

Answer Posted / jerald

Is This Answer Correct ?

3 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What do we need queues in sql service broker?

1003

How can I track the changes or identify the latest insert-update-delete from a table?

913

How to turn on the mssql api module in php?

1015

State a few properties of relational databases?

1060

How to convert numeric values to integers in ms sql server?

1007

What is the difference between having clause and where clause in sql server?

1031

Do you know spatial data types - geometry and geography in sql server 2008?

969

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1004

How can you find out how many rows returned in a cursor?

969

Can we shrink data file in sql server?

997

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

977

how you can configure a running aggregate in SSRS?

184

what information is maintained within the msdb database? : Sql server administration

913

Differentiate between delete and truncate.

995

Where can you add custom error messages to sql server?

1054