I have a large Access file with about 4500 image records in binary form. I am trying to import the column into my SQL database and I am encountering a 'Buffer Size' error at the source telling me that the data in the source column is too large for the specified buffer size.
I haven't been able...
I am looking to manipulate a string through that is used in a stored procedure so that it is inverted (eg abcdef becomes cdbeaf). Is there a SQL string function to tranform the string in this way?
Thanks!
cgj
I am trying to generate a stored procedure, or set of stored procedures, to generate a userid. I am taking an existing employee number in the database, performing a looped alogrythm that generates a new employee #, and updating the record with that number.
The stored procedure works when I set...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.