Sqlserver inserts data in batches Based on the id set. (Use sqlserver built-in functions)

The following example shows the input IDs, such as 1, 3, 4, and 88. It can be processed in the. net background, but I prefer to operate in the database. When inserting data, you can directly paste the code. CREATEPROCEDUREpro_CategorySave (@ idsVARCHAR (400), @ typeINT, @ TemplateIDINT, @ CategoryIDINT) (8000); DELE

The following example shows the input IDs, such as 1, 3, 4, and 88. It can be processed in the. net background, but I prefer to operate in the database. When inserting data, you can directly paste the code. Create procedure pro_CategorySave (@ ids VARCHAR (400), @ type INT, @ TemplateID INT, @ CategoryID INT) (8000); DELE

The scenario is as follows: Input id, Vm, such. It can be processed in the. net backend and Hong Kong server, but I prefer to operate in the database.

This can be done when data is inserted. The Hong Kong server is rented and directly pasted with code.

Create procedure pro_CategorySave (@ ids VARCHAR (400), @ type INT, @ TemplateID INT, @ CategoryID INT) (8000); delete from GaituApp. dbo. templateRelationshipType CategoryID () insert into GaituApp. dbo. templateRelationship (TemplateID, Type, CategoryID, CreateTime, Pid) SELECT (, (20) (@ str) ENDEND