debasisdas

I think the suggestion was keeping the future in sight. Mainly because of data growth in future which you may not be able to produce now (with less data). Do not forget data size is one of the key factor for calculating performance. Usually expression version is used for testing …

Welcome to Daniweb.

You need to read [URL="http://msdn.microsoft.com/en-us/library/aa337562.aspx"]this[/URL] and [URL="http://msdn.microsoft.com/en-us/library/ms173463.aspx"]this[/URL]. Also read [URL="http://blog.sqlauthority.com/2008/12/27/sql-server-add-any-user-to-sysadmin-role-add-users-to-system-roles/"]this[/URL].

Lets see the code that you are working on.

1st one is conventional style SQL. 2nd is as per ANSI SQL.

You simply need to apply the algorithm on the desired data.

What you have so far ?

You need to store the password in the connection string itself. Please find more on [URL="http://connectionstrings.com/access"]connectionstring[/URL].

what exactly you are trying to do ?

Welcome to Daniweb.

Have you tried anything yet ? Kindly post the code that you are working on for any help on the topic from experts. Go through the following for further reference. [URL="http://www.systemwebmail.com/faq/1.3.aspx"]link1[/URL] [URL="http://weblogs.asp.net/scottgu/archive/2005/12/10/432854.aspx"]link2[/URL] and [URL="http://forums.asp.net/t/971802.aspx"]link3[/URL].

I would suggest 3rd way (some changes to method 1).

You need to check for and handle [B]NULL[/B] values in your Stored Procedure.

More information is required to answer your question.

Better maintain separate database (not separate tables) for each client for data security.

Hi John, Welcome to Daniweb, Officially :)

What exactly you are trying to achieve, please elaborate.

It shows the date of the server, check for timezone as well.

You need to look into the availability column. But that column shows status of the car or the driver ?

You need to update after adding each set of values otherwise only the last bunch of values will over write all other previous values.

Welcome to daniweb.

Sorry, we do not do your assignment / home work.

In others words [B]rental[/B] can be created on once customer, movie and game tables are in existence.

It would be better if you re-phrase your question. Please post one question only per thread.

Lets see your query and how you call the same from VB.

Sorry to say, but you have to solve your own assignment.

I consider you are asking about OUT parameter. Please go through this [URL="http://bytes.com/topic/visual-basic/insights/739077-executing-oracle-stored-procedures-both-out-type-parameter"]sample code[/URL]. That code is written for Oracle, but VB part remains same.

Do not expect us to guess and solve your problem. What is the code that you are working on ?

you need to set the password for sys and system users at the time of installation and the scott user account will be initially locked you need tpo log in to system or sys account to unlock the scott user.

Welcome to Daniweb.

ehe he he :D now the gal is in trouble translating non-english english to queen's english.

Hi Shawn, Welcome to Daniweb. Hope you have all the fun while learning.

It does not matter how the code looks or anyone likes it or not [B]CASE[/B] is the solution. And CASE works really faster.

Referring to which column of AREA table.

That is not a practical design. How different is b1R0 from that of b2LI and again from b2L0 ? What about storing these as flags in another column in the table.

No need to store data in HH, MM, SS columns. These can be calculated at run time using the previous solution.

I think USA has a team, but they could not qualify for the event.

Hi jingda, Welcome aboard.

64

Listbox contain time ?

Welcome to Daniweb.

Hi Welcome to Daniweb.

Hi Cathy, Welcome to daniweb. You should not hate cricket, specially when the cricket world cup is going on.

Hi Leroy, Welcome to Daniweb.

no they expect spoon feeding....

How you know which is the last record in the database ? Last record as per what ? In a typical RDBMS environment the last row is not necessarily the last record. Better try to use Order by Desc in the SQL query that you are using on specific column.

On which event you are calling [B]EnableChoice[/B] ?

Before i look into the ER let me know how you are going to use this in your application.

What the question is all about ? Is it database related ?

the following is a sample of range partition. [code] CREATE TABLE test_range ( test_id INT AUTO_INCREMENT PRIMARY KEY, test_date DATE ) ENGINE = MYISAM PARTITION BY RANGE(test_id) ( PARTITION p0 VALUES LESS THAN(10000), PARTITION p1 VALUES LESS THAN(20000), PARTITION p2 VALUES LESS THAN(30000), PARTITION p3 VALUES LESS THAN(40000), PARTITION p4 …