Home Forums SQL Server 7,2000 T-SQL How to work with result set from exec in a stored procedure? RE: How to work with result set from exec in a stored procedure?

  • You need all of them.

    If you don't know what the structure is i.e. is notify_level_eventlog an int, smallint, byte it doesn't matter because SQL is intelligent enough to do an implicit cast provided that the data will fit in the datatype chosen for your specific table.

    i.e. an int holding 32767 will fit into a smallint with no complaints, but 32768 won't.