Ideas for select all columns but one mysql stored procedure
Assume we’ve a table with 100 rows and we need to select all columns but one.The problem is headache of actually typing out all 99 required columns!! In this blog…
No More Spool Space Teradata Query Solution
Have you ever come across a situation called NO MORE SPOOL SPACE? My friend does and hence I studied a bit about Teradata. The error: “NO MORE SPOOL SPACE”. Correct, the problem…
5 useful MySQL Command Options-pager-prompt-rehash-tee-system
There are set of commands that MySQL itself interprets. You may use “help” or “\h” at the mysql> prompt to list them. Below are the 5 most useful MySQL Command…
QA-Testing Definitions-Interview Questions: Part-III
QA-Testing Definitions-Interview Questions: III (T – Z): Race Condition: A cause of concurrency problems. Multiple accesses to a shared resource, at least one of which is a write, with no…
QA-Testing Definitions-Interview Questions: Part-II
QA-Testing Definitions-Interview Questions: II (F – S): Data Dictionary: A database that contains definitions of all data items defined during analysis. Data Flow Diagram: A modeling notation that represents a…
QA-Testing Definitions-Interview Questions: Part-I
QA-Testing Definitions-Interview Questions: I (A – I) Acceptance Testing: Testing conducted to enable a user/customer to determine whether to accept a software product. Normally performed to validate the software meets…