|
nigelrivett
Flowing Fount of Yak Knowledge
United Kingdom
3328 Posts |
 Posted - 06/08/2012 : 06:43:50
|
By temporary do yoou mean those that are only available to the batch/spid and get dropped automatically?
create table #a (i int)
can also create from a query
select * into #a from mytbl where x = 'a'
global temp table is
create table ##a (i int)
==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy. |
 |
|
create table
