SQL Server stored Procedure nesting sample

1 Case Database table:

Enterprise Information table

Table name	Prd_wxt_enterprise_tbl_enterpriseinfo
Data sources
Storing data	Enterprise Information table
Primary key/FOREIGN key
Field name	Description	Type (Precision range)	Note
Centerpriseid	N Enterprise ID	Char (10)
Senterprisename	N Enterprise Name	Varchar (200)
Sshortname	n abbreviation	Varchar (50)
Saddress	N Address	NVarchar (200)
E_system	N Enterprise-owned systems (0 new systems, empty or 1 for old systems)	Char (1)

Product table

Table name	Shop_tbl_productinfo
Data sources
Storing data	Product table
Primary key/FOREIGN key
Field name	Description	Type (Precision range)	Note
P_code (PK)	N Product SKU Number, that is, the next number, Product System No. (P123456789)	Char (10)	NOT NULL
Enterpriseid	N Enterprise ID	Char (10)	NOT NULL
P_name	N Product Name	Nvarchar (100)	NOT NULL
P_price	N Product price (unit yuan)	Money
P_userprice	N Product member Price (unit yuan)	Money
Remark	N Remarks	Nvarchar (500)