Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 What is a run in SQL ?

Author  Topic 

dexik
Starting Member

1 Post

Posted - 2012-12-01 : 18:47:01
I am writing a Java assignment where a database is simulated by a hashtable. It says that the database should be made available at the beginning of a run and made unavailing at the end of a run.

The input and return data is like this:
Input: enter sql(prompt) user enters: insert 1234,'toronto', 45, 'main'
database class returns: inserted 1 item for 1234

[next request]
Input: enter sql(prompt) select 4321
Return: id:4321, city: calgary, address: 34 haha street

So my question is how do you understand a run in this context? Is it every sql request or anything between Connect [to database] and Disconnect?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-12-02 : 01:54:01
from your explanation it sounds you need to open connection do inserts and then close it at the end. so connection will be active till end

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -