[Q][Keywords] How i can execute T-SQL query ? In MSSQL connection


#1

Hello community,
I have a problem with using ‘advanted’ queries.

I have working keywords with connect to mssql and mysql databases :smiley:
I can do method who execute ‘basic’ queries like
select * from table1

update bla bla

select
with inner
gropu by having order etc.

but i have problems with query who have transact sql (t-sql)

My eg. query like :

@declare variable 1
@declare var2

sel;ect * from where a = @var2
etc…

i think its driver problem.

this its not work with heidi sql default profile, heidi cant execute tsql.

So what i need to do ??

From katalon dosc example :

package com.database import java.sql.DriverManager import java.sql.ResultSet import java.sql.Statement import com.kms.katalon.core.annotation.Keyword import com.mysql.jdbc.Connectionwhat i need to import and using I need to create new conn executing methots and close connection. Any ideas ? 

#2

Solved : Sql.newInstance(url, “com.microsoft.sqlserver.jdbc.SQLServerDriver”)
and import library is - > import groovy.sql.Sql