If you try to truncate a table that is referenced by foreign key you usually get the following error:
Cannot truncate table 'TableName' because it is being referenced by a FOREIGN KEY constraint.
To avoid this error the easiest way to use DELETE without where clause and RESEED the identity:
DELETE FROM AccVoucher
DBCC CHECKIDENT (AccVoucher, RESEED, 0)
Use the OpenAI Assistant Starter Kit to Quickly Build New OpenAI Apps
-
I’m excited to announce the OpenAI Assistant Starter Kit — a sample chat
application designed to enable you to quickly get started building
fully-functio...
3 days ago
No comments:
Post a Comment