Default or Optional Parameters are declared by assigning a default value to them. Then it is not necessary to pass any value to them while calling the SP, it will take the default value in case nothing is passed.
this is very useful,
create proc test
@studentid bigint = NULL
as
begin
if ( @studentid is not null )
select * from sec45.dbo.DailyAttendanceTable
where StudentId = @studentid
else
select * from sec45.dbo.DailyAttendanceTable
end
exec test --returns all rows
exec test 1285 -- returns only one row
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