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: I find myself very confused regarding database tools and a matter of what does what and what is capable of what. For a personal endeavor of mine, i wi...
Summary: I am proficient in most software but have very limited experience with Access. My question is this. Say I have a table for several months containing d...
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: Hi, I have a quick question regarding unions in SQL 2005 (using express edition for development at the moment). I am setting up somewhat of a stock ma...
Summary: Hey all. I have a quick question on my sql, im a bit new to the the commands ect and havin a bit of bother tryin to figure out how to do the following...
Summary: OK, here's my question. I have a unbound field on a form called fldSubcontractor. This auto-fills based on fldEquipmentID. This works fine - here is m...
Summary: I'm not even going to ask why you felt the need to create your own method of naming table columns, when SQL Server already provides a way of doing so ...
Summary: Hello all, My apologies if this has been answered previously, but I could not find anything specific enough to answer my question. I dare say it will ...
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: hi all, have a sql question. i have a table which has a column varchar2(10) which holds employee numbers e.g 'X1234'. I need to update these and...
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 am interested in learning Microsoft SQL, and possible take a low level cert. I would like to start off as inexpensive as possible, so this we...
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: i am a non-professional user of MS Access for the last 8 years and through playing, eperimenting and searching i can say that have become pretty good ...
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 ...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
