Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 String or binary data would be truncated.

Author  Topic 

gorlanda
Starting Member

5 Posts

Posted - 2008-11-23 : 08:22:33
Hello, Im new in sql and i have this problem
Can u help me pls
From DBO...
INSERT INTO Name.dbo.tblname1(Year,ID,Name,Col1,Code,Bank)

without make the column longer.

String or binary data would be truncated.
The statement has been terminated.

TKS

gorlanda
Starting Member

5 Posts

Posted - 2008-11-23 : 08:28:48
i find the problem

substring(col1,0,50)

tks
Go to Top of Page
   

- Advertisement -