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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-02-26 : 07:59:54
|
| Andrew writes "How do you write to a SQL server and read from one? Do I need a certain language to do it in? Preferably Java. Is it similar to Java Input/Output?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-02-26 : 08:07:24
|
| You can't (and wouldn't) write to SQL Server database files directly. Regular Java input/output will not work. Databases are not the same thing as files, even though data is stored in files (this applies to all relational databases, not just SQL Server) You access the database using a query language like SQL (Structured Query Language) which is what 99% of database products use.For a custom application, you would use a data access interface like ODBC or JDBC to access the database. Queries would still need to be submitted in SQL though. You can get JDBC drivers for SQL Server here:http://www.microsoft.com/downloads/details.aspx?FamilyID=9f1874b6-f8e1-4bd6-947c-0fc5bf05bf71&DisplayLang=enBefore you get too involved in developing your application, spend some time in the Transact-SQL section of Books Online (it's installed with SQL Server) Look at the SELECT statement for starters, play around with the examples and get comfortable with the syntax. |
 |
|
|
|
|
|
Reading and Writing