Tuesday 29 September 2015

Insert Table To Stored Procedure Return Multiple Recored


        SELECT  *
        INTO    #MyTable
        FROM    OPENROWSET('SQLNCLI',
                           'Server=ServerName;Database=DataBaseName;Uid=UserName;Pwd=Password;',
                           'StoreProcedureName ') ;

No comments:

Post a Comment

SqlDataBaseLibrary

using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using AOS.Repository.Infrastructure; using S...