Author: Kerry Osborne - Usage: This scripts prompts for two. Person.Person P ON P.BusinessEntityID = PD. File name: sqlhints.sql - Purpose: List outline hints for a given cursor. I came across this suggestion on google, but I'm not sure if it's the best thing to do? Or what may have caused the error in the first place?Ĭan anyone please advise what is likely to cause this type of error and the best solution? ALTER DATABASE database_name SET COMPATIBILITY_LEVEL = Īn example of the code I get the error with is this: WITH CustomerAges ASįLOOR (DATEDIFF(DAY, PD.BirthDate, GETDATE()) / 365.25) AS AGE It's happened with several other tables eg Hires, CustomerNumbers, etc. If it is intended as a parameter to a table-valued function, ensure that your database compatibility mode is set to 90. I'm getting frequent errors in code where it saysĬustomerSales is not a recognized table hints option.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |