Load a string into the @x variable, then execute the script. This is handy for finding HTML characters.
/* Convert string to ascii values Loop each character and print it's ascii value */ declare @x nvarchar(100), @i int, @k int,@v int --load this variable set @x = 'AZ az' + char(160) + '01' -- note: 160 is an html non breaking space print @x print '----------------' print '' + char(9) + 'int' + char(9) + 'hex' set @i = 0 while @i < LEN(@x) begin set @i = @i +1 set @v = ascii(substring(@x,@i,1)) print substring(@x,@i,1) + char(9) + convert(varchar,@v) + char(9) + convert(varchar,CONVERT(varbinary,@v),2) end
Creating forms is one of the most basic skills for a web developer. It’s easy to, do but achieving the best user experience takes some work. In this article, Dino Esposito demonstrates how to improve the usability and functionality of web forms.
2018-12-24
2,345 reads
In this tip we look at to create a SQL Server DBCC CHECKDB errors email formatted in an HTML table. This will report any errors for all of your databases on the server.
2018-10-24
2,764 reads
How difficult can it be to produce a simple hierarchical list in JSON, YAML, XML and HTML from a SQL Server table that represents a simple hierarchy within an organisation. Well once you know, it is easy and William Brewer is on a mission to tell you how.
2017-09-28
6,087 reads
HTML Input forms are, by their nature, tiresome for the user of any website. However, with some attention to detail and a dash of JavaScript, it is possible to reduce the drudgery of form-filling to the minimum and minimise mistakes. Dino explains four ways of making things better for the user of your website.
2016-12-09
3,196 reads
Sometimes a request from a user who doesn't appreciate the limitations of the technology can jolt you into discovering that an application feature that was, until recently, difficult to achieve is suddenly relatively easy. Dino was asked to allow the user to take photographs and associate them with an item of work. After he'd recovered from the shock, he decided that it was achievable, and now describes how he went on and did it.
2016-10-06
4,818 reads
