Temporary table ada 2 jenis yang local dan global, kalo kamu buat yang local
maka sintak tsb hanya dapat diakses dalam 1 session saja, perintah exec.... itu
termasuk session yang beda.Coba buat create temporary yang global
Badas <[EMAIL PROTECTED]> wrote: Coba cara ini :
exec ('select * into ' + @nm_table + ' from Table_ABC')
ali dharmala <[EMAIL PROTECTED]> wrote:
guys,
mo nanya...
gmana cara nya buat table temporer yang nama table
temporer nya ditrigger dari user ( lwt aplikasi )
c/o :
create procedure AA
@nm_table nvarchar(10)
as
select *
into @nm_table
from table_ABC
go
knp ga jalan yah script diatas ??
regards
-KA 95-
__________________________________________________________Building a website is
a piece of cake. Yahoo! Small Business gives you all the tools to get online.
http://smallbusiness.yahoo.com/webhosting
---------------------------------
Pinpoint customers who are looking for what you sell.
[Non-text portions of this message have been removed]
Send instant messages to your online friends http://uk.messenger.yahoo.com
[Non-text portions of this message have been removed]
