Activity overview
Latest activity by Tawfik_Khalifeh_cme
bug in SQL prompt
Smart Rename not changing join condition
I've recreated a mock below, the column OldField was changed to NewField, but the join condition is not changed causing the script to fail, this code segme...
Jessica R wrote: »
Thanks all!
SQL Search does not search user-defined data types at the moment and I've created a request for this with reference SDI-724.
To confirm though, is SQL Prompt's "Select in Object Browser" option still not working for you with user-defined table types @Tawfik_Khalifeh_cme?
"select in object browser" is working for user defined table types / comments
Jessica R wrote: »
Thanks all!
SQL Search does not search user-defined data types at the moment and I've created a request for this with reference SDI-724.
To confirm though, is SQL Prompt's "S...
Thought it would be better not to open a similar support ticket.
I use this feature quit often and it seemed reliable, up until it failed me once after deploying sql changes to production, there was an INSERT statement using an outdated column name that "find invalid objects" did not detect.
I can send you the problematic stored procedure if that helps, a pseudocode summary below
- insert data from user defined table type into a temp table
- insert data into db table using (insert into .. select .. join ..)
- the column that was invalid but not detected was in the insert column list / comments
Thought it would be better not to open a similar support ticket.
I use this feature quit often and it seemed reliable, up until it failed me once after deploying sql changes to production, there wa...
Same issue here, search and selection don't work for user defined table types, as well as f12 and other quick actions / comments
Same issue here, search and selection don't work for user defined table types, as well as f12 and other quick actions