Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bobba Buoy
Starting Member
36 Posts |
 Posted - 2003-07-25 : 09:36:22
|
| I don't know if that is the correct term or not but here is what I want to do:I have a table in a sql server db that has generic field names (form1, form2, etc). I want the users to be able to define specific names for each field unique to them. Then when the 'table' is displayed to them(via a web page and asp/ado), I want them to see 'their' names for each field rather than the generic ones. Any ideas? Thanks!! |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-07-25 : 09:47:39
|
| You can use views to achieve this, however creating the views may initially prove tedious and require dynamic sql.-------Moo. :) |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-25 : 10:04:04
|
quote:
I have a table in a sql server db that has generic field names (form1, form2, etc). I want the users to be able to define specific names for each field unique to them. Then when the 'table' is displayed to them(via a web page and asp/ado), I want them to see 'their' names for each field rather than the generic ones.
Amazingquote:
Any ideas?
Yeah, don'tSo this means you pop up a form...I enter birthdate into column 1, so when I come back, I see birthdate...You however go in, and enter Phone numberNow you table, in column can be populated with birthdate, phone, sex, color of the sky, hockey team name, yada, yada, yadaAre you ever thinking about data mining?Not with that you're not... Brett8-) |
|
|
|
|
|
|
|
|
Field Aliases