GitHub

sqlcolattribute-function.md

SQLColAttribute returns descriptor information for a column in a result set. Descriptor information is returned as a character string, a descriptor-dependent value, or an integer value. [Input] The ...
InfoWorld

SQL unleashed: 9 ways to speed up your SQL queries

A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way? But ...
GitHub

Oracle SQL and PL/SQL solution to overwrite a primary or any other unique key column value

Because sometimes we need to overwrite a primary or any other unique key column value. This should not be easy, because there could be a lot of reference to this value from other tables. The F_CASCADE ...
Simon Fraser University

sql-expression

operand is one of the following: constant is a number or a quoted character string (or other special notation) that indicates a fixed value. Constants are also called literals. Constants are described ...
TechRepublic

Inserting specific values into an identity column with SQL

Arthur Fuller explores the value of identity columns and the usefulness of their arbitrary values and discusses ways to use SQL Server 2000's IDENTITY_INSERT setting. Despite your numerous ...