If you are looking to increment the number automatically whenever you insert a new record, try Identity(1,1) on that column, so that it gets automatically incremented.
Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.