Thursday, May 26, 2016

raiseerror

with out a try catch : the code will continue

Thursday, March 10, 2016

Column name or number of supplied values does not match table definition in false if statement

if @@SERVERNAME  = 'vxcvxc'
begin
insert into Tblah values('tyut')
end


will be raised


dealing with apostraphe's in sql variables

set  @p_blah = replace(@p_ blah,char(39),char(39)+char(39))

CONTAINSTABLE and '&'

set  @p_blah = replace(@p_blah,'&','/&')

Monday, March 7, 2016

Chrome f12

to skip code you have to comment it out