 | |
#1
 
| |||
| |||
|
Benefits of views ? -
09-06-2008
, 03:39 AM
#2
| |||
| |||
|
|
Hi, Except for security concerns, are there any other pros of using views in ASE ? Thank you very much |
you can create view with the selected column and bcp out the data.One
other benefit is if you are adding column to the table but want your
apps not to recognize that column(useful when you need to add non
null columns which requires "select into" option turned on so you
wouldnt prefer that during business hours therefore you add columns
into table during your maint window but actually deploy apps code and
procs reffering the the newly added columns during weekdays business
hrs - scenarios
-HTH
Mainsh Negandhi
[TeamSybase]
#3
| |||
| |||
|
|
Hi, Except for security concerns, are there any other pros of using views in ASE ? Thank you very much |
you can create view with the selected column and bcp out the data.One
other benefit is if you are adding column to the table but want your
apps not to recognize that column(useful when you need to add non
null columns which requires "select into" option turned on so you
wouldnt prefer that during business hours therefore you add columns
into table during your maint window but actually deploy apps code and
procs reffering the the newly added columns during weekdays business
hrs - scenarios
-HTH
Mainsh Negandhi
[TeamSybase]
#4
| |||
| |||
|
|
Hi, Except for security concerns, are there any other pros of using views in ASE ? Thank you very much |
you can create view with the selected column and bcp out the data.One
other benefit is if you are adding column to the table but want your
apps not to recognize that column(useful when you need to add non
null columns which requires "select into" option turned on so you
wouldnt prefer that during business hours therefore you add columns
into table during your maint window but actually deploy apps code and
procs reffering the the newly added columns during weekdays business
hrs - scenarios
-HTH
Mainsh Negandhi
[TeamSybase]
#5
| |||
| |||
|
|
Hi, Except for security concerns, are there any other pros of using views in ASE ? Thank you very much |
you can create view with the selected column and bcp out the data.One
other benefit is if you are adding column to the table but want your
apps not to recognize that column(useful when you need to add non
null columns which requires "select into" option turned on so you
wouldnt prefer that during business hours therefore you add columns
into table during your maint window but actually deploy apps code and
procs reffering the the newly added columns during weekdays business
hrs - scenarios
-HTH
Mainsh Negandhi
[TeamSybase]
#6
| |||
| |||
|
|
Hi, Except for security concerns, are there any other pros of using views in ASE ? Thank you very much |
you can create view with the selected column and bcp out the data.One
other benefit is if you are adding column to the table but want your
apps not to recognize that column(useful when you need to add non
null columns which requires "select into" option turned on so you
wouldnt prefer that during business hours therefore you add columns
into table during your maint window but actually deploy apps code and
procs reffering the the newly added columns during weekdays business
hrs - scenarios
-HTH
Mainsh Negandhi
[TeamSybase]
#7
| |||
| |||
|
|
Hi, Except for security concerns, are there any other pros of using views in ASE ? Thank you very much |
you can create view with the selected column and bcp out the data.One
other benefit is if you are adding column to the table but want your
apps not to recognize that column(useful when you need to add non
null columns which requires "select into" option turned on so you
wouldnt prefer that during business hours therefore you add columns
into table during your maint window but actually deploy apps code and
procs reffering the the newly added columns during weekdays business
hrs - scenarios
-HTH
Mainsh Negandhi
[TeamSybase]
#8
| |||
| |||
|
|
Hi, Except for security concerns, are there any other pros of using views in ASE ? Thank you very much |
you can create view with the selected column and bcp out the data.One
other benefit is if you are adding column to the table but want your
apps not to recognize that column(useful when you need to add non
null columns which requires "select into" option turned on so you
wouldnt prefer that during business hours therefore you add columns
into table during your maint window but actually deploy apps code and
procs reffering the the newly added columns during weekdays business
hrs - scenarios
-HTH
Mainsh Negandhi
[TeamSybase]
#9
| |||
| |||
|
|
Hi, Except for security concerns, are there any other pros of using views in ASE ? Thank you very much |
you can create view with the selected column and bcp out the data.One
other benefit is if you are adding column to the table but want your
apps not to recognize that column(useful when you need to add non
null columns which requires "select into" option turned on so you
wouldnt prefer that during business hours therefore you add columns
into table during your maint window but actually deploy apps code and
procs reffering the the newly added columns during weekdays business
hrs - scenarios
-HTH
Mainsh Negandhi
[TeamSybase]
#10
| |||
| |||
|
|
Hi, Except for security concerns, are there any other pros of using views in ASE ? Thank you very much |
you can create view with the selected column and bcp out the data.One
other benefit is if you are adding column to the table but want your
apps not to recognize that column(useful when you need to add non
null columns which requires "select into" option turned on so you
wouldnt prefer that during business hours therefore you add columns
into table during your maint window but actually deploy apps code and
procs reffering the the newly added columns during weekdays business
hrs - scenarios
-HTH
Mainsh Negandhi
[TeamSybase]
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.