Wednesday 7 September 2016

How can call stored procedure inside function in SQL server ?

 DECLARE @SQL VARCHAR(500)

 SELECT  @SQL = 'osql -S' + @@servername
                                + ' -E -q "exec [DataBaseName].[dbo].StoreProcedureName"'

EXEC master..xp_cmdshell @SQL

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...