writing to a data sourceI have a sql insert that works fine.
I need to capture into a data source the IDENTITY of the entry, to be used later in a test.
i need to do this roughly 12 times.
What is the best type of data source to do this?
$[Ident: MSG_ID] = SELECT SCOPE_IDENTITY() Doesn't work.
Can I use more than one data source for each DBtool test?
If not, I suppose I could use a TABLE and use separate columns.
Can someone please provide a simple example,
of how to get
$[Ident: MSG_ID] = SELECT SCOPE_IDENTITY()
@IDENTITY is deprecated.