Thanks, I guess I can figure that out.
I like the anything is possible point of view, so one more thing. Is there a way to make the stored procedure less static? I would like it to try a number of languages specified in a param. Because there are no list or collection param types, I suppose...
Hi Karl, thanks for your input.
What I like about this solution is the different languages having the same ID. It makes switching from one language to another completely transparent.
The table with ID numbers is there so that SQL Server can generate the ids itself. The ids in the second table...
Ok, I think this is a tricky one but who knows...
In an effort to create a multilanguage database, I set up the following.
I have a table with ids, called Items:
id other columns
====================
1 ....
2 ....
3 ....
Now, I have another table with values, called...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.