Correction of code
£2-200 GBP / hour
I need correction of this code in MS SQL SERVER
MSG>
Msg 102, Level 15, State 1, Line 327
Incorrect syntax near ','.
Msg 4902, Level 16, State 1, Line 538
Cannot find the object "test" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 548
Cannot find the object "test" because it does not exist or you do not have permissions.
CODE- LINE 327
Create table [test]
(
[id_typ_test] Integer NOT NULL,
[set] Numeric(4,0) NOT NULL,
[mee] Numeric(2,0) NOT NULL,
[id_eee] Integer NOT NULL,
[id_test] Integer NOT NULL,
[plan_oo] smalldatetime NULL,
[plan_dos] smalldatetime NULL,
[schl] Varchar(30) NULL,
[uso] Bit NULL,
[odop] smalldatetime ,
[dopo] smalldatetime),
[poc_ho] Numeric(2,0) NULL,
Primary Key ([id_typ_test])
)
CODE LINE 538
Alter table [test] add foreign key([set],[mee],[id_eee])
references [mzd_eee] ([set],[mee],[id_eee])
CODE LINE 548
Alter table [test] add foreign key([id_typ_test])
references [test_dial]
([id_typ_test])
Project ID: #11006630
About the project
68 freelancers are bidding on average £59/hour for this job
Dear Sir, Do you want us to run this query and make sure it is correct or what issues you want us to resolve? Look forward to hearing from you. Regards, YK LEADconcept
We are having an experienced team of php developers and will provide you complete solution as per the requirement . Regards, Ambala
Hello, I am very much interested to fix the problems in your sql statements. I can fix these in a very short time with a cost of total £12 only. Looking forward to have a positive response from you. Thanks
Hi there, I'm a full stack developer so i use MS SQL quite frequently. Solving this error won't be much of an issue - Just send me your file and i'll get back to you with the updated file. Thanks!
======EXPERTS HERE ===== Hello Sir , we can create an attractive and innovative designs upto your expectatiions . We have 5+ years of experience in developing websites with different technologies and assure you that t More
your first problem is here [dopo] smalldatetime), see that extra parenthesis at the end? just remove it, [dopo] smalldatetime, this is good. Your other two errors are due to the fact that test table fails to c More
I have more than 7 years of experience in IT industry.I have worked on sqlserver 2005/2008/2012 and oracle(pl/sql).I can provide you best solution. I have analysed your problem and got solution for this.
Hi you will find my services highly reliable and professional. My Vision : High Quality, High Speed, High Satisfaction! i have 7 years business experience with certified and skilled . We are always looking to pu More
Hello sir, Hope you are well and business is prosperous. Please message me once so we can discuss about your requirement in detail & also i can show my work to you I am looking for opportunities to work for yo More
Hi, Please send me screenshots of error and application running instance images AS description not enough to understand about the issue. thanks Narendra ///////////////////////////////////////////////////////// More
hi, i am certified ms sql server expert (mcse: data platform). would be glad to help you with this project. regards, yuri
We can easily solve this error for you. According to your needs and wants . In your budget and time span. We have a team of experts and experience devwloers who can easily full fill this task for you as per your need More