SQL

Tuesday, November 11, 2014

Extracting Test Cases from Test Plan(including test steps) for those whose test set folder is xxx from Quality center. ----open


Posted by Sreekanth's Projects at 12:59 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Extract data from selected columns from a list of tables. And there seems common columns for b.w table 1 and 2, similar b/w table 2 and 3 ...like this way(common alternate tables) ---Open

-- I could use join

/*select * from table1 join table2 On table1.column_name1 = table2.column_name1*/

This will list down the records(with same data in column_name1) for all columns in table1 and table2

What if you have situation for multiple tables.. 
Posted by Sreekanth's Projects at 12:57 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Home
Subscribe to: Comments (Atom)

About Me

Sreekanth's Projects
View my complete profile

Blog Archive

  • ►  2020 (1)
    • ►  April (1)
  • ▼  2014 (2)
    • ▼  November (2)
      • Extracting Test Cases from Test Plan(including tes...
      • Extract data from selected columns from a list of ...
Simple theme. Powered by Blogger.