harishgola.blogspot.com
Microsoft Technology Related Posts: 06/23/08
http://harishgola.blogspot.com/2008_06_23_archive.html
Microsoft Technology Related Posts. Earn upto Rs. 9,000 pm checking Emails. Join now! Monday, June 23, 2008. Select top n random rows from a table in SQL SERVER. There are many ways that you can use randomly selected rows; they're especially effective when you want to add dynamism to a site. For instance, you could randomly select a product to present as Today's Featured Product, or QA could generate a random call list to gauge customer satisfaction levels. PK uniqueidentifier NOT NULL DEFAULT NewID(),.
harishgola.blogspot.com
Microsoft Technology Related Posts: 07/03/08
http://harishgola.blogspot.com/2008_07_03_archive.html
Microsoft Technology Related Posts. Earn upto Rs. 9,000 pm checking Emails. Join now! Thursday, July 3, 2008. 64-bit OLEDB Provider for ODBC (MSDASQL) Available in Longhorn Server, Starting Beta 3. We’re pleased to announce that Longhorn Server Beta 3 will include a 64-bit version of MSDASQL, Microsoft’s OLEDB Provider for ODBC. Who does this impact? If you are a customer in one of the following scenarios, you will see direct benefits from this technology when upgrading to or deploying Longhorn Server:.
harishgola.blogspot.com
Microsoft Technology Related Posts: Filtered lookup for Dynamics CRM 2013
http://harishgola.blogspot.com/2015/07/filtered-lookup-for-dynamics-crm-2013.html
Microsoft Technology Related Posts. Earn upto Rs. 9,000 pm checking Emails. Join now! Friday, July 17, 2015. Filtered lookup for Dynamics CRM 2013. Filtered lookup is a feature which was introduced in Dynamics CRM 2011, a greatly appreciated improvement from CRM 4. Prior to this, developers had to use third party tools to achieve the same result. So, let’s start at the very beginning. What is filtered lookup? Now, let us write the code to achieve this. 1 addLookupFilter function can only be called from a...
harishgola.blogspot.com
Microsoft Technology Related Posts: 09/01/08
http://harishgola.blogspot.com/2008_09_01_archive.html
Microsoft Technology Related Posts. Earn upto Rs. 9,000 pm checking Emails. Join now! Monday, September 1, 2008. Cross Tab queries , Converting Rows to Columns. While browsing on the net I got a really good article by Jeff Moden on Cross Tab queries , Converting Rows to Columns . Hats off to jeff for this beautiful article. Some part of it that I feel was really very helpful for me I am reproducing it here for my future reference and I recommend you guys to read the complete series here. SELECT 2008, 4, ...
harishgola.blogspot.com
Microsoft Technology Related Posts: 08/03/08
http://harishgola.blogspot.com/2008_08_03_archive.html
Microsoft Technology Related Posts. Earn upto Rs. 9,000 pm checking Emails. Join now! Sunday, August 3, 2008. Check and Uncheck All Checkboxes in a DataList using ASP.NET and C#. Here's the client-side javascript function in the aspx page. Function CheckAll(checkAllBox, fieldName). Var frm = document.Form1;. Var actVar = checkAllBox.checked;. For(i = 0; i. E = frm.elements[i];. If (etype = 'checkbox' & e.name.indexOf(fieldName)! Echecked = actVar ;. Var frm = document.frmAdsKeyword;. For(i = 0; i.
harishgola.blogspot.com
Microsoft Technology Related Posts: 05/15/08
http://harishgola.blogspot.com/2008_05_15_archive.html
Microsoft Technology Related Posts. Earn upto Rs. 9,000 pm checking Emails. Join now! Thursday, May 15, 2008. What is the % Code in My URL? In order to prevent the misinterpretation of special characters such as a space, bracket (. Common URL Escape Characters. Table of URL Escape Characters. Character Escape Character Character Escape Character. Space %20 # %23. Posted by Harish Kumar Gola. Links to this post. SQL string split function. CREATE FUNCTION dbo.Split. Id int identity(1,1), Data nvarchar(100).
harishgola.blogspot.com
Microsoft Technology Related Posts: 08/04/08
http://harishgola.blogspot.com/2008_08_04_archive.html
Microsoft Technology Related Posts. Earn upto Rs. 9,000 pm checking Emails. Join now! Monday, August 4, 2008. Select one radio button which are in datalist in asp.net. ASPX Page Code- - - - -. Javascript tag start from here- -. Var oItem = chkControl.children;. Var theBox= (chkControl.type= "radio")? ChkControl : chkControl.children.item[0];. Elm=theBox.form.elements;. Data list code- - - - - - -. Within datalist use server side checkbox. Server side code for DataList- - - - - - -. Links to this post.
harishgola.blogspot.com
Microsoft Technology Related Posts: 09/09/08
http://harishgola.blogspot.com/2008_09_09_archive.html
Microsoft Technology Related Posts. Earn upto Rs. 9,000 pm checking Emails. Join now! Tuesday, September 9, 2008. Importing text files into tables, and Creating Text Files using BCP. Importing text files into tables]. Using the 'bulk insert' statement, it is possible to insert a text file into a temporary table. Simply create the table like this:. Create table foo( line varchar(8000) ). 8230;and then run an bulk insert to insert the data from the file, like this:. Creating Text Files using BCP]. Bcp "SEL...
harishgola.blogspot.com
Microsoft Technology Related Posts: 05/30/08
http://harishgola.blogspot.com/2008_05_30_archive.html
Microsoft Technology Related Posts. Earn upto Rs. 9,000 pm checking Emails. Join now! Friday, May 30, 2008. What’s the advantage of using System.Text.StringBuilder over System.String? StringBuilder is more efficient in the cases, where a lot of manipulation is done to the text. Strings are immutable, so each time it’s being operated on, a new instance is created. Can you store multiple data types in System.Array? The first one performs a deep copy of the array, the second one is shallow. Well, if at that...
harishgola.blogspot.com
Microsoft Technology Related Posts: 06/13/08
http://harishgola.blogspot.com/2008_06_13_archive.html
Microsoft Technology Related Posts. Earn upto Rs. 9,000 pm checking Emails. Join now! Friday, June 13, 2008. There are many methods to generate random number in SQL Server. Method 1 : Generate Random Numbers (Int) between Rang. Create the variables for the random number generation. DECLARE @Random INT;. DECLARE @Upper INT;. This will create a random number between 1 and 999. SET @Lower = 1 - The lowest random number. SET @Upper = 999 - The highest random number. Method 2 : Generate Random Float Numbers.