473,326 Members | 2,133 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

How to add value to store procedure below

Expand|Select|Wrap|Line Numbers
  1. CREATE PROCEDURE NEW
  2. AS
  3. BEGIN
  4. CREATE TABLE Products (ProductID INT, 
  5. CategoryID INT,
  6. [Product Name] VARCHAR(30),
  7. Price SMALLMONEY,
  8. [Quantity In Stock] INT
  9. PRIMARY KEY (ProductID)
  10. )
  11. END
Jun 18 '15 #1
1 1541
Rabbit
12,516 Expert Mod 8TB
Please use code tags when posting code or formatted data.

I don't know what you're asking. You haven't described this value you want to add.
Jun 18 '15 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Hugo Lefevre | last post by:
Dear, I have a problem : I have a database which contains my data of hardware. The Id is a varchar and I want at my filling form that my user know which is the last one. So I made a store...
4
by: Iwan Petrow | last post by:
Hi, I have a store procedure like this: CREATE PROCEDURE AAA @p1 int @p2 datetime @id int OUTPUT AS
6
by: c676228 | last post by:
Hi everyone, I wrote a store procedure that fetch one row data in the database based on the parameter value I entered. After I created the store procedure, the store procedure code looks like...
11
by: c676228 | last post by:
Hi everyone, I am just wodering in asp program, if there is anybody writing store procedure for inserting data into database since there are so many parameters need to be passed into store...
2
by: c81 | last post by:
Hello, can i make to read in my dotnet application "RETURN @MaVar" of my store procedure ? thx
0
by: seep | last post by:
salam to everyone.. as a new bee in .net i m finding lot of difficulty. i want to get all records of a table from database via store procedure.but spending many days i dont know how can i do...
1
by: inadsad | last post by:
Dear Group, I have a store procedure with 12 input parameter and 2 output parameters I'm wondering what's the best way to simplify the following routine. I'd like to eliminate extra line of...
2
by: MATTXtwo | last post by:
can i do like this Return (4),@fieldname an how to asign value @fieldname with the value of fieldname that use select from table?
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.