Activity overview
Latest activity by sqlScott2
Thanks for trying. I will let you know if I see a simular problem in the future.
/ comments
Thanks for trying. I will let you know if I see a simular problem in the future.
I am using a new work computer and I had tried to export my SQL Prompt settings on old computer and import them in on my new computer. Did NOT seem to be working. The instruction for that in the forum seemed conflicting with reality. So I am not sure what the right way to do it is. On new computer I have SQL Prompt 10.13.3.32087 On old computer I have 10.13.1.31417 Maybe i need to get newer version on old computer? / comments
I am using a new work computer and I had tried to export my SQL Prompt settings on old computer and import them in on my new computer. Did NOT seem to be working. The instruction for that in the fo...
That is correct. dbo.table1 got changed to inserted in my example. / comments
That is correct. dbo.table1 got changed to inserted in my example.
Erroneous table reference inserted
possible bug in SQL Prompt 10.13.1.31417 (latest version verified)this code:UPDATE dbo.table1SET CurrentStatusFlag = 'N'FROM insertedWHERE dbo.table1.key1 = inserted.key1 AND dbo.table1.Curren...