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

winscp new version

i had recursive error with older version

so I got the latest

it kept on coming up with version mismatch

i spent way too much time on this

until I realized that there was nothing to publish the exe to the release folder

and that the exe was alive and I had to kill the process  ;(



Thursday, March 3, 2016

Example of ref on reference type

    class Program
    {
        static public void change(List<string> thing)
        {
            thing[0] += "  adjusted";
            List<string> temp = new List<string>();
            temp.Add("change");
            thing = temp;
        }

        static public void refChange(ref List<string> thing)
        {
            List<string> temp = new List<string>();
            temp.Add("refChange");
            thing = temp;
        }
       
        static void Main(string[] args)
        {
            List<string> temp = new List<string>();
            temp.Add("hody doe");
            change(temp);
            Console.WriteLine(temp[0]);
            refChange(ref temp);
            Console.WriteLine(temp[0]);


        }
    }

what do you think happens with appended spaces in sql

select len('dfdf       ')

select len('       dfdf')

in oracle too!


select * from
(

select 'sdff   ' a  from dual
)  main

where main.a ='sdff'