Wiktionary(0.00 / 0 votes)Rate this definition: 1  nose(Noun) The organ of the face used to breathe or smell. 2  nose(Noun) A snout, the nose of an animal. 3  nose(Noun) The tip of an object (e.g. the nose of a fighter plane).
SQL is a set-based, declarative query language, not an imperative language such as C or BASIC. However, there are extensions to Standard SQL which add procedural programming language functionality, such as control-of-flow constructs. Transact-SQL is one of those extensions.
Sql Is A Procedural Language. SQL is designed solely for the purpose of creating and maintaining relational databases. As such, it contains none of the major elements of a procedural language such as loops and only limited conditional elements like CASE structures. This is why most SQL-based implementations also have scripting languages like Oracle's PL/SQL and SQL Server's T-SQL - to provide procedural flexibility.