Wednesday, November 17, 2010
Passing Parameter To The SP
Passing Parameter
to pass current datetime as a parameter to an SP. is like this : declare @rrr datetime = getdate() exec
The following will
droprouteprocessing @inpdate = @rrrnot work :
exec
droprouteprocessing GetDate()exec droprouteprocessing @inpdate = getdate()exec droprouteprocessing (select getdate())exec
In
separate droprouteprocessing select getdate() particular, the last two statements will work as though they are sql statements. Hence the SP will execute with default parametersand
the then select GETDATE() statement will be executed, which will display current datetime on console.
Suppose I want
The only way it will work To The SP
Subscribe to:
Post Comments (Atom)
using Microsoft.AspNetCore.Mvc; using System.Xml.Linq; using System.Xml.XPath; //<table class="common-table medium js-table js-stre...
-
Most of the google tutorials on keras do not show how to display a confusion matrix for the solution. A confusion matrix can throw a clear l...
-
Bootstrapping is the process of starting application in angular. The entry point for an angular application is index.html. Index.html loa...
-
http://www.sommarskog.se/share_data.html How to Share Data Between Stored Procedures An SQL text by Erland Sommarskog, SQL Server MVP. M...
No comments:
Post a Comment