Home Forums SQL Server 7,2000 T-SQL How to Execute quary in store procedure RE: How to Execute quary in store procedure

  • But why do you want to create the temp table in two steps, is there any specific reason, you can as well create it with the

    CREATE table #mytable (column1 datatype ) syntax directly right? Sorry if I am missing anything here. Well if you are passing the table structure as input parameter to the sp and executing it then it is  a different case though.

     

    Thanks

    Prasad Bhogadi
    www.inforaise.com