Questions tagged [sql]

Structured Query Language (SQL) is a language for managing data in relational database management systems. This tag is for general SQL programming questions; it is not for Microsoft SQL Server, nor does it refer to specific dialects of SQL on its own.

7 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
1answer
2k views

Conversion failed when converting the varchar value to data type int

I am writing this query in HP ALM 11.52 and facing the error "Conversion failed when converting the varchar value 'userid' to data type int" Query is select * from Testcycl join Audit_Log on ...
2
votes
1answer
64 views

How to test Oracle DB?

I have to test using SQL in Oracle if the data stored in the DB is completely correct or not. For example, make sure we are up to date, no future dates, no invalid characters on varchar columns, etc. ...
1
vote
0answers
54 views

HPQC 9.2 compatibility with Microsoft SQL Server 2005 Service Pack 4

Does Quality centre 9.2 support Microsoft SQL Server 2005 Service Pack 4. Hi Friends, Need your help in understanding compatibility between Quality center 9.2 and Microsoft SQL Server 2005 Service ...
0
votes
0answers
38 views

Unsatisfied link error exception while fetching data from sql

The following code is to fetch otp from SQL to the frontend import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql....
0
votes
0answers
128 views

How can I integrate database validation (queries, updates) in Ruby, Cucumber, Watir project in RubyMine

I have setup a project in RubyMine using Ruby with Cucumber, RSPEC, and Watir for UI automation of feature files. (I also have page objects implemented). In my step_definitions where the actual UI ...
0
votes
1answer
188 views

How do you store test data into nosql document database for quick read?

I am currently migrating our currently test data that is stored in excel files to a database. Because the type of data in the test results are going to grow we decided to go with nosql instead of sql. ...
0
votes
1answer
449 views

Selenium, data driven testing using NUnit and SQL queries.

I am developing a Selenium Test Automation Framework for the purpose of testing multiple websites. I have currently set up the Framework in Visual Studio using C# and implementing the Page Object ...