Count Number Of Spaces in a String
Hello readers.
Below is a simple query to count number of spaces from a
string.
DECLARE @string VARCHAR(200) = 'hello how are you'
SELECT (LEN(@string)
- LEN(REPLACE(@string, ' ', ''))) Occurence
Get Query String Values With Javascript
JavaScript Code To Retrieve Query String Values This topic shows you how you can retrieve the query string values from a URL using JavaScript. The code is simple and understandable. Below is the complete code. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>Query String using Javascript</title> <script type="text/javascript" language="javascript"> function getquerystring() { var qsarr = new Array(); var qs = location.search.substring(1); var singleqs = new Array(); var str =""; qsarr = qs.split('&'); for( i=0; i<qsarr.length; i++) { singleqs = qsarr[i].split('='); str += 'Query String Name
Comments
Post a Comment