in

The ORM Foundation

Get the facts!

DDL datatype mapping

Last post Wed, Sep 12 2007 14:02 by JO3Y. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • Wed, Sep 12 2007 14:02

    • JO3Y
    • Top 25 Contributor
    • Joined on Sat, Mar 8 2008
    • Posts 34

    DDL datatype mapping

    Temporal:Date maps to SQL server as such:
    
    CREATE TABLE SBSSM.OrderHistory
    (
    	"Date" BIGINT , 
    	DeltaDeposit DECIMAL, 4) NOT NULL, 
    	DepositTender_TenderEntry_ID BIGINT NOT NULL, 
    	Order_Order_ID BIGINT NOT NULL, 
    	CONSTRAINT IntrnlUnqnssCnstrnt117 PRIMARY KEY(DeltaDeposit, DepositTender_TenderEntry_ID)
    )
    
    1. should not be BIGINT
    
    2.also note money type scale 4 maps to DECIMAL, 4) <-- invalid TSQL
Page 1 of 1 (1 items)
© 2008-2024 ------- Terms of Service