Clear temp data in SQL and SharePoint database

DECLARE @DB VARCHAR(255)
DECLARE C CURSOR FOR
SELECT NAME FROM SYS.DATABASES WHERE IS_READ_ONLY=0 AND STATE=0
AND NAME NOT IN (‘master’,’model’,’tempdb’,’msdb’)
OPEN C
FETCH C INTO @DB
WHILE @@FETCH_STATUS=0
BEGIN
EXEC SP_DBOPTION @DB,’trunc. log on chkpt.’,’true’
DBCC SHRINKDATABASE (@DB)
FETCH NEXT FROM C INTO @DB
END
CLOSE C
DEALLOCATE C

Follow below link, to reduce database or log files after above execution

http://sensoft2000-sharepoint.blogspot.ae/2014/10/how-to-shrink-wsslogging-database.html