Results 1 to 8 of 8

Thread: Insert statement Issue

Threaded View

  1. Jul 18th, 2012, 02:45 AM #1
    firoz.raj
    firoz.raj is offline

    Thread Starter
    Frenzied Member
    Join Date
    Jan 2009
    Location
    Watch Window(Shift+f9)
    Posts
    1,879

    Question Insert statement Issue

    HI Friends , i have been trying to insert the record but it says the following .let me know some comment .
    Cannot insert explicit value for identity column in table 'PS_SalesDetail' when IDENTITY_INSERT is set to OFF.
    Code:
    insert into ps_salesdetail(SaleInternalDate,SaleSerial,Serial,ItemID,SalesmenID,Serial1,Serial2,Serial3) 
       values('2012-07-17 00:00:00.000','CLEHDTST015-00000011', 383137, 'CLE-29MW020','', 'GRY_GRAY', 'L', 'GRY_GRAY/L' )
    The following statement is also not working .
    Code:
    set IDENTITY_INSERT on ps_salesdetail
    Last edited by firoz.raj; Jul 18th, 2012 at 02:49 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width