Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL2000 SQL-server-2005 SQL , +
CREATE TABLE empDetails (
EMP_ID int(11) primary key NOT NULL,
password varchar(10) NOT NULL
);
 

First tabel is crete. i got error second table. i am using manaement studio 2008R2.
 
CREATE TABLE LEAVE_DETAILS (
EMP_ID int(11) foreign key NOT NULL,
leaveEarnedBalance float(2) ,
leaveEarnedCredit float(2),
leaveCasualBalance float(2) ,
leaveCasualCredit float(2),
leaveMaternityBalance float(2) ,
leaveMaternityCredit float(2)
);
 
how to rectify this
Posted 24-Feb-12 20:24pm
20119991.2K

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

try this
CREATE TABLE LEAVE_DETAILS ( 
EMP_ID INT NOT NULL,
leaveEarnedBalance float(2) ,
leaveEarnedCredit float(2),
leaveCasualBalance float(2) ,
leaveCasualCredit float(2),
leaveMaternityBalance float(2) ,
leaveMaternityCredit float(2)
);
  Permalink  
Comments
Subbu1999 at 25-Feb-12 1:37am
   
thank u
Command(s) completed successfully.
aniketyadav7 at 25-Feb-12 1:38am
   
Please accept and vote the answer if it has helped you

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 295
1 DamithSL 265
2 CPallini 235
3 Maciej Los 190
4 Sergey Alexandrovich Kryukov 174
0 OriginalGriff 5,415
1 DamithSL 4,422
2 Maciej Los 3,820
3 Kornfeld Eliyahu Peter 3,470
4 Sergey Alexandrovich Kryukov 2,911


Advertise | Privacy | Mobile
Web02 | 2.8.141216.1 | Last Updated 25 Feb 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100