0
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.
What else can I help you with?
What does SQL CREATE VIEW achieve?
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.
How do you execute cplusplus program in unix using sql as back end?
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.
Where can SQL tools be found online?
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.
What is embedded sql?
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 in SQL?
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.
Sample college examination program using SQL?
can you please send me a sample program of college examination using sql?thanks...God bless...
How do you use SQL?
You use SQL by issuing commands to an SQL server, either directly by you or by a program you are using.
How do you create a data base?
If your database program uses standard SQL commands, you would use the CREATE DATABASE command.
How to backup sql database?
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.
What does SQL CREATE VIEW achieve?
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.
How do you create a program that can input 100 names using flowchart?
create a program that can input 100 names
How do you create a schema in MySQL?
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.
Good topics of mini project on database using sql?
sql
What are sql commands?
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
I have installed MySql server and SQL Maestro for MySql.If i create a new database in mysql maestroit gives Sql access denied for rootlocalhost passwordno.how do i make a connection bween that.?
connect it using a cable line
How do you execute cplusplus program in unix using sql as back end?
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.
Why do you have to create program?
Because I think is possible to predict the lottery using a computer program
