Read and write to MS SQL Server

Advanced programming using WinTask scripting language

Read and write to MS SQL Server

Postby srbond on Mon Sep 28, 2015 6:11 pm

Hello, do you have a sample script to connect to MS SQL Server (2012)?

I need one that will execute a Select query and another that will execute Update and/or Insert queries.


Thanks,

Scott
srbond
 
Posts: 3
Joined: Fri Sep 18, 2015 4:00 pm

Re: Read and write to MS SQL Server

Postby TechSupport on Tue Sep 29, 2015 7:30 am

Hello,

We don't have such a sample specifically for SQL Server, perhaps a user will give one in this forum.

You have to set up your ODBC database (help topic : How to Create an ODBC Connection to a Database), and then you need to use DBConnect, DBSelect and DBExecute, there are examples in the help for those 3 functions.

Best regards.
WinTask Tech Support
TechSupport
 
Posts: 805
Joined: Thu Nov 16, 2006 9:58 am


Return to Scripts programming

Who is online

Users browsing this forum: No registered users and 5 guests

cron