ngak bisanya kenapa nih ? ada error messagenya ngak ? coba cek privilegenya u/ user yg konek dari aplikasi, apakah ada hak akses u/ create table...
Regards, ERVIN TI 97 On 2/24/06, ali dharmala <[EMAIL PROTECTED]> wrote: > > sori nanya lagi... > sy uda coba..tp saat execute ga bisa..knp yah ? > sori banget jd repotin... > > --- fly4future <[EMAIL PROTECTED]> wrote: > > > Dear Ali, > > > > ini contoh u/ create table dengan nama table dikirim > > sebagai parameter > > create procedure CreateTable > > > > @strTableName nvarchar(100) > > > > as > > > > declare @Str nvarchar(255) > > > > set @str = 'create table ' + @strTableName + ' (add > > field fieldtype)' > > > > exec(@str) > > > > ------------------- > > cuma harus diingat u/ create table minimal harus > > ada 1 field/column deh, > > makanya contohnya harus di upgrade lagi supaya bisa > > kirim parameter u/ > > fieldnya. yg penting semua parameter diconcate dulu > > jadi satu string > > kemudian baru diexecute. > > > > Semoga membantu... > > > > Regards, > > > > > > ERVIN TI 97 > > On 2/23/06, ali dharmala > > <[EMAIL PROTECTED]> wrote: > > > > > > guys, ada yg ngerti ga cara buat table temporer > > > melalui stored procedure ? ( sql server 2000 ) > > > > > > algo nya sperti ini.. > > > > > > 1.nama_table dikirim dari aplikasi > > > 2 stored procedure terima nama_table sebagai > > parameter > > > 3 kemudian stored procedure eksekusi dengan > > parameter > > > nama_table... > > > > > > sy coba sintaks nya seperti ini " > > > > > > create procedure spTable_temp @nama_table > > nvarchar(xx) > > > as > > > create table @nama_table nomor nvarchar(xx) > > > > > > ternyata tidak jalan... > > > > > > mohon pencerahan nya ? > > > > > > maaf yah kalo pertanyaan nya rada2 susah... > > > > > > thx before... > > > > > > > > > > > > __________________________________________________ > > > Do You Yahoo!? > > > Tired of spam? Yahoo! Mail has the best spam > > protection around > > > http://mail.yahoo.com > > > > > > > > > > > > > > > > > > BinusNet founded on Dec 28, 1998 Owner : Johan > > Setiawan > > > Moderator BinusNet : Suryadi Liawatimena & Surya > > Iskandar > > > > > > > [Non-text portions of this message have been removed] BinusNet founded on Dec 28, 1998 Owner : Johan Setiawan Moderator BinusNet : Suryadi Liawatimena & Surya Iskandar Stop or Unsubscribe: send blank email to [EMAIL PROTECTED] Questions or Suggestions, send e-mail to [EMAIL PROTECTED] -=-=-=-=-=-=-=-=-=-=--==-=--==-=-=--=-=-=-=-=-= Bina Nusantara mempersembahkan 25 Tahun Bersama Binus untuk Indonesia 1981 - 2006 Venue: Plenary Hall, Jakarta Convention Center Date : 25 February 2006 -=-=-=-=-=-=-=-=-=-=--==-=--==-=-=--=-=-=-=-=-= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/binusnet/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
