Correction of code

Cancelado Publicado hace 7 años Pagado a la entrega
Cancelado

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])

Servidor de Microsoft SQL MySQL PHP Arquitectura de software SQL

Nº del proyecto: #11006630

Sobre el proyecto

68 propuestas Proyecto remoto Activo hace 7 años

68 freelancers están ofertando un promedio de £59 / hora por este trabajo

leadconcept

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

£222 GBP / hora
(130 comentarios)
9.4
ambalaonline1

We are having an experienced team of php developers and will provide you complete solution as per the requirement . Regards, Ambala

£20 GBP / hora
(577 comentarios)
8.8
sismaster

Greetings for the day This is poonam FULL TIME FREELANCER having 6+ YEARS of experience in MySQL, Wordpress and PHP development. I can do this please discuss me so that i can start correction of code as you want. Más

£14 GBP / hora
(733 comentarios)
8.0
gopalvora

Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joo Más

£7 GBP / hora
(538 comentarios)
8.4
sumon355

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

£6 GBP / hora
(401 comentarios)
8.1
alyaspk

Dear Employer, I am ready to work on your required task and can assure 100% satisfaction. You can read reviews/details about my past work on my profile http://www.freelancer.com/u/alyaspk.html Looking forward t Más

£52 GBP / hora
(196 comentarios)
7.6
arcdevsol

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!

£112 GBP / hora
(153 comentarios)
7.8
StdioRelations

======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 Más

£106 GBP / hora
(137 comentarios)
7.3
mmadi

Dear Client, Greetings from Flowgica technologies, I have experience with these skills. We do have similar experience doing something similar to yours therefore I am looking forward to discuss and move ahead. please ch Más

£160 GBP / hora
(50 comentarios)
7.1
mike199

My name is Mike and I’m from UK. I work with individual clients and also provide outsourcing services for a number of UK and USA based agencies. Your project description sounds interesting to me and I do have skills & Más

£112 GBP / hora
(48 comentarios)
6.9
gkalish

Having 10 + years experience in MS SQL Server and willign to start the work immediately .

£112 GBP / hora
(264 comentarios)
6.8
webarox

Hello, Greetings of the day!!! I am well expert WordPress, PHP and MySQL, JavaScript and J Query Developer.I have very good experience. I will Correct the Code as per your requirements. So Please Come Online Más

£42 GBP / hora
(65 comentarios)
5.9
cobol1962

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] sm Más

£33 GBP / hora
(47 comentarios)
5.7
vahidtavana

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 Más

£10 GBP / hora
(14 comentarios)
5.8
jagdishbhatt38

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.

£27 GBP / hora
(42 comentarios)
5.5
nileshbakotiya

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 Más

£15 GBP / hora
(49 comentarios)
5.3
mansibhalodi

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 Más

£111 GBP / hora
(11 comentarios)
5.1
narendragautam

Hi, Please send me screenshots of error and application running instance images AS description not enough to understand about the issue. thanks Narendra ///////////////////////////////////////////////////////// Más

£100 GBP / hora
(14 comentarios)
5.2
yubor

hi, i am certified ms sql server expert (mcse: data platform). would be glad to help you with this project. regards, yuri

£16 GBP / hora
(36 comentarios)
4.5
Gmcconsulting1

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 Más

£55 GBP / hora
(6 comentarios)
4.0