Database

create or replace trigger transaction_create_date
  before insert on transaction_table
  for each row

begin

  :new.create_date        :=  sysdate;
  :new.modification_date  :=  :new.create_date;

...

DECLARE @num int, @name nvarchar(50) -- Or whatever size you need
SELECT
    @name = name,
    @num = salary
FROM
    mytable
WHERE
    id = 2

CREATE TABLE test2 () INHERITS (test)

-- Rename the customers table to custs.

EXEC sp_rename 'customers', 'custs'

Without nipples, breasts would be pointless.

IDbConnection connection = new OleDbConnection(str);

IDbConnection connection = new SqlConnection(str);

IDbCommand atrCommand = connection.CreateCommand();

private IDbConnection conn = null;
private Type connType = null;

SqlConnection connection = new SqlConnection(str);

conn = (IDbConnection)connection;

connType = connection.GetType();

if (connType == typeof(SqlConnection))
    SqlConnection sqlConn = (SqlConnection)conn;
else if (...)
{}