Summary: Hi people, I have a question about SQL 2005 stored procedures. I have a stored procedure that determins the current price of a stock item and I want t...
Summary: I will first off admit - this is for school. I cannot figure out for the life of me why it won't work. I'm not expecting anyone to give me the answe...
Summary: i have made a stored procedure in which two tables and ID field is provided as input and the result is used to fill a combo in a form .when i execute ...
Summary: dear all, i have made a stored procedure to generate auto id . when iexecute the pro i get folowing error: Incorrect syntax near '0'. at the highlig...
Summary: I think you should stick with SQL express. The .NET System.Data.Sql namespaces work very nicely with it and in general your code will look a bit clea...
Summary: You're just going to have to learn how to use SQL better and fix your queries. If you want good targeted help, you'll need to explain the layout of th...
Summary: Hi All, I'm trying to write a script to generate rows in a table from arrays and sub-arrays. Its all working lovely but i've come up against a problem...
Summary: Hey Everyone, I'm currently trying to setup an online store, my wholesaler provides all their product info via .CSV file. The file from my wholsaler ...
Summary: Hello, I'm wondering if we can do math fraction operations and also store in columns, by keeping it always in fractions format (dividend/divisor) incl...
Summary: Where are the names stored? Do you want the user to enter the data into a field, or into a form based on a query? Life's more painless for the brain...
Summary: In a database, the order in which the rows actually reside in the table should be irrelevant, so most databases don't have an easy way to do what you ...
Summary: OK i first want to apoligze for posting a message a couple of months ago about the same issue. It's just that i have no idea what i am doing but i wan...
Summary: I am tring to get one single cell from a database. The primary key is username. I want to store the single cell in a variable called $charity. The cod...
Summary: i am currently working on my project. its home automation. and im using a free web server to store my data. what i want to know is how to transfer my ...
Summary: When you go to the video rental store near you and want to pick up a movie by the name of "The Omen" I bet you would look at O before T 99.9% of the t...
Summary: Hello! Maybe someone can help me... I want to write procedure containing some queries as SQL query. For example, I have queries "sglstr", "sqlstr1" an...
Summary: Dear Friends, I am learning PL SQL for the first time. In one program I have given the dbms_output.put_line statement. While executing the program i...
Summary: Do you mean the data source drivers (like a db connector or something) or do you mean actual DSNs? System DSNs are just stored in the registry, so it...
Summary: I want to attach my purchase order files (microsoft word 2003 files) to records in my access database. Is it possible to link or better store them in ...
Summary: You mean the database on the laptop doesn't open or the database on the Act "server" (Where the Act database files are?) If you mean you can't access ...