[ask] sql server 2005 (cendol inside)

PHPmaster

case solved

melon buat yg bisa jwb duluan+bener ya gan soalnya melon terbatas neh

gan, ane lg nyoba2 sql, pk sql server express edition 2005 (os win 7)

pas bikin tabel gini(sblmnya tabel ini blm pernah di create)

Quote:

CREATE TABLE MsEmployee(

EmployeeCode char(5) PRIMARY KEY,

EmployeeName varchar(50),

EmployeeAddress varchar(50),

EmployeePhone varchar(12),

EmployeeSalary numeric,

constraint k1 check(len(EmployeeCode)=5),

constraint k2 check(EmployeeCode like 'KK[0-9][0-9][0-9]'),

constraint k3 check(len(EmployeePhone)>=10),

constraint k4 check(isNumeric(EmployeePhone)=1)

)

pas di execute kok kluar error kayak gini ya??

Quote:

Msg 262, Level 14, State 1, Line 1

CREATE TABLE permission denied in database 'master'.

</div>

Terkait:

Menu