Sunday, January 28, 2007

Getting field names of table and view in SQL Server

select
distinct sc.[name]
from
syscolumns sc inner join sysobjects so on sc.id = so.id
where
(so.xtype='V' or so.xtype='T') and so.category = 0
order by
sc.name

SOLID Principle

S.O.L.I.D stands for: When expanded the acronyms might seem complicated, but they are pretty simple to grasp. S - Single-responsiblity...