How to read Max value of column in SQL Server

[cshivaprasad]

HI, How should i handle max(particular column) of a table in SQL server. SqldataReader.executeReader() not handles it i suppose. can any one help

[Robert Rohde]

If it is only one value you are fetching than you can use ExecuteScalar on the SqlCommand object. But I think ExecuteReader should also work.

[J4amieC]

SELECT MAX(MyColumn) FROM MyTable You can then use ExecuteScalar() to read the value. Current blacklist svmilky - Extremely rude | FeRtoll - Rude personal emails | ironstrike1 - Rude & Obnoxious behaviour