The MS SQL Standard

    my $sthH = $dbh->prepare("INSERT INTO Disease_types (Adapted_code)
SELECT ('A'+code) FROM Disease_types") or die "Couldn't prepare query:
+ ".$dbh->errstr;
    
    $sthH->execute() or die "Couldn't execute query: ".$sthH->errstr;
[download]

gives....

DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL 
+Server]Str
ing or binary data would be truncated. (SQL-22001)
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been 
+terminated
. (SQL-01000)(DBD: st_execute/SQLExecute err=-1) at Creating_table.pl 
+line 389
.
[download]

I know that I need to read up on SQL .... but when the Microsoft page:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlr
+ef/ts_operator_3qov.asp
[download]

.... tells me this, I just stuck.