Mithilesh_SQL

Sql with Json

https://msdn.microsoft.com/en-in/library/dn921882.aspx

Format Query Results as JSON with FOR JSON (SQL Server)

Renaming existing column in sql

sp_rename '[tablename.oldcolumnname]','[newColumnName]','COLUMN'

Example :-
sp_rename 'employee.empid','emplooyeeID','COLUMN'

Creating Primary key constraint on existing column...

ALTER TABLE Employee ADD CONSTRAINT pkEmpID PRIMARY KEY (EmpId)