No you can't. SQL is not a programming language, so it doesn't create programs. It is a query language, and it creates queries. There is a difference. There are various things that programming languages have and that they can do, which would take a more detailed explanation to define. SQL is very limited in what it can do, being specifically designed to work with data and manipulate databases. It does not have the capabilities of a programming language. A query and a program are both a list of commands to do a task, but a program is far more extensive and can do far more things, and so it is very different to a query.
SQL CREATE VIEW achieves the creation of a table or tables in the SQL database. One can then create tables to the purpose they desire and fill them in with information.
The program needs to be designed to do that. If it is, then it will either be designed to use a TCP connection (e.g. on port 3306) to the database or a named socket (e.g. mysql.sock). All you'll really need to do is start the database engine, create the necessary databases, grant rights to whatever database user the program calls into the DB as, pre-populate any necessary tables/data the program expects to be there, and then start the program. The program documentation should tell you what you need to provide as far as a mysql environment and give any necessary SQL initialization scripts.
SQL are Database Developers allowing one to produce database tables and values. Ideone is a program that also allows one to change the language as well as the values and program the data into the relevant fields.
Embedded SQL is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL. Embedded SQL statements are SQL statements written inline with the program source code of the host language. The embedded SQL statements are parsed by an embedded SQL preprocessor and replaced by host-language calls to a code library. The output from the preprocessor is then compiled by the host compiler. This allows programmers to embed SQL statements in programs written in any number of languages such as: C/C++, COBOL and Fortran.The ANSI SQL standards committee defined the embedded SQL standard in two steps: a formalism called Module Languagewas defined, then the embedded SQL standard was derived from Module Language.[1] The SQL standard defines embedding of SQL as embedded SQL and the language in which SQL queries are embedded is referred to as the host language. A popular host language is C. The mixed C and embedded SQL is called Pro*C in Oracle and Sybase database management systems. In the PostgreSQL database management system this precompiler is called ECPG. Other embedded SQL precompilers are Pro*Ada, Pro*COBOL, Pro*FORTRAN, Pro*Pascal, and Pro*PL/I.
create view vw_active_employee as select * from employee where status = 'Active' after creating the view, view can be used as a table to see active employee. e.g. select * from vw_active_employee Basically we save sql as a database object, so that we can use that in future as a virtual table.
can you please send me a sample program of college examination using sql?thanks...God bless...
You use SQL by issuing commands to an SQL server, either directly by you or by a program you are using.
If your database program uses standard SQL commands, you would use the CREATE DATABASE command.
Use program way backup and recovery. Tool repair sql database any version starting with MS SQL Server 2000, including SQL 2005.-------------You can backup SQL server database using SQL Server Management Studio (SSMS), T-SQL or PowerShell.Limitation: Backup created using higher version can't be restored in earlier version of SQL server.
SQL CREATE VIEW achieves the creation of a table or tables in the SQL database. One can then create tables to the purpose they desire and fill them in with information.
create a program that can input 100 names
To create a schema (also known as a database), connect to your MySQL server with a program that allows you to send SQL commands. Common software usually includes phpMyAdmin or the MySQL Workbench utilities. In the program, find a method of executing an SQL command to your server. You will then want to issue a CREATE statement, which will create a new schema. It can have a simple or complex syntax depending on your needs; see the related link for a full, official guide on this statement's syntax.
sql
SQL commands are specific structured query language keywords that are used to create, alter, and view data held withing a database. (Ex. SELECT, CREATE, ALTER) For more information about SQL: http://en.wikipedia.org/wiki/SQL
connect it using a cable line
The program needs to be designed to do that. If it is, then it will either be designed to use a TCP connection (e.g. on port 3306) to the database or a named socket (e.g. mysql.sock). All you'll really need to do is start the database engine, create the necessary databases, grant rights to whatever database user the program calls into the DB as, pre-populate any necessary tables/data the program expects to be there, and then start the program. The program documentation should tell you what you need to provide as far as a mysql environment and give any necessary SQL initialization scripts.
Because I think is possible to predict the lottery using a computer program