Today I debugged and captured the following t-sql insert statement
insert into Table1 (col1, col2, col3, ..., colN) values (val1, val2, val3, ..., valN)
I had around 200 columns, and I’d like to check colM and colP’s values. I taught to myself I just cannot count the numbers of columns. It’s so cumbersome that I must find a way to do it automatically. I challenged a DBA / Data guru nearby.
He was so eager and exciting, basically grabbed keyboard from my hand, and quickly showed me how to do it. Basically there is a ‘Data’ tab in excel, we can choose ‘Text to Columns’, and set the delimiter to ‘,’ in this case. In less than 10 seconds, we can see a table like this that we can find any column and value easily.