mokkan
asked on
Database script and bat/perl script
Hello,
I would like to write a bat or perl script to connect to SQL database table and change one of the field.
Is there way I can do via bat or perl script?
I would like to write a bat or perl script to connect to SQL database table and change one of the field.
Is there way I can do via bat or perl script?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I would like to know via, how to connect to database and update the tabel.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you so much. If I want to execute through window bat file, how do i do that? Just cut and past in bat file and execute?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much. How do I verify if that command is successfull or not in bat?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you guys, one more quick quesiton. Can I uset encrypted passsword?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Mokkan, why the grade B?
ASKER
Update [Database_Table].[dbo].[sc
Can I do it via perl script or bat file? Can you tell me how exactly it would be? I am new to MSSQL server.
First connect to database? And slect the table? And update?