Quality Testing

Quality is delighting customers

1)how to search a data/value in database SQL?

2)how to find a value between a range,query?

3)how we create a stored procedure in sql? how we check it as a db tester,any sql query?

Views: 592

Reply to This

Replies to This Discussion

1.select * from tablename where colunmname="value"

2.select * from tablename where colunmname between value1 and value2

3.create  procedure procedurename (@Param1 datatype, ...@Paramn datatype)

as

begin

//we r using multiple table

end

1>section command 
i.e select * from TABLE_name;

2>SELECT column_name(s)
FROM table_name
WHERE column_name
BETWEEN value1 AND value2

3>CREATE [OR REPLACE] PROCEDURE proc_name [list of parameters] 
IS 
Declaration section 
BEGIN 
Execution section 
EXCEPTION 
Exception section 
END;

EXECUTE [or EXEC] procedure_name;

to search a data select * from <db name> when <field name = data/value>;

1. Select * from TableName where ColumnName Like '%PARTIALVALUE%'

2. Select * from TableName where Date Between '01-01-2000' and '01-01-2010'

You have to iterate the list of tables and for each table you have to iterate each column and perform an exist query against it.

You will need three types of queries due to the data types i.e. string, number and date and time.

When constructing a query or a filter, you need to tell Access what to look for in mainframe modernization To find values in a range of numbers type the expression

RSS

TTWT Magazine


Advertisement

Advertisement

Advertisement

Advertisement

© 2021   Created by Quality Testing.   Powered by

Badges  |  Report an Issue  |  Terms of Service