Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

How do you test sql stored procedures?

headfirst Junior QA Engineer last edited by

Procedures consist of many SQL statements to access the database. Because of several SQL statements that are consolidated into a stored procedure it is a little hard to understand how to test such a procedure separately or all together?
Reply Quote 0
1 Reply Last reply

1
Posts

3
Views

Suggested Topics

P

How to join 2 tables without duplicates (SQL server)?
SQL, Database Testing • sql • • prowler

3

0
Votes

3
Posts

5
Views

UNION checks for duplicates and only distinct rows will be returned SELECT * FROM table1 UNION SELECT * FROM table2
Testing Oracle named query through local H2 database
SQL, Database Testing • oracle query • • Demir

2

0
Votes

2
Posts

5
Views

It found out that the FIRST_VALUE function appeared in H2 in version 1.4.198, in our project there was version 1.4.195
Verifying the data stored in Azure SQL Server
SQL, Database Testing • azure sql server • • Analeea

2

0
Votes

2
Posts

2
Views

R

To verify that the data has uploaded into Azure, take the following steps: Go to the storage account associated with your disk order. Go to Blob service > Browse blobs. The list of containers is presented. Corresponding to the sub folder that you created under Block Blob and Page Blob 'enter code here' folders, containers with the same name are created in your storage account. If the folder names do not conform to Azure naming conventions, then the data upload to Azure will fail. To verify that the entire data set has loaded, use Microsoft Azure Storage Explorer. Attach the storage account corresponding to the Data Box Disk order and then look at the list of blob containers. Select a container, click …More and then click Folder statistics. In the Activities pane, the statistics for that folder including the number of blobs and the total blob size is displayed. The total blob size in bytes should match the size of the data set.
N

Multiple SQL statements together?
SQL, Database Testing • sql • • Nykeriab

2

0
Votes

2
Posts

3
Views

Z

The where clause is redundant. You can just add all to a single query: select count(column1), count(column2), . . . count(column20) from t
J

How can I check with a SQL query that a field has a given rounding?
SQL, Database Testing • testing sql • • jules

2

0
Votes

2
Posts

2
Views

If we mean a table field, then SELECT column_name, data_type, numeric_precision, numeric_scale FROM information_schema.columns WHERE table_schema = 'database' AND table_name = 'table' AND data_type IN ('decimal','float','double'); If we are talking about a field in a certain data set, then in the general case, no way How using a query you can parse a string and count the characters after the decimal point (LOCATE(SUBSTRING(1.1 FROM 2 FOR 1), field) > 0) * LENGTH(SUBSTRING_INDEX(field, SUBSTRING(1.1 FROM 2 FOR 1), -1)) If you are convinced that tricks with a decimal separator are not expected, then simply do the following: (LOCATE('.', field) > 0) * LENGTH(SUBSTRING_INDEX(field, '.', -1))

How do you test sql stored procedures?

Suggested Topics

How to join 2 tables without duplicates (SQL server)? SQL, Database Testing • sql • • prowler

Testing Oracle named query through local H2 database SQL, Database Testing • oracle query • • Demir

Verifying the data stored in Azure SQL Server SQL, Database Testing • azure sql server • • Analeea

Multiple SQL statements together? SQL, Database Testing • sql • • Nykeriab

How can I check with a SQL query that a field has a given rounding? SQL, Database Testing • testing sql • • jules

How to join 2 tables without duplicates (SQL server)?
SQL, Database Testing • sql • • prowler

Testing Oracle named query through local H2 database
SQL, Database Testing • oracle query • • Demir

Verifying the data stored in Azure SQL Server
SQL, Database Testing • azure sql server • • Analeea

Multiple SQL statements together?
SQL, Database Testing • sql • • Nykeriab

How can I check with a SQL query that a field has a given rounding?
SQL, Database Testing • testing sql • • jules