New Post has been published on Varinder Sandhu 's Blog
New Post has been published on http://www.varindersandhu.in/2011/06/27/tsequal-and-join-syntax-not-supported-in-sql-server-2008/
TSEQUAL and JOIN syntax as *= or =* not supported in SQL Server 2008
I have faced an issue during SQL Server Migration. Here sharing with you.
<!-- google_ad_client = "pub-2404605494811633"; google_alternate_color = "FFFFFF"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "FFFFFF"; google_color_link = "0000FF"; google_color_bg = "FFFFFF"; google_color_text = "000000"; google_color_url = "008000"; google_ui_features = "rc:6"; //-->
As I need to move some databases from SQL Server 2000 to SQL Server 2008 then I faced a problem because TSEQUAL and JOIN syntax such as *= or =* not supported in SQL Server 2008.
Some of scripts are using the function and syntax as
Example:
TSEQUAL (TxnStatus, @ciTxnSts)
JOIN syntax which has *= and =* to specify the OUTER JOIN.
Solution:
TxnStatus = @ciTxnSts instead of TSEQUAL (TxnStatus, @ciTxnSts)
Outer Join = instead of *= and =*
If anybody has any other idea please share as comment.









