February 5, 2005 at 10:38 pm
first is when an image or some document is stored in a table column where is it stored,becoz rowsize is only 8020 bytes
how to pass a locking hint in sql queries in sql server 2000
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
February 6, 2005 at 5:55 pm
1) Have a look in BOL for an explanation under "Image data type\text, ntext, and image Data. This will give you an explanation as to how Image & Text fileds are stored. They are not stored the same way as a normal data type is unless you use "tex in row" option.
2) What type of locking hints do you need? Example, SELECT Surname FROM Members WITH (NOLOCK).
If you can give us the query that you wish to apply locking hints, then we can help.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply