how to search a data/value in database SQL?

Replies to This Discussion

Permalink Reply by prabhakaran on May 17, 2012 at 2:48pm

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

• ▶ Reply

Permalink Reply by sreelatha on May 17, 2012 at 2:49pm

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;

• ▶ Reply

Permalink Reply by Sakthy on May 17, 2012 at 3:05pm

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

• ▶ Reply

Permalink Reply by Arif BAba. Shaik on May 17, 2012 at 3:27pm

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

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

• ▶ Reply

Permalink Reply by alijamal on June 23, 2012 at 10:41pm

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.

• ▶ Reply

Permalink Reply by alijamal on June 24, 2012 at 11:11pm

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

• ▶ Reply