Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

query and type returned

Status
Not open for further replies.
sramey00

sramey00

Programmer
Joined
Jun 9, 2004
Messages
149
Location
US
what is the type that is returned when a query takes place?
ie if i query for the max of a column, what is the answer as? (int, numeric, char, vchar)??

hmmm...
 
Sort by date Sort by votes
If we are talking about the MAX Length, as in ...

SELECT MAX(LEN(MyField)) FROM MyTable ...

An Int is returned

Thanks

J. Kusch
 
Upvote 0 Downvote
what about select max(field) from mytable?
is this dependent on what the actual field is set to?

hmmm...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question Question
SQL View not available to Excel Power Query
Replies
1
Views
785
dgillz
dgillz
DougNaf
  • Locked
  • Question Question
SQL 2016 - DB attachment and error 3415
Replies
1
Views
670
fredericofonseca
fredericofonseca
JoPaBC
  • Locked
  • Question Question
Delphi/Borland program and SQL Express 2017
Replies
6
Views
1K
JoPaBC
JoPaBC
JoPaBC
  • Locked
  • Question Question
Schedule and automate backups of SQL Express databases in SQL Server Express
Replies
5
Views
1K
JoPaBC
JoPaBC
tekpr00
  • Locked
  • Question Question
Backups in a multiserver environment while using Central Management Server and Server Groups
Replies
0
Views
427
tekpr00
tekpr00

Part and Inventory Search

Sponsor

Back
Top