Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-21 : 08:29:19
|
kim writes "i'm trying to trap the error this query returns:
SELECT ProductsProductID, ProductsProductName, ProductsSKU, KeyTab1.Rank AS Ranking, KeyTab1.*
FROM Products P
INNER JOIN
CONTAINSTABLE(ProductText, PTextProductsText, 'Z' ) AS KeyTab1
ON P.ProductsProductID = KeyTab1.[KEY]
WHERE P.ProductsShowOnWeb = 1
ORDER BY KeyTab1.RANK DESC
searching for Z does not work as it's an ignored word.
i don't have a problem with the query ignoring that word but i need to know how to trap this error in a stored procedure.
this is returning a 7619 error, which isn't even in master..sysmessages!" |
|
|
|
|
|
Full-Text Query