Search results for query: *

Inclosing single quote in double quote should do the trick.<br><br>select &quot;O'Connnell&quot;<br><br>result is:<br>O'Connnell<br><br><br>

Make sure that gs_report_needed contains value and that value is a valid datawindow name, also make sure that that datawindow included in exe or pbd and that the library search path is valid.

Hopefully following code might help:<br><br>declare @nvalue char(4),<br> @id char(5),<br> @number int<br><br>--for example its 'T0022'<br>select @id = 'T0022' <br><br>select @nvalue = substring(@id,2,4)<br><br>select @number = convert(int,@nvalue)<br><br>select @number = @number +...

This will let you find all rows that contain duplicate records for certain column(s)<br>(helpfull if you try to build a pk on a table which already contains data).<br><br>select count(*), col1, col2... coln<br>from table_name<br>group by col1, col2... coln<br>having count(*) &gt; 1<br><br>This...

Hi. I read that trace flag 1204 and 1205 are supposed to provide more information about deadlock if one is encountered. So I ran the following commands on cutomer's db server:<br>dbcc traceon(1204)<br>dbcc traceon(1205)<br><br>Next time customer got a deadlock there was no additional information...