ͻ񻣼
--¹¹Ôì²âÊÔÊý¾Ý£º Ö»×÷ÑÝʾÓÃCREATE TABLE [dbo].[Tim_LinqTable]([Id] int PRIMARY KEY IDENTITY(1,1) NOT NULL,[Name] [varchar](50) NOT NULL,[Parent] int NOT NULL,)GOINSERT INTO [Tim_LinqTable] SELECT 'A',0 UNION ALLSELECT 'A1',1 UNION ALLSELECT 'A2',1 UNION ALLSELECT 'B1',2 UNION ALL ÔĶÁÈ«ÎÄ
ͻ񻣼
´ò¿ªSql server management studio²¢Ð½¨Ò»¸ö²éѯ£¬ÔÚ´ò¿ªµÄ£Ø£Ø£Ø£®£Ó£Ñ£ÌÎļþÖÐÊäÈ룺execsp_MSforeachtable @command1='Delete from ?'execsp_MSforeachtable @command1 = "TRUNCATE TABLE ?"È»ºóÖ´ÐÐÓï¾ä¡£------------------------------------------------------------------------------------------Èç¹ûÓÉÓÚÍâ¼üÔ¼Êøɾ³ýtableʧ°Ü£¬ÔòÏÈɾ³ýËùÓÐÔ¼Êø£º--/µÚ ÔĶÁÈ«ÎÄ