Connecting Tech Pros Worldwide Forums | Help | Site Map

quering

Newbie
 
Join Date: Aug 2007
Posts: 13
#1: Sep 5 '07
Sir ! i want the procedure to query about the table information. with seelected fields..
if possible please narrate an example.

Scott Price's Avatar
Moderator
 
Join Date: Jul 2007
Location: Seattle, WA
Posts: 1,314
#2: Sep 5 '07

re: quering


Quote:

Originally Posted by mailavi

Sir ! i want the procedure to query about the table information. with seelected fields..
if possible please narrate an example.

The general syntax is:
Expand|Select|Wrap|Line Numbers
  1. SELECT [FieldOne], [FieldTwo] FROM [TableOne] WHERE [FieldOne]=[SomeValue]
Regards,
Scott
Reply