Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Inserting value in an identity column

Comment:

Hi, Here's a short program of a table in SQL. create table students ( rollno int identity, name char(20) ) In order to insert explicit value in the identity column (i.e. rollno), I need to specify that the identity_insert is on. After having this mode on, if I insert the value (0008) in the identity column then after the execution of the query, the value is displayed as (8), whereas I want it to be (0008). Please help me to do so.

Configuring SQL Query Bro...

querying dates

Summary: Have a look at the dates thing, as above. Also, you're inserting decimal values in a column which you've said is an integer. maxm and minm are both created as integers, then you're trying to drop in 3...

Summary: i have a table with n columns, of which in 2 columns each may have similar values for certain number of rows i want to find if one of the entries in a column has same value in the next few rows if so ...

Summary: After having created a table and inserted values in it, is there any way to change the length of the datatypes in SQL Server? ...