Grant Fritchey wrote:
Here's a code sample showing how C# calls a stored procedure. Compare that to 'EXEC dbo.MyProc' in SSMS. One is a remote procedure call. The other is a batch command. Both are ways to call stored procedures, but one is programmatic, the other isn't.
Does that help?
thank you !
I know there are 2 ways to execute SQL Scripts, one is to be called in the front end ( called by the front application , such as, c#/vb.net/Java/python...) , the other is to be called in SSMS( maybe on the sql server local server, maybe not), I know the first approach which it is RPC called, but I don't know if there is any way of RPC to called sql script. thanks