Wednesday, August 1, 2012

How to embed blogger video audio player all in one plugin for mp3, mp4,mov,.3gp,swf

Lets Rock coding 

<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<script src="http://player.longtailvideo.com/jwplayer.js" type="text/javascript">
</script><br />
<br />
<div id="mediaplayer1">
</div>
<script type="text/javascript">
  jwplayer('mediaplayer1').setup({
    'flashplayer': 'http://player.longtailvideo.com/player.swf',
    
    'width': '480',
    'height': '270',
    'file': 'http://content.longtailvideo.com/videos/8.flv',
    'image': 'http://content.longtailvideo.com/images/8.jpg',
    'plugins': {
       'viral-2': {
           'onpause': 'false',
           'callout': 'none'
       }
    }
  });
</script>

</div>

Sunday, July 8, 2012

How to use substring and len function in sql server 2005 or 2008

I am giving one example from that you will understand How to use Substring and Len Funcation.
Suppose I have one table employee with 1000 of Record. and Having one Column Name is stImage.
This column contain link of Image. stImage contain data like http://www.example.com/images/sqlserversubstring.jpg now I want to change only domain name only replace with http://aspdotnet-example.com/images/sqlserversubstring.jpg for that we will do
update employee set stImage= 'http://aspdotnet-example.com'+
SUBSTRING(stImage,len('http://www.example.com'),len(stImage))
from employee

Tuesday, June 19, 2012

How to Set Identity in Sql Server 2005 or 2008 ?

You have Sql Table Which Having for Example 20 Records. And Identity also 20. Now you want insert new Record with Identity 100 then you pass 99 in below function as Parameter and Table Name and Reseed .
DBCC CHECKIDENT (TableName, reseed, 99)
ASPdotNET-Example