NEW to SQL

hi everyone

right now im searching SQL. iwant to study about it. but IM a PLC programmer i dont have background in Database can you help me.
i have a question.

Where can i gprogram SQL what are the software?
Creating database in Access is SQL?

Quote:

Originally Posted by OldSchool

hi everyone

right now im searching SQL. iwant to study about it. but IM a PLC programmer i dont have background in Database can you help me.
i have a question.

Where can i gprogram SQL what are the software?
Creating database in Access is SQL?

Hi. A couple of things.
SQL is a high level database programming language. It will work with several relational database management systems (RDBMS) such as Microsoft SQL Server, Oracle and Access.|||

Quote:

Originally Posted by willakawill

Hi. A couple of things.
SQL is a high level database programming language. It will work with several relational database management systems (RDBMS) such as Microsoft SQL Server, Oracle and Access.

Thanks!

it is just a support not a real stand Alone Program?|||

Quote:

Originally Posted by OldSchool

Thanks!

it is just a support not a real stand Alone Program?

Correct. Access is a stand alone programme. SQL is a language that can be used to define and manipulate data in Access.|||

Quote:

Originally Posted by willakawill

Correct. Access is a stand alone programme. SQL is a language that can be used to define and manipulate data in Access.

thanks!
for example;
i have a table created in MS ACCESS;

Can you site a sample code using ACCESS and SQL?

thanks

New Instance on SQL 2000 SP 4

Hi,
I have a server running SQL Server 2000 SP 4 on Windows Server 2003 SP 1. I
want to install a named instance (this is a development environment). As
far as I know, I will need start the install of the named instance from the
SQL 2000 RTM install file set.
What does this do to my existing SQL 2000 SP 4 instance(s)? Do I need to
re-patch them all to SP4? Will the new instance be RTM or SP4? Does
Microsoft have a SQL 2000 SP 4 install image?
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
The named instance will be RTM. You will need to patch the named instance
to SP4, but you should not need to do anything to the existing instance.
There is not a SQL Server 2000 SP4 install image to my knowledge, such as
there is with operating systems.
K. Brian Kelley, brian underscore kelley at sqlpass dot org
http://www.truthsolutions.com/

> Hi,
> I have a server running SQL Server 2000 SP 4 on Windows Server 2003 SP
> 1. I want to install a named instance (this is a development
> environment). As far as I know, I will need start the install of the
> named instance from the SQL 2000 RTM install file set.
> What does this do to my existing SQL 2000 SP 4 instance(s)? Do I need
> to re-patch them all to SP4? Will the new instance be RTM or SP4?
> Does Microsoft have a SQL 2000 SP 4 install image?
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org

New Instance on SQL 2000 SP 4

Hi,
I have a server running SQL Server 2000 SP 4 on Windows Server 2003 SP 1. I
want to install a named instance (this is a development environment). As
far as I know, I will need start the install of the named instance from the
SQL 2000 RTM install file set.
What does this do to my existing SQL 2000 SP 4 instance(s)? Do I need to
re-patch them all to SP4? Will the new instance be RTM or SP4? Does
Microsoft have a SQL 2000 SP 4 install image?
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.orgThe named instance will be RTM. You will need to patch the named instance
to SP4, but you should not need to do anything to the existing instance.
There is not a SQL Server 2000 SP4 install image to my knowledge, such as
there is with operating systems.
K. Brian Kelley, brian underscore kelley at sqlpass dot org
http://www.truthsolutions.com/

> Hi,
> I have a server running SQL Server 2000 SP 4 on Windows Server 2003 SP
> 1. I want to install a named instance (this is a development
> environment). As far as I know, I will need start the install of the
> named instance from the SQL 2000 RTM install file set.
> What does this do to my existing SQL 2000 SP 4 instance(s)? Do I need
> to re-patch them all to SP4? Will the new instance be RTM or SP4?
> Does Microsoft have a SQL 2000 SP 4 install image?
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org