TryParse for Int32, long, byte , and decimal return Boolean Int32.TryParse( s as String, ref i as int32) [VB] Int32.TryParse(String s, out int32 i) [C#] long.TryParse( s as String, ref i as int32) [VB] long.TryParse(String s, out int32 i) [C#] int32.TryParse(s, out i) http://msdn.microsoft.com/zh-tw/library/bb384043.aspx
GO DECLARE @value1 varchar(50) DECLARE @value2 varchar(50) DECLARE my_cursor CURSOR FOR SELECT Value1,value2 FROM TableName OPEN my_cursor FETCH NEXT FROM my_cursor INTO @value1,@value2 WHILE @@FETCH_STATUS = 0 BEGIN print @value1 + ':' + @value2 /*Main Process Start*/ FETCH NEXT FROM my_cursor INTO @value1,@value2 end CLOSE my_cursor DEALLOCATE my_cursor
1.Setting ODBC in windows Control panel 2.install R package "RODBC" 3.In R Command Line > library(RODBC) > channel = odbcConnect("$ODBC_Name") //Create Connection > odbcGetInfo(channel) //Get odbc connection info > odbcQuery(channel,"$SQL_command") //Set SQL Command String > sqlGetResults(channel, max=$TopNumber) //get top N Data
Use the IE filter "AlphaImageLoader" and javascript in Header <style type="text/css"> #newPreview { filter:progid:DXImageTransform.Microsoft.AlphaImageLoader(sizingMethod=scale); } </style> <script type="text/javascript" language="javascript"> <!-- function PreviewImg(imgPath) { //IE6﹜IE7﹝ var newPreview = document.getElementById("newPreview"); newPreview.filters.item("DXImageTransform.Microsoft.AlphaImageLoader").src = imgPath; } --> </script> in body <div id="newPreview" ></div>