Hi,
I am executing following query
[INSERT INTO OPENROWSET('MSD ASQL', 'Driver=Postgre SQL Unicode;uid=pos tgres;Server=lo calhost;port=54 32;database=dat a;pwd=XXXX',
'SELECT projectCode,pro jectName,projec tDesc,expectedb enifits,AttachF ileNames,lastup dated,userid
FROM Project WHERE projectCode = ''-1'' ')
SELECT projectCode,pro jectName,projec tDesc,expectedb enifits,AttachF ileNames,lastup dated,userid from Project where projectCode=110 3]
and i am getting following error
Msg 8152, Level 16, State 10
String or binary data would be truncated.
I am executing following query
[INSERT INTO OPENROWSET('MSD ASQL', 'Driver=Postgre SQL Unicode;uid=pos tgres;Server=lo calhost;port=54 32;database=dat a;pwd=XXXX',
'SELECT projectCode,pro jectName,projec tDesc,expectedb enifits,AttachF ileNames,lastup dated,userid
FROM Project WHERE projectCode = ''-1'' ')
SELECT projectCode,pro jectName,projec tDesc,expectedb enifits,AttachF ileNames,lastup dated,userid from Project where projectCode=110 3]
and i am getting following error
Msg 8152, Level 16, State 10
String or binary data would be truncated.
Comment