Code createPROC P_DelAllUserTableData as Begin declare@namevarchar(50) Declare Cur CursorFor select Name from sysobjects where xtype='u'and status>=0and Name like'%Test%'--数据库名字 declare@SQLVarchar(300) Open Cur Fetch Cur Into@name While@@FETCH_STATUS=0 BEGIN Set@sql='DELETE '+@name+'' Exec(@sql) Fetch Cur Into@name End Close Cur Deallocate cur End GO