If you ever come across a situation wherein you have to quickly modify the list of things in the SQL query...probably either you would have copied that text into excel added some formula to get the desired format. Instead, we can use this little trick in the SQL Query window itself...
Hold ALT and mouse left click...you will notice vertical line '|' each string like below after that we can add the same character before or after the vertical line.
Hope it helps
No comments:
Post a Comment