Search results for query: *

Im going to create a store procedure to update the "datesale" in a table which called salesorders.My assumption is, the system will update the datesale everytime we enter the salesorders.Therefore,we r not need to type in the datesale...Hope someone can help me...thankx alot!

Im going to create a store procedure to update the customer status under customer table.My assumptinos is if the "amount" field of salesorders(this is the different table) over $1000,we will name him as "good" customer in the "type" field,and the default one is...

I need to create a store procedure to update the customers status. And my assumptions is when the customer buy over $1000 we will name as GOOD customer in "TYPE" field in the customer table.can someone help me to solve this problems...thankx...!

Im going to create a delete store procedure to delete a service agreement from a table,but b4 i run this store procedure,am i need to create another update store procedure to check the service agreement? if yes,how?there are only month existance,duration,and purchase date in the service...

I am going to create a delete procedure in my table based on the expiry date of the service agreement.But the point is i got no expiry date in my table,i only have DATE PURCHASE,MOnth Existance,and Year Duration...How can i make three of this verify with the system date?I need it urgent!thankx...

But the point is my table do not hav a field call expiry date.It only have date Purchasedate ,month existance ,and duration only...!i do not nkow how to write the statements...!need for urgent!thankc....

Im going to create a DELETE AND UPDATE store procedure in SQL to delete a service agreement from the table based on the expiry date.can someone teach me how?thankx...

I am going to develop a voice recognition program with Microsoft Speech SDK and Visual Basic.Net.And i am wondering whether i need to have any database or not?thankx...