SQL 2005 , Where condition in Select statement

[Former Member]

Hi All

i am using SQL Server 2005 as a backend for webservices, i want to select the data based on the user input in where condition,

SELECT [NO]
      ,[NAME]
      ,[PAGE_COUNT]
  FROM [DS].[DB].[tablename]
where [NO]=???

Ex: i will pass the NO to the webservice to get the respective data from SQL,but i am not sure what operand to give in where condition,does anybody have idea on this

Thanks and Regards

Chaitanya.A

[Former Member · Accepted solution]

Hi,

Make use of prepared statements

http://java.sun.com/docs/books/tutorial/jdbc/basics/prepared.html

Regards

Ayyapparaj