var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Use of Stored Procedures as opposed to views.
I am converting a database from MS-Sql to My-SQL. (My application is an ASP website)
The MS-SQL database currently makes extensive use of views.
From what I understand, My-SQL currently doesn't support views. This obviously makes my conversion process very difficult.
Someone suggested to me that I should investigate using Stored Procedures as opposed to views.
a) Does MySQL support Stored Procedures ?
b) Would it be possible to use Stored Procedures instead of Views ?
c) If positive, would it mean major code changes to my ASP site to accomodate this ?
Thanks for the help!
A) Not yet
B) Not yet
You should remember: a view is actually a predefined, stores SQL-query and whenever you make a new query against a view, the DBMS first merges these two queries. Now MySQL does't support this feature, so you had to by hand. It's a big job, but can be done.