While working on a project sometimes it happened that we need to shift the database from one server to another due to various reason (sometimes it is only money ). We are aware that this easy step take backup and restore another machine but glitch is what about the users which have access to the …
Although it is a old feature for those who knows ORACLE but for SQL server developers it is a new feature. Let understand it by an example. Suppose we want an auto incremented column a part from primary key which is a identity column, then to achieve this we can use sequence feature. We can …