Comments
Sort by recent activity
Yes, got it.
However, you can call sp_executesql with param names: EXECUTE sys.sp_executesql @stmt = N'SELECT * FROM dbo.Countries WHERE CountryName = @p0;'
, @params = N'@p0 VARCHAR(100)'
, @p0 = 'USA';
at least, starting from 2008: [image] / comments
Yes, got it.
However, you can call sp_executesql with param names:EXECUTE sys.sp_executesql @stmt = N'SELECT * FROM dbo.Countries WHERE CountryName = @p0;'
, @params = N'@p0 VARCHAR(100)'
, @p0...
hay @buinauskas,
I guess you're speaking about SQL Prompt 9 Rules. You can uncheck the following rule in order to avoid the "issue". It's up to you to manage what rules you'd like to consider. It's not a bug "to be fixed" IMHO. [image] / comments
hay @buinauskas,
I guess you're speaking about SQL Prompt 9 Rules. You can uncheck the following rule in order to avoid the "issue". It's up to you to manage what rules you'd like to consider. It's...
hey @davidsumlin
in order to move the AND right under the WHERE statement you've to set the "Alignment" property, under Operators, to "To Statement": [image] / comments
hey @davidsumlin
in order to move the AND right under the WHERE statement you've to set the "Alignment" property, under Operators, to "To Statement":
hey @davidsumlin
in order to align the table to the field list you have to set the "Align items to the tabs stops", under Lists, to true: [image] / comments
hey @davidsumlin
in order to align the table to the field list you have to set the "Align items to the tabs stops", under Lists, to true:
Hi @francesco_milano (ciao :-) )
could you explain the behavior you would like to get? / comments
Hi @francesco_milano (ciao :-) )
could you explain the behavior you would like to get?
I don't know whether the windows build is different or not. I'm sorry. / comments
I don't know whether the windows build is different or not. I'm sorry.
Hi @AJMartin901,
did you try with right clicking the installer and choose "Run as administrator"? It sounds simple, but it seems also a "missing high privileges" trouble. / comments
Hi @AJMartin901,
did you try with right clicking the installer and choose "Run as administrator"? It sounds simple, but it seems also a "missing high privileges" trouble.
Did you try to remove also the folders in the AppData folder as I said in the first reply? / comments
Did you try to remove also the folders in the AppData folder as I said in the first reply?
AppData is the %LOCALAPPDATA% path of Windows. The complete path is which is `C:\Users\<your_user>\AppData\Local\Red Gate` / comments
AppData is the %LOCALAPPDATA% path of Windows. The complete path is which is `C:\Users\<your_user>\AppData\Local\Red Gate`
Hi @OhNoooo,
after the uninstall processes ends (please try to remove everything), try to delete the Program Files (or x86) and AppData/Local/RedGate folder too. It's not straightforward, but without all the information in those folder, you have more chance to get it.
If this does not work, try to reinstall SSMS also.
Let us know
cheers / comments
Hi @OhNoooo,
after the uninstall processes ends (please try to remove everything), try to delete the Program Files (or x86) and AppData/Local/RedGate folder too. It's not straightforward, but witho...