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?
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.
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))