Jump to content
Sign in to follow this  
sunny

help in writing queries for sql server

Recommended Posts

sunny

Hi Friends,

I started the database connection and database operations for MS SQL Server

Can you help me on how to connect to SQL Server with auto it and how to retrive the data from the table with the queries?

It would be great if i can get an example on how to write queries with autoit

Share this post


Link to post
Share on other sites
Mat

?? have you actually tried the helpfile? it didn't take you long...

_SQLite_Query

_SQLite_FetchData

good luck with your researching!

MDiesel

Share this post


Link to post
Share on other sites
ericksoncl23

mdiesel That doesnt work for connecting to a database. It just makes a temp database in memory.


meh

Share this post


Link to post
Share on other sites
sunny

mdiesel That doesnt work for connecting to a database. It just makes a temp database in memory.

Yes,

Its jst creates a database in memory rather connecting to the existing database.

PLS HELP friends

Share this post


Link to post
Share on other sites
WideBoyDixon

I guess you'll need to find a COM object that lets you connect to SQL Server. Have you tried ActiveX Data Objects (ADO)?

WBD

Share this post


Link to post
Share on other sites
ChrisL

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×