SQL, Database Testing

• N

  Multiple SQL statements together?
  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
• 

  Verifying the data stored in Azure SQL Server
  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.
• 

  Testing Oracle named query through local H2 database
  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
• J

  How can I check with a SQL query that a field has a given rounding?
  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))
• P

  How to join 2 tables without duplicates (SQL server)?
  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
• 

  How do you test sql stored procedures?
  sql procedure • • headfirst  

  1
  0
  Votes
  1
  Posts
  3
  Views

  No one has replied