Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Searching a field

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-03-16 : 09:17:20
Robinhood writes "How can I write a stored procedure on how to search for a certain field that corresponds to a particular record.For example I input any account number and get the details on that account"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-03-16 : 09:19:15
Seems simple

Select columns from yourTable where col=@col

Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -