Activity overview
Latest activity by Bamajohn
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.
Table named SYS vs sys.
How can I tell SQL Prompt to ignore a table named SYS in our vendor-provided database and instead prefer the "sys." that prefixes "server_principals" and "database_principals" and all those items? ...
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.
Ignoring Identity property on column
I have a scenario where there is a remote server and a local server, both of which have staging tables for an ongoing invoice, policy, insured, etc., data import from one system into another. The ...
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...
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...
List of string literals for IN or NOT IN
There are times when I've cut and pasted a group of numbers or values from a user's email or from a spreadsheet. Typically these are the "natural" key values in our system, usually either QuoteID ...
Searching for *=
I have discovered a bug in SQL Search 1.0.1.2. I have read similar threads and tried forcing a reindex, then I found and deleted all the cached index files from %userprofile%\appdata\local\Red Gat...