PRB: ?? ????? CONCAT_NULL_YIELDS_NULL SET ????? ??????? ?????

?????? ????????? ?????? ?????????
???? ???????: 294942 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

???????

?? ???? ????? ???? ????? ??? ????? SET CONCAT_NULL_YIELDS_NULL ??????? ????? ??????? ?????? CONCAT_NULL_YIELDS_NULL ??? recompiled ??????? ?? ??? ??? ???? ????? ???. ?? ???? ??? ??? ????? ??????.

?????

????? recompilation ???? ????? ??????? CONCAT_NULL_YIELDS_NULL ????? ?? ?? "???????" ? "????? ????? ???????. ?? SQL Server 7.0 ? SQL Server 2000 ? ??? ????? CONCAT_NULL_YIELDS_NULL ON ???? ??????? ?? ?????? ANSI.

????? CONCAT_NULL_YIELDS_NULL ??? ????? ?? ????? ???????? ????? ?? ?????? ??????? ???????? ???? ODBC ? OLE DB ????? ??? ??????? ??? ON ??? ???????. (??? ??? ????? ?????? ?? ???? ?? ???? ????? ???? ????? ??????? SQL ?? ????? ?? ??? ????? ??? ???????.)

???? ??????

?? ??? ?????? CONCAT_NULL_YIELDS_NULL ?? ???? ??????? ??????. ???? ???????? ??????? ISNULL ??? ??? ?????.

??? ???? ??????? ??????? ??? ??????? ??? ???:
SELECT * FROM mytable WHERE name LIKE 'Xavier ' + ISNULL(@lastname,'') + '%'
				
????? ?? ??? ???:
SELECT * FROM mytable WHERE name LIKE 'Xavier ' + @lastname + '%'
				
????? ??? ?????? ?? ???? ????? ?????? ????? SET CONCAT_NULL_YIELDS_NULL ??? ????? ??????? ??????.

??????? ????

????? ??? ??????? ??? ???????? ?????? ???? ??? ????? ???? ????????? ??????? ?? recompiled; ?????? ??? ??????? ??????? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
243586INF: ????? ????? Recompilation ??????? ?????

???????

???? ???????: 294942 - ????? ??? ??????: 20/?????/1424 - ??????: 3.2
????? ???
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
????? ??????: 
kbmt kbprb KB294942 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????294942

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com