How to set Identity in sql

Apr 11 2011 4:14 AM

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 .