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] 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] 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/
