Search results for query: *

A tutorial would be great (everything i found was for Access or MYSQL which caused errors). I have no clue what i am doing. First off, tell me if this will work, or if i'm going at this the wrong way... I have an SQL database with a customers table. Attributes include: username and password. I...

I've been spending the entire day writing sql code, stored procedures, and a pretty big visual basic program so that i could insert typed in user values from vb into rows of a sql table. I could insert rows into other tables, but the table i needed to use would never work. I thought there was a...

Basically I'm just trying to learn how to use Visual Basic and parameters with SQL. I want to learn how to take user inputted text from visual basic and insert those values into a sql database table's row. So I created a very simple scenerio and hopefully someone can help me. I'm using the...

Basically I'm just trying to learn how to use Visual Basic and parameters with SQL. I want to learn how to take user inputted text from visual basic and insert those values into a sql database table's row. So I created a very simple scenerio and hopefully someone can help me. I'm using the...

I need to search for ProductIDs and UnitPrices for products that have not been sold within the past six months. The six months is determined by the date the Stored Procedure is executed. So i guess i would just need to find the current server time, do some type of interval of 6 months, and use...

Lets say you have a stored procedure INSERT a new row into a table. In this very same stored procedure what type of SELECT statement could you use just to display the values in the newly created row and not all the rows in that table? For Example: CREATE PROCEDURE up_Insert_Region AS INSERT...

Im basically designing a VB program that takes user inputs to add a new row to an "Employees" table. My procedure in SQL is giving me trouble though, and i don't know why. CREATE PROCEDURE up_New_Employee @LastName nvarchar(20), @FirstName nvarchar(10), @Title nvarchar(30), @TitleOfCourtesy...

In VB i have ONE drop down combobox that will display employee FirstName's, LastName's, & EmployeeID's from an Employee table. To get all three attributes to fit into one combo box i used "AS EmployeeName" and i had to convert EmployeeID from an INT to NVarchar for it to run. The following...

Hello, I just started sql programming. I have a customers table and an orders table. Basically I want the user to input a date, and from this date i want to list all the customers that have not ordered within the past 2 months of that date. Im unfamiliar with the "NOT IN" subquery, does this...

I need help implementing the "NOT IN" subquery with dates. Are there any good online examples/tutorials? For example: Lets say i had a database of customers and the date of their last order, and i only wanted to list all the customers who have not ordered in the past 2 months.