Sql Query

use database
declare @TableName nvarchar(100)
declare @Qry nvarchar(500)
declare TrunTable cursor for
select name from Sysobjects where name like '%log'
open TrunTable
fetch next from TrunTable into @tableName
while @@fetch_status = 0
begin
   set @qry = 'truncate table ' +  @TableName
   exec sp_executesql @qry
 fetch next from TrunTable into @tableName
end
close TrunTable
deallocate TrunTable

use database
declare @TableName nvarchar(100)
declare @Qry nvarchar(500)
declare TrunTable cursor for
select name from Sysobjects where name like '%log'
open TrunTable
fetch next from TrunTable into @tableName
while @@fetch_status = 0
begin
   set @qry = 'truncate table ' +  @TableName
   exec sp_executesql @qry
 fetch next from TrunTable into @tableName
end
close TrunTable
deallocate TrunTable


--
--
(¨`·.·´¨) Always
`·.¸(¨`·.·´¨) Keep
(¨`·.·´¨)¸.· Smiling!
`·.¸.·´                  
                 M.Karthikk