Get Column Names and Column count number in MSSQL ?

For Name Try this :

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = 'my_table'

For Column count Try this :

SELECT Count(*) FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = 'my_table'