MS SQL Server New Users - Adding text to a view

Author

Adding text to a view

James_101

2005-11-25, 8:23 pm

Is there any way to add instructional text to a view. My user will open a
view and not understand some of the data in the displayed table.

The only workaround I see is to create a new table with one field:
Instructions. In the table I enter instruction 1 as record 1, instruction 2
as record 2, etc. In my view, I run a SELECT for the instructional table
first, then the SELECT for the data table.

Are there any other options?

Thanks.

Jim

GregO

2005-11-30, 3:23 am

Hi Jim,
No there not a way to add this information to a view. But you can use
extended properties to add extra data to a view object. The issue then
becomes how are you going to show this information to you users?

--
kind regards
Greg O
Need to document your databases. Use the first and still the best AGS SQL
Scribe
http://www.ag-software.com
"James_101" < James101@discussions
.microsoft.com> wrote in message
news:01394D15-801D-4404-922B- E4943DF4FE22@microso
ft.com...
> Is there any way to add instructional text to a view. My user will open a
> view and not understand some of the data in the displayed table.
>
> The only workaround I see is to create a new table with one field:
> Instructions. In the table I enter instruction 1 as record 1, instruction
> 2
> as record 2, etc. In my view, I run a SELECT for the instructional table
> first, then the SELECT for the data table.
>
> Are there any other options?
>
> Thanks.
>
> Jim

James_101

2005-12-04, 8:23 pm

> Hi Jim,
> No there not a way to add this information to a view. But you can use
> extended properties to add extra data to a view object. The issue then
> becomes how are you going to show this information to you users?
>
>
> --
> kind regards
> Greg O

Thanks for the assistance, Greg. I will try to add the needed notes in
headings of the table that's displayed in views.

Jim

Sponsored Links