@TheUnhandledException :D couple of days ago, someone asked me the same Q, I sent him that link ;)
anyhow, I'm preparing a script to export a bunch of tables from my database & re import them
The export script is like this:
DROP TABLE PGITH_INST_RISK_CHRG_DTL_EXP;
CREATE TABLE PGITH_INST_RISK_CHRG_DTL_EXP AS SELECT * FROM PGITH_INST_RISK_CHRG_DTL WHERE PIRCDH_POL_SYS_ID = FN_GET_POL_SYS_ID(&POL_NO);
DROP TABLE PGITH_INST_RISK_CHRG_DTL_EXP;
CREATE TABLE PGITH_INST_RISK_PREM_DTL_EXP AS SELECT * FROM PGITH_INST_RISK_PREM_DTL WHERE PIRPDH_POL_SYS_ID = FN_GET_POL_SYS_ID(&POL_NO);
DROP TABLE PGITH_INST_RISK_CHRG_DTL_EXP;
CREATE TABLE PGITH_POL_INST_CHARGE_EXP AS SELECT * FROM PGITH_POL_INST_CHARGE WHERE PICH_POL_SYS_ID=FN_GET_POL_SYS_ID(&POL_NO);
.. just that there are about 250 lines of the same sort, with different table names
replaced create table with insert into using simple find/replace
now comes the part where I'm stuck
the scripts now look like this
INSERT INTO PGITH_INST_RISK_CHRG_DTL_EXP AS SELECT * FROM PGITH_INST_RISK_CHRG_DTL WHERE PIRCDH_POL_SYS_ID = FN_GET_POL_SYS_ID(&POL_NO);
INSERT INTO PGITH_INST_RISK_PREM_DTL_EXP AS SELECT * FROM PGITH_INST_RISK_PREM_DTL WHERE PIRPDH_POL_SYS_ID = FN_GET_POL_SYS_ID(&POL_NO);
INSERT INTO PGITH_POL_INST_CHARGE_EXP AS SELECT * FROM PGITH_POL_INST_CHARGE WHERE PICH_POL_SYS_ID=FN_GET_POL_SYS_ID(&POL_NO);
now I need to swap the table names between insert into and select
ie,
> INSERT INTO PGITH_INST_RISK_CHRG_DTL_EXP AS SELECT * FROM PGITH_INST_RISK_CHRG_DTL
becomes
> INSERT INTO PGITH_INST_RISK_CHRG_DTL AS SELECT * FROM PGITH_INST_RISK_CHRG_DTL_EXP
Now, off for lunch at Saffron -- Local Indian restaurant, I was about to post their link and realized, wow, Google Chrome says the site has a malware infection! Yikes!
@Sathya Food was pretty good, not as good as it sometimes is there. For example the Chicken tikka masala, they often don't make enough for the whole day, so by the time I got there it was Chicken fakka masala, that is, quickly fried chicken in the masala sauce as opposed to the real thing which they simmer overnight in the sauce :-)
I had chicken keema (if I'm spelling that right) for the first time, and that was delicious. Very salty, but yummy. Extra spicy :-)
Fresh Naan too, this restaurant stays on top of that :-)
They also had pulao which was very yummy, instead of their usual biryani. I don't like their biryani as well
@Sathya let's take a stored procedure for inserting for instance. all actual procedures for inserting a new registry are on the front end, let's say php. if you use the SP, it's all except the actual command to insert into the database. then if you have to modify anything, you have to go to the database to adjust it.
that also goes a long way on big static projects... from times to time, things change. now instead of just the annoyance of going to DB yourself, you have to go through the DBA.
from my point of view I can make a parallel of this and stateless / statefull debates.
but that's not much to do with SPs... procedures are just minor part. I was thinking about regular MS SQL on minor sites, and just recalled it is also bad on big enviroments.
well, as you brought up, it is all about how you use it... but the way things are designed thus directing how to use intuitively ends up building a community knowledge around it. argh, too much philosophy again!
neways, have any of you had a chance to try couchdb in production?
@Sathya in classic ASP it's advised to use parametrized queries to avoid SQL injection... and most info you find on internet is about using it is with SPs.
What is a strong way to protect against sql injection for a classic asp app?
FYI I am using it with an access DB. (I didnt write the app)
