How to handle multi language in tsql stored procedure?
Please help me out.
You would need to ask the user what languange they want, and pass that to the procedure, then have a table in the database which has all the text stored in the various languages. You’ll need to query that table using the value they passed in so that the data is returned in the correct language.
Much like the way the sysmessages system table is setup.