SQL Server Common function for getting max(id)

Question

In my application many I time we use MAX(). How can I write a common function where I can pass table name and column name and get MAX(). I mean single function for any table/field.

Thanks, Tanmay.

Do you want this as a T-SQL sproc, or in some client language? — Marcelo Cantos, Apr 29 '10 at 10:55

score 0 · Answer 1 · edited May 23 '17 at 11:55

0

In MSSQL there are no particularly elegant ways to use UDFs with dynamic table/field names, so personally I would just stick to a simple SELECT MAX().

If the IDs are IDENTITY columns you can just use IDENT_CURRENT('the_table')

edited May 23 '17 at 11:55

Community

1
1

answered Apr 29 '10 at 11:36

Alex K.

171,639
30
264
288

SQL Server Common function for getting max(id)

1 Answers1