Posts
Sort by recent activity
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? ...
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 ...
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...