/* Delimiter changed to ; */
/* Writing to session log file now: C:\Users\Justin Shea\AppData\Roaming\HeidiSQL\Sessionlogs\000002.log */
/* Connecting to ad-fl.cfrclw3gxpkn.us-east-1.rds.amazonaws.com via Microsoft SQL Server (TCP/IP), username adfl, using password: Yes ... */
SELECT @@SPID;
/* Connected. Thread-ID: 78 */
SELECT DATEDIFF(SECOND, "login_time", CURRENT_TIMESTAMP) FROM "master"."dbo"."sysprocesses" WHERE "spid"=1;
SELECT @@VERSION;
USE "ad_live";
/* Entering session "AD Live" */
SELECT *, SCHEMA_NAME("schema_id") AS 'schema' FROM "ad_live"."sys"."objects" WHERE "type" IN ('P', 'U', 'V', 'TR', 'FN');
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='dbo' AND TABLE_NAME='advertisment_adInterstitial';
SELECT C.CONSTRAINT_NAME, C.CONSTRAINT_TYPE, K.COLUMN_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS C INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS K ON C.CONSTRAINT_NAME = K.CONSTRAINT_NAME AND K.TABLE_NAME='advertisment_adInterstitial' AND K.TABLE_SCHEMA='dbo' WHERE C.CONSTRAINT_TYPE IN ('PRIMARY KEY', 'UNIQUE') ORDER BY K.ORDINAL_POSITION;
SELECT '' AS "Collation", '' AS "Charset", 0 AS "Id", '' AS "Default", '' AS "Compiled", 1 AS "Sortlen";
SELECT TOP 1000 * FROM "ad_live"."dbo"."advertisment_adInterstitial";
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='dbo' AND TABLE_NAME='advertisment_adInterstitial';
SELECT C.CONSTRAINT_NAME, C.CONSTRAINT_TYPE, K.COLUMN_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS C INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS K ON C.CONSTRAINT_NAME = K.CONSTRAINT_NAME AND K.TABLE_NAME='advertisment_adInterstitial' AND K.TABLE_SCHEMA='dbo' WHERE C.CONSTRAINT_TYPE IN ('PRIMARY KEY', 'UNIQUE') ORDER BY K.ORDINAL_POSITION;
UPDATE TOP(1) "ad_live"."dbo"."advertisment_adInterstitial" SET "script"='test' WHERE "id"=1 AND "script"='
' AND "image"='no_image.jpg' AND "link" IS NULL AND "status" IS NULL AND "create_date"='15/07/2009 08:43:56' AND "script_bottom" IS NULL;
/* SQL Error (3621): The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
The statement has been terminated. */
UPDATE TOP(1) "ad_live"."dbo"."advertisment_adInterstitial" SET "script"='test' WHERE "id"=1 AND "script"='
' AND "image"='no_image.jpg' AND "link" IS NULL AND "status" IS NULL AND "create_date"='15/07/2009 08:43:56' AND "script_bottom" IS NULL;
/* SQL Error (3621): The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
The statement has been terminated. */