Sql – Implicit conversion from varchar to Varbinary how to

sqlsql serversql-server-2008

I got the following error trying to convert from a varchar to varbinary..

Implicit conversion from data type
varchar to varbinary(max) is not
allowed. Use the CONVERT function to
run this query.

and this is the alter command that I tried.

alter table foo Alter column bar varBINARY(max)

So how do I use the convert function for something like this? I did a bit of searching via google and had no luck.

Thanks.

Best Answer

You have to rebuild the table.

Use SSMS designer to change the type: this will generate a script with CONVERT.

Related Solutions

Sql – How to return only the Date from a SQL Server DateTime datatype

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, @your_date))

for example

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))

gives me

2008-09-22 00:00:00.000

Pros:

No varchar<->datetime conversions required
No need to think about locale

Sql-server – How to check if a column exists in a SQL Server table

SQL Server 2005 onwards:

IF EXISTS(SELECT 1 FROM sys.columns 
          WHERE Name = N'columnName'
          AND Object_ID = Object_ID(N'schemaName.tableName'))
BEGIN
    -- Column Exists
END

Martin Smith's version is shorter:

IF COL_LENGTH('schemaName.tableName', 'columnName') IS NOT NULL
BEGIN
    -- Column Exists
END

Best Answer

Related Solutions

Sql – How to return only the Date from a SQL Server DateTime datatype

Sql-server – How to check if a column exists in a SQL Server table

Related Topic