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])
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
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 Joomla, Os-commerce,vBulletin , Zen cart-Drupal , android and IOS , I can create and deliver the project as per the information.I have skilled, expert programmers I'm very excited to assist you in making your Sites successful – please feel free to contact me directly to discuss this position further. Thanks
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
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.
I would appreciate if you could visit my portfolio for examples and feedback of my past projects and you will have no more doubts about selecting a winner for this project.
I have strong profile on freelancer.
https://www.freelancer.in/u/sismaster.html
Can you please ping me back so that we can have small chat session.
Kind Regards,
Poonam
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 to an opportunity to work with you.
Warm Regards,
Muhammad Alyas
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 the project will be done efficiently. Willing to discuss with you more on this project. Please message us in chat so that we can further proceed with this discussion. Looking forward to hear from you soon.
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 check our freelancer portfolio at https://www.freelancer.com/u/mmadi.html?page=portfolio
I am ready to work with you,kindly waiting for your response.
Thanks & Regards,
Mmadi
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 & experience that are required to complete this project. I can show you some examples of my work. Please contact me to discuss your project.
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 for providing further details.
Could I have an interview Please??
waiting for your reply Soon!!
Best Regards,
Ashwin
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 create.
once you have that fixed they are gone too.
good luck
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 push forward best-practices for development and ensure a high level of attention to detail.
thanks
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 your project. Waiting for your replay.
Thank you
Hi,
Please send me screenshots of error and application running instance images AS description not enough to understand about the issue.
thanks
Narendra
//////////////////////////////////////////////////////////////////////////////////////////////////////
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 needs and wants.
We have already developed many software and websites.
looking forward to hearing from you soon.
Hello,
I am interested in you project. i am a software engineer and I have professional experience with MSQL.
I have found the error in your script. I can sent it now.
Thank you,
Best Regards,
David