How to connect SQL Server and select/insert data
Hi,
How can I connect SQL Server Data Base which is on my local PC, and select/store data from/into a table?
It seems that I have to use something like 'sqlQuery' but I couldn't found details about the control and the others.
Could anyone show me the way to do that?
Thank you
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Wells Fargo
IN
Hi,
Go through the below links ,
https://community.pega.com/sites/default/files/help_v73/procomhelpmain.htm
https://community.pega.com/sites/default/files/help_v719/procomhelpmain.htm
Thanks
Power Solutions, Ltd.
JP
Hi,
I could execute insert query by using sqlQuery's CommandText property and Excute method.
I think it's fine but is there any other way like:
- not writing SQLs
- something like visual based
I'd like more easy way, and hope it is...
Thanks,
Pegasystems Inc.
US
Can you clarify if this is a standalone db for experimenting, a Pega instance DB or a database you wish to connect to with Pega?
There are quite a lot of database tools, and many support imports from other tools like spreadsheets, so that can be an option to consider.