Geeks With Blogs
Razi Syed Professional Developer SQL Server 2000
How to append to a sql text data type feild
If you want to concatenate (append to end) a string to a field in SQL, there is a very easy and simple update statement for that: Update [tableName] Set [myField] = [myField] + 'whatever' Where [id] = 1 The + operator works fine for strings, as long as the field is varchar or nvarchar data type. If it is text or ntext, you cannot use the + operator to join strings, and you will get the follow sql error: "Invalid operator for data type. Operator equals add, type equals text" Which is pretty annoying. ......

Posted On Friday, April 25, 2008 5:29 PM

SQL 2005 Conversion Utility
Is it just me, or did Microsoft completely screw up the data conversion utility in SQL 2005? I do a lot of conversions from SQL to Access, and the one in SQL 2000 worked perfectly. In 2005, I ALWAYS encounter stupid errors... either in pre-Execute, or prepare for Execute or when it is actually executing... What is the point of having all these useless steps anyway? Also, the converter in 2005 is extremely slow! It frustrates me so much that they threw away such a nice utility that worked perfectly ......

Posted On Thursday, March 27, 2008 4:26 PM

Copyright © razisyed | Powered by: