|
|
Posted by Erland Sommarskog on 05/22/05 00:08
akej via SQLMonster.com (forum@SQLMonster.com) writes:
> Suppose if i acomplish UPDATING to some table and i need to convert data
> (in my case data that i got from parameters) i can use the CASE statement
> e.g.
>
> UPDATE myTable
> SET col1 = CASE WHEN @param = 'TRUE' THEN 1
> ELSE 0 END,
> ...................................
> ...................................
> ...................................
>
> the col1 of myTable has datatype bit (because the datatype of the column
> different form this that i got in param i need to convert)
>
> Also while i perfom UPDATING with using the CASE statement i can convert
> from any datatype that i want.
>
> Ny question about above but in BULK INSERT ????
I'm sorry, but you have me lost completely. First you talk about
UPDATE, and then you go on with BULK INSERT. You cannot update tables
with BULK INSERT, so I fail to see the connection.
If you have problem with BULK INSERT, please post:
o CREATE TABLE statement for your table.
o Sample data file.
o Any format file you are using.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|