How can we help you today? How can we help you today?

Copy As IN Clause Duplicates

I swear I remember that the "Copy As IN Clause" option in a grid removed duplicates. However now when I use it, duplicates are included. Is this correct?

SMSS 19.1
SQL Prompt 10.13.16.3650
Dave Pendleton
0

Comments

1 comment

Sort by
  • Ben_P
    Hi Dave,

    Thank you for your post. Copy As In Clause should remove duplicates you're right:



    I am running the same version of SQL Prompt, and it appears to remove the duplicates. 

    If you can try exporting a copy of your SQL Prompt settings (SQL Prompt>Options>Export) and then restore the options to the default. Then save and close SSMS and re-open and try the Copy As In Clause option again. Does this change the behaviour? If not, then you can restore your previous settings by importing the settings file that you previously exported. 
    Ben_P
    0

Add comment

Please sign in to leave a comment.