The cast to VarBinary takes more time, Michael. That's the way I used to do it before Peter Larson and Matt Miller showed me this other way.

Heh... even though close...

So THAT's what the helmet does! 😛

Mark (12/29/2008)

---

Does anyone know how to create an addition column in sql.

For example, I have a column called POINTS. This column stores the total points a user has. ...

Sorry, Guenther... I don't use SSIS so I haven't a clue. But my response will bring this back to the front of the class so folks can try to...

dua_anshu (12/29/2008)

---

I have a field/column called A in table XX, initailly we decided to Varchar(50) as datatype for field/column A.

Now we want to change the datatype of A...

Ok... I thought that things like DTS and SSIS were supposed to make things simple for people to do things in a database... I'm seeing more and more posts like...

ChrisM (above) pointed you to an article...

Well... do you have the SA privs to drop it or not?

Yes... Bulk Insert with output to an error file and successful inputs to a well defined table. I don't use SSIS but I believe there's a Bulk Insert task...

Ummmm.... why not selectively export it from whatever app is using the .DBF format?

Good form, Adi. 🙂

Only if you've never had to fight for her... 😉

WHY? WHY do you want to drop the IDENTITY attribute? It's served you quite well for a hundred million rows... why are you trying to change horses in...

Uoumph! I once wished I could sing like Burl Ives... BWAA-HAA!!! Now I wish you could! 😛

Merry Christmas and Happy New Year!