need a bit of help in accomplishing something in tsql. I am collecting sql profiler trace data to get a particular stored procedure execution and basically I am trying to strip out the parameter values from the textdata column Example for the below set of data, i need to stripe out parameter value out
exec test
exec test @aa=10
exec test @aa=10,@bb=10
exec test @aa=10,@bb=10,@cc=100
exec test @aa=10,@bb=1000,@cc=1
so the output table might look like
aa bb cc
10 Null NUll
10 10 NULL
10 10 100
10 1000 1
I am just trying to find out what are the common parameters that are being passed to the sp, so if there is other easy ways of doing it please let me know.
Aucun commentaire:
Enregistrer un commentaire