Stored Procedures

zhaozj2021-02-16  172

What are they SQL statements about Stored Procedures?

Many statements are almost especially: "ShoppingCartmigrate" Stored Procedure: Update ShoppingCart

SET CARTID = @newcartid

WHERE CARTID = @ORIGINALCARTID We know that CARTID is running with the user, when the user does not log in, CARTID is a Dynamically-Generated Guid. After the user logs in, the program needs to use this "ShoppingCartmigrate Stored Procedure," Shopping Cart ", the name of the original shopping cart Changed to CARTID related to the username.

"SHOPPINGCARTLIST" Stored Procedure: In the database, the ShoppingCart table holds this user purchased items. When the user adds the item to the shopping cart, the program adds this item to the database. In order to indicate which item belongs to which shopping cart, the program adds each item with a "CART ID" information (???). And "CART ID" is created by ShoppingCartDB. The Cartid Either From The User's Login Name, or if The User Has Not Yet Logged In, from a Dynamically-generated guid. The Cartid IS A String Which We Use to Identify The User Currently Logged IN.

For details on StoredProcedure, see ASP.NET - StoredProcedure.

转载请注明原文地址:https://www.9cbs.com/read-8971.html

New Post(0)