Category Archives: General

Difference between abstract classes and interfaces

Very basic question but important to point out. Abstract classes can have concrete methods while interfaces have no methods implemented. Interfaces do not come in inheriting chain, while abstract classes come in inheriting chain. Interfaces have only pure virtual abstract method, while abstract classes may have non-abstract methods. All members are public [by default] in

Read More

How to locate names of all columns in a table?

I found the following query is very much worth-full when you are looking for names of all columns in a table SELECT (o.name) AS [Table Name], o.type, c.name AS [Col Name], s.name AS [Col Type], c.prec, c.scale, c.isnullableFROM dbo.sysobjects AS o INNER JOIN dbo.syscolumns AS c ON c.id = o.id INNER JOIN dbo.systypes AS s

Read More