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 - ????? ??? ??????: 25/???? ?????/1436 - ??????: 3.2
????? ???
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
????? ??????: 
kbnosurvey kbarchive 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