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 > > > > > > Stop or Unsubscribe: send blank email to > > [EMAIL PROTECTED] > > Questions or Suggestions, send e-mail to > [EMAIL PROTECTED] > > > > > > > > SPONSORED LINKS > > Bali indonesia > hotel<http://groups.yahoo.com/gads?t=ms&k=Bali+indonesia+hotel&w1=Bali+indonesia+hotel&w2=Bali+indonesia&w3=Indonesia+hotel&w4=Bali+indonesia+vacation&w5=Bali+indonesia+travel&c=5&s=123&.sig=FcSdZuv000_iKRStUv7Qmg> > Bali > > > indonesia<http://groups.yahoo.com/gads?t=ms&k=Bali+indonesia&w1=Bali+indonesia+hotel&w2=Bali+indonesia&w3=Indonesia+hotel&w4=Bali+indonesia+vacation&w5=Bali+indonesia+travel&c=5&s=123&.sig=Nzxn7pvH7_bTcG_OcN5NPA> > Indonesia > > > hotel<http://groups.yahoo.com/gads?t=ms&k=Indonesia+hotel&w1=Bali+indonesia+hotel&w2=Bali+indonesia&w3=Indonesia+hotel&w4=Bali+indonesia+vacation&w5=Bali+indonesia+travel&c=5&s=123&.sig=JhZzOf-kcZtgWYvp3wXK3Q> > Bali > > indonesia > vacation<http://groups.yahoo.com/gads?t=ms&k=Bali+indonesia+vacation&w1=Bali+indonesia+hotel&w2=Bali+indonesia&w3=Indonesia+hotel&w4=Bali+indonesia+vacation&w5=Bali+indonesia+travel&c=5&s=123&.sig=8SZolPw5LjtbkZq5nF6Gyg> > Bali > > indonesia > travel<http://groups.yahoo.com/gads?t=ms&k=Bali+indonesia+travel&w1=Bali+indonesia+hotel&w2=Bali+indonesia&w3=Indonesia+hotel&w4=Bali+indonesia+vacation&w5=Bali+indonesia+travel&c=5&s=123&.sig=umDOCW29HFHgP59NHv-Ukg> > > ------------------------------ > > YAHOO! GROUPS LINKS > > > > > > - Visit your group > "binusnet<http://groups.yahoo.com/group/binusnet>" > > on the web. > > > > - To unsubscribe from this group, send an > email to: > > > [EMAIL PROTECTED]<[EMAIL PROTECTED]> > > > > - Your use of Yahoo! Groups is subject to the > Yahoo! Terms of > > Service <http://docs.yahoo.com/info/terms/>. > > > > > > ------------------------------ > > > > > [Non-text portions of this message have been > removed] > > __________________________________________________ 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 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/
