"Noor" <noor@ngsol.com> wrote in message
news:OO38tPZXEHA.1888@TK2MSFTNGP11.phx.gbl...
> I have a following table :
>
> CREATE TABLE [dbo].[defaultvalue] (
> [id] [int] IDENTITY (1, 1) NOT NULL ,
> [flag] AS ([id] + 1)
> ) ON [PRIMARY]
> GO
>
> I want to insert the data in it, how can I insert ?
>
> Thanks
> NOOR
>
>

"Hari" <hari_prasad_k@hotmail.com> wrote in message
news:%23zRneCcXEHA.2520@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> Use the DEFAULT VALUES along with insert statement.
>
> insert into dbo.defaultvalue DEFAULT VALUES
>
> --
> Thanks
> Hari
> MCDBA
> "Noor" <noor@ngsol.com> wrote in message
> news:OO38tPZXEHA.1888@TK2MSFTNGP11.phx.gbl...
> > I have a following table :
> >
> > CREATE TABLE [dbo].[defaultvalue] (
> > [id] [int] IDENTITY (1, 1) NOT NULL ,
> > [flag] AS ([id] + 1)
> > ) ON [PRIMARY]
> > GO
> >
> > I want to insert the data in it, how can I insert ?
> >
> > Thanks
> > NOOR
> >
> >
>
>