How to set Identity in sql

Question

I want to set identity by query . . in my table column sno i am set all ready set identity to yes but i want to set id column as a identity in a query how'z the possible suggest me .