Watch TV in online instead of cable TV or DTH

 Hi readers, Now a days we are watching TV shows through cable TV or satellite TV such as sun direct DTH,  airtel digital TV,Tata sky etc.I seen a website streamdirect.com which is providing new way to watch our favorite TV channels. Yes thru this site we can watch TV channels in internet only so called (direct tv internet or tv on the internet). Beauty of this trend is no hardware needed. In India 3G technology released show we can access the high speed internet in 3G enabled mobile...

How much water do you need a day?

Water is an important structural component of skin cartilage, tissues and organs. For human beings, every part of the body is dependent on water. Our body comprises about 75% water: the brain has 85%, blood is 90%, muscles are 75%, kidney is 82% and bones are 22% water. The functions of our glands and organs will eventually deteriorate if they are not nourished with good, clean water. The average adult loses about 2.5 litres water daily through perspiration, breathing and elimination. Symptoms...

Stored Procedures Optimization Tips

Use stored procedures instead of heavy-duty queries. This can reduce network traffic, because your client will send to server only stored procedure name (perhaps with some parameters) instead of large heavy-duty queries text. Stored procedures can be used to enhance security and conceal underlying data objects also. For example, you can give the users permission to execute the stored procedure to work with the restricted set of the columns and data. ***** Include the SET NOCOUNT ON...

Striping HTML tags thro User defined Function

Hi all, Here I will give you a interesting user defined function which is strip the HTML tag, means if you give the input as html document then the function return plain text. Here I am using some of the SQL string functions here. See the code below:-   create function Strip_Html( @Input nvarchar(max))returns nvarchar(160)as beginselect @Input=replace(@Input,'\r','')select @Input=replace(@Input,'\n','')select @Input=replace(@Input,'\t','')while(patindex('%<%',@Input)!=0)beginselect...

What is SQL injection?

Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; ...