I am writing a C# application that will update the fields in a SQL Server database. The current algorithm I am testing simply pulls the data from a "State" field, stores each value in an ArrayList, capitalizes it, and then writes it back to the database. I am having a problem with logic. I pull all of the values into the ArrayList and c...
How do you detect the current SCAN state and revert it after changing it? An exerpt from the script in question: SET SCAN OFF SET ECHO ON SET SQLBLANKLINES ON SET SCAN ON UPDATE TABLE_NAME SET CREATED_BY = &&created_by; SET SCAN OFF The problem is that if the script doesn't have the first line (SET SCAN OFF), then the code to prompt...
I've got an existing report with quite a few fields on it. I have just modified my database changing a varchar(10) to a varchar(20) When I test it out with data '12345678901234567890' the query against my view works perfectly fine. However, even after I've completed a "Verify Database" it doesn't display the whole value. I have attemp...
Hi guys! Does anybody know how to do smart database update in realtime. E.g. I have a site with a great database. Suddenly I've made some code changes and database structure and data changes. Is there any standard plan to do it with deploy script or any deploy soft? In realtime without stopping the site? E.g. switch between two clone...