Creating output parameters To create an output parameter for a stored procedure, you use the following syntax: 1 parameter_name data_type OUTPUT A stored procedure can have many output parameters. In addition, the output parameters can be…
Creating a simple stored procedure The following SELECT statement returns a list of products from the products table in the BikeStores sample database: 1234567 SELECT product_name, list_priceFROM production.productsORDER BY product_name; To create a stored procedure that wraps this query, you…
Creating a stored procedure with one parameter The following query returns a product list from the products table in the sample database: 1234567 SELECT product_name, list_priceFROM production.productsORDER BY list_price; You can create a stored procedure that wraps this query using the CREATE…
What is a variable A variable is an object that holds a single value of a specific type e.g., integer, date, or varying character string. We typically use variables in the following cases: As a loop counter to count…
Check the apirouteconfig file in App_Data folder of the web API
The Layout<T> class is abstract, but four classes derive from Layout<View>, a class that can have multiple children of type View. In alphabetical order, these four classes are: AbsoluteLayout Grid RelativeLayout StackLayout Each of them…
Razor Pages are a new feature of ASP.NET Core that makes coding page-focused scenarios easier and more productive. Razor pages use handler methods to deal with the incoming HTTP request (GET/POST/PUT/Delete). These are similar to Action…
Some times the apps didn’t work after we deploy it on azure and it shows errors like this:App cannot be started.NET Core 4.6.27817.03 X86 v4.0.0.0 | Microsoft.AspNetCore.Hosting version 2.2.0-rtm-35687 | Microsoft Windows 10.0.14393 try the following…
There are two types of environment block in your layout page, as you can see below, Most of times we add the css and js in include development environment but misses the exclude development environment.
Open SQL Server Management Studio From the file menu, choose Tools à Options From the left menu, choose Designers Uncheck the box entitled Prevent saving changes that require table re-creation Press OK to save