'to run this query ,to get result of non using primary key or cluster index tables

SELECT name ,case when objectproperty(object_id,'TableHasPrimaryKey') =0 then 'No' else 'Yes' end IsPrimaryKey,

case when objectproperty(object_id,'TableHasClustIndex') =0...

select convert(char(4),datename(yyyy,'01/01/2008'))+convert(char(2),datepart (wk,'01/01/2008'))