Kapalı

Create A stored Procedure in SQL

Using the Northwind database orders table, write a single script that completes the following tasks:

Create a view showing every order that was shipped to Spain. Name the destination column "DestinationSpain". Include code that checks if the view already exists. If it does, it should be dropped and re-created.

Create another view that returns the name of each country and the number of orders shipped to that country. Name the number of orders column "NumOrders.” Include code that checks if the view already exists. If it does, it should be dropped and re-created.

Have the script display all the rows from the first view.

Have the script display all the rows from the second view.

Finally, have the script display the total number of orders shipped to Spain. Name the column "TotalOrdersToSpain".

Using the Query Analyzer, make sure your script has no errors when it's executed. Then save and submit the .sql file.

STEP THREE - Writing a Stored Procedure

Complete the following tasks using the Northwind database table Order details:

[url removed, login to view] a stored procedure named sp_insert_orderDetails that allows you to add a discount to an order. The stored procedure should accept five input parameters: OrderID, ProductID, UnitPrice, Quantity, and DiscountValue.

2. Have the stored procedure display all the orders with a discount, including the ones added by the stored procedure.

After testing the stored procedure and receiving no errors, save the .sql file.

Beceriler: Veri Girişi, Veri İşleme

Daha fazlasını görün: writing checks, writing procedure, named query, create writing, stored, sql script , sql data, sql code, sql c, s parameters, rows, data entry sql, create data, create a, create total, sql created, code create, column already exists, sql create script, named, sql view table, create table using, create order, database created, save table file

İşveren Hakkında:
( 0 değerlendirme ) oak, Iceland

Proje NO: #61960

24 freelancer bu iş için ortalamada 42$ teklif veriyor

givemeahell

hi, i am interested in doing this, i am basically software eng. with 5yrs exp. vb asp java .net so u can trust me, i will deliver the project in time or even b4, with quality u expect. thanks gmh

1 gün içinde 50$ USD
(2 Değerlendirme)
3.3
delphixpart

Hello Dear, Please check PM, Thanks

1 gün içinde 30$ USD
(1 Değerlendirme)
3.2
vshree

Hello Sir Is simple one, I will delivery it with in a day. More info and previous works visit my website xxxxxxxxx Select me, lets start the job. Waiting for response. With Thanks Sandesh M M

in 0 gün içinde30$ USD
(2 Değerlendirme)
2.9
IndoFreelancer

Please check my message in your PM. Thank You.

in 0 gün içinde30$ USD
(2 Değerlendirme)
2.6
vibhub

The solution is ready..lemme know if you want to use it...

in 0 gün içinde30$ USD
(3 Değerlendirme)
2.3
espriy

PLEASE CHECK PM...THANKS IN ADVANCE.

in 0 gün içinde30$ USD
(2 Değerlendirme)
2.2
dominicj

Easy done. Can have it back in a few hours.

in 0 gün içinde50$ USD
(0 Değerlendirme)
0.0
gyanng

see PMB(URGENT)

in 0 gün içinde30$ USD
(0 Değerlendirme)
0.0
errorfree

Hi, I have read your requirments to create views and stored procedures and i m sending you half of your work, all work will be done in 1 hour after you choose my bid.Check your pm thanks adnan

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
survivor

Dear Sir, Im Expert DBA , with 3 years experience in MS SQL please review your PMB for more details Regards George

1 gün içinde 75$ USD
(0 Değerlendirme)
0.0
akempis

Dear Sir/Madam: I believe that my strong technical experience and education will make me a very competitive candidate for this project. The key strengths that I possess for success in this position include but a Daha fazlası

in 0 gün içinde30$ USD
(0 Değerlendirme)
0.0
dotnettechno

We can fulfill your requirement. Contact us if interested.

in 7 gün içinde100$ USD
(0 Değerlendirme)
0.0
radcaesar1

x-streamdatasolutions.cjb.net

in 2 gün içinde35$ USD
(0 Değerlendirme)
0.0
YGEsoft

the task is easy. you can have it within an hour from payment.

in 0 gün içinde30$ USD
(0 Değerlendirme)
0.0
Draven

Please refer to our PM

in 0 gün içinde30$ USD
(0 Değerlendirme)
0.0
bestbuykaran

Sir, We are IFW Creations a website designing & development firm. Search “IFW Creations” on Google to know more about us. We are having a team of 22 IT professionals who are experts on Web specific technologies. We Daha fazlası

in 4 gün içinde90$ USD
(0 Değerlendirme)
0.0
vvbharadwaz

I assure to undertake the project provided by you and complete the same within the specified time. I guarantee to provide you complete satisfaction through dedication to the work given.

in 4 gün içinde75$ USD
(0 Değerlendirme)
0.0
G4Genius

Hi, we can do your job in no time. our bid for this job is $25

in 0 gün içinde30$ USD
(0 Değerlendirme)
0.0
foster123

Please check PMB

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
Kuff82

I have 8 years experience. I can have this done for you quickly.

1 gün içinde 40$ USD
(0 Değerlendirme)
0.0