Comments
Sort by recent activity
No, the vendor table is in the dbo schema. My trouble is I type "Select * from sys." and I get "Select * from SYS as s." - Prompt is assuming I want the table SYS and is going ahead with its alias. / comments
No, the vendor table is in the dbo schema. My trouble is I type "Select * from sys." and I get "Select * from SYS as s." - Prompt is assuming I want the table SYS and is going ahead with its alias.
Apparently I was doing something wrong--when I went ahead and generated the update script and ran it, the subsequent compare worked and no longer showed differences. Sorry for the confusion. / comments
Apparently I was doing something wrong--when I went ahead and generated the update script and ran it, the subsequent compare worked and no longer showed differences. Sorry for the confusion.
Wow. I had used alt-select to execute something commented out before, but I had no idea it could be used like that. That's a pretty amazing workaround! Thanks!
Also, while you are looking at this, is there a way to separate the way SQL Prompt reformats comma lists such that IN and NOT IN lists could be treated differently than the list of fields in the SELECT list? I really like having each field on its own line in the SELECT, but there are times I want IN() and NOT IN () lists to stay on one line, or word-wrap normally. / comments
Wow. I had used alt-select to execute something commented out before, but I had no idea it could be used like that. That's a pretty amazing workaround! Thanks!
Also, while you are looking at thi...
I have voted it up and looked at some others in there. I guess I was unaware of this UserVoice prioritization system.
When you say you'll be asking--how / where will the asking take place? Over email? In the forums? I'll be glad to help where possible... / comments
I have voted it up and looked at some others in there. I guess I was unaware of this UserVoice prioritization system.
When you say you'll be asking--how / where will the asking take place? Over e...