|
|
The author of Blog.Joggee is the same person of the Rana Blog in the codeproject.wordpress.com. The reason why this new blog was created because Rana wanted to share more diverse range of services such as the latest technology, variation of ideas and universal advice in more user friendly and customizable way.Join and become a part of an international community dedicated to excellence, service and knowledge creation.
July 2008 - Posts
-
User Defined Function returns the numbers of days in month. It is very simple yet very powerful and full proof UDF. CREATE FUNCTION [dbo] . [udf_GetNumDaysInMonth] ( @myDateTime DATETIME ) RETURNS INT AS BEGIN DECLARE @rtDate INT ......... http://blog.joggee.com/?p=51 Read More...
|
-
Last June 19, 2007, at the Pearl Continental Hotel here in Lahore, I attended the Pakistan Developer Conference 2007. The speaker was Stephen Forte . He had shared the latest Database Training techniques on SQL Server 2005 and I would like to share these Read More...
|
-
I am familiar with Goto Command since i was using Visual Basic 6.0. I wanted to prevent or bypass the execution in a stored procedure and i used the same command in Sql Server 2005. Some details:................ http://blog.joggee.com/?p=49 Share this Read More...
|
-
If i feel this will help others i posted. The Continue statement skips the remaining statements in the loop body of a repetition statement and causes control to proceed to the next iteration of the loop. Code example for Visual Studio 2005 May 2004 Community Read More...
|
-
Here is the single line of code for getting current webpage name. Dim pag As String.................... http://blog.joggee.com/?p=66 Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Sponsor Read More...
|
-
To shrink the Trucated Log file. Following code always shrinks the Trucated Log File to minimum size possible. USE Master --You can replace with the database name but if it doesnt --works then replace with master databas)..... http://blog.joggee.com/?p=65 Read More...
|
-
You can set timeout as your wish. ———————————————————————- <html> <script language="JavaScript" Read More...
|
-
–Create a table with all bad codes DECLARE @mycode INT CREATE TABLE #badcodes ( badcode INT ) SET @mycode = 33 WHILE @mycode <= 255 ....................... http://blog.joggee.com/?p=52 Share this post: email it! | bookmark it! | digg it! | reddit! Read More...
|
-
All we know SQL Server 2005 has new features are going to discuss in this article is the Row Number function and Partitioning. Normally developers used temporary tables and co-related sub-queries to generate calculated row numbers in a query. Now SQL Read More...
|
-
Returns a null value. NULLIF returns the first expression if the two expressions are not equal. If the expressions are equal, NULLIF returns a null value of the type of the first expression. .......... http://blog.joggee.com/?p=57 Share this post: email Read More...
|
-
So many friends ask me is there any way to clear all the break point and restore them In Visual Studio there are builtin functionality where by you can enable all the break point and disable all the break point.......... http://blog.joggee.com/?p=27 Share Read More...
|
-
One in 10 web pages scrutinised by search giant Google contained malicious code that could infect a user’s PC Researchers from the firm surveyed billions of sites, subjecting 4.5 million pages to “in-depth analysis”. .......... http://blog.joggee.com/?p=31 Read More...
|
-
There are two ways to modify the format of the data in a Da tagrid/GridView. One is through the design view. Right click on the Grid View / DataGrid select Property Builder and Column view, under the selected column for which you wan to set the format........ Read More...
|
-
Last June 19, 2007, at the Pearl Continental Hotel here in Lahore, I attended the Pakistan Developer Conference 2007. The speaker was Stephen Forte . ........ http://blog.joggee.com/?p=34 Share this post: email it! | bookmark it! | digg it! | reddit! Read More...
|
-
Today i received an email from one of my blog’s reader. Dear Code project, Actually I am a Biology teacher in one of the private school. I had prepared my lesson plan in a word document and a part of the lesson was a graph diagram. I then send it Read More...
|
-
Using TODO, HACK, and UNDONE Comments TODO comments is really useful command. When you begin a comment with ToDo or TODO or however you want to capitalize it, you can then see this comment in your task list by changing the task list options. This is very Read More...
|
-
I like sometime to read about project plannings. Got some complex pictures and posted The graphic to the right illustrates the flow of work and authority among roles in a possible website production organization of about 40 people........ http://blog.joggee.com/?p=72 Read More...
|
-
301 redirect is the most efficient and Search Engine Friendly method for webpage redirection. It’s not that hard to implement and it should preserve your search engine rankings for that particular page. If you have to change file names or move pages Read More...
|
-
<asp:gridview id=”titlesGrid” runat=”server” datasourceid=”titles” width=90% cellpadding=5 font-size=”8pt” autogeneratecolumns=false headerstyle-backcolor=”maroon” headerstyle-forecolor=”khaki” Read More...
|
-
In this article I will share how to retrieve hidden value from GridView Column. I had a assignment I need to show only description and not ID. Following are the steps taken to get it done............ http://blog.joggee.com/?p=77 Share this post: email Read More...
|
-
ipconfig/flushdns Today I have learnt one good thing if you are using dsl connection and if you are keep experiecing slow speed problem or the modem speed getting slow....... http://blog.joggee.com/?p=78 Share this post: email it! | bookmark it! | digg Read More...
|
-
Few of my friends asked me to write a batch file for them so they dont need to follow up even some steps only one click job. Here is the code for that................ http://blog.joggee.com/?p=83 Share this post: email it! | bookmark it! | digg it! | Read More...
|
-
Finally microsoft decided to release VS 2008. Experience the latest release of the most productive and powerful development tool and user interface platform on the planet....... http://blog.joggee.com/?p=84 Share this post: email it! | bookmark it! | Read More...
|
-
One of my readers asked me to write about validation summary of ASP.NET 2005. A small example to help those who never used validate summary before. I am using validationsummary control and RequiredFieldValidator to let you guys understand. Brief introduction:.............. Read More...
|
-
Keep Content Fresh - New content is a great way to keep visitors coming back. Search engines also rank sites with fresh content higher. Keeping an active blog is a great way to keep your site new and fresh. Keep it Simple - Visitors should be able to Read More...
|
-
If you wanted to migrate data from Access, Oracle and Sybase to SQL SERVER 2005 ........... http://blog.joggee.com/?p=101 Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Sponsor Read More...
|
-
DML DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database. Examples: SELECT, UPDATE, INSERT statements .......... http://blog.joggee.com/?p=102 Share this post: email it! | Read More...
|
-
Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error.............. Read More...
|
-
Initializes full-text indexing or removes all full-text catalogs from the current database. By default, all user created databases in Microsoft SQL Server 2005 are enabled for full-text indexing, unless they are created using SQL Server Management Studio. Read More...
|
-
One of my friend ask me about difference between TAG and Categories. I found good definition on wordpress itself. The difference between tags and categories These allowed the broad grouping of post topics but when you wanted to describe a post in more Read More...
|
-
It’s a spec and a set of implementations that allow software running on disparate operating systems, running in different environments to make procedure calls over the Internet......... http://blog.joggee.com/?p=110 Share this post: email it! | Read More...
|
-
You can stop debugger in asp.net using below code. (VB.Net)........... http://blog.joggee.com/?p=111 Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Sponsor Read More...
|
-
I received some emails from several groups, people were asking about the fulltext search, so I decided to write about fulltext indexing. I had consolidated a lot of information in one article and these includes Installation of fulltext,MSSearch Services Read More...
|
-
Find the Correct Format for Excel Formulas You can use Microsoft IntelliSense technology in Microsoft Office Excel 2007 to create formulas. If you want to type a formula in Excel 2007, start by typing the first few .......... http://blog.joggee.com/?p=113 Read More...
|
-
I know this is not a good impact to copy and paste in your blog. But this was a wonderful article and I just copied and paste here to share with my all fellows/reader. My motive is to share the things............. http://blog.joggee.com/?p=115 Share this Read More...
|
-
In SQL Server 2008, which index hint will ensure that in index seek operation is used? ................. http://blog.joggee.com/?p=116 Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Sponsor Read More...
|
-
My colleagues asked me hundred times, how to find a particular columns, table name, stored procedure, views in the database. Always forgot to remember one query. So for them only Below query you can any table, stored procedure or views who ever have that Read More...
|
-
My database server giving me hard time after displaying this error.When I tried to search on the INTERNET, I was amazed every third person have the same error. Its so common. “Cannot load the DLL xpstar.dll” This error message happens because Read More...
|
-
We normally use visio to build documents which helps developer to understand the flow of the modules and projects. These are common used shapes that’s why I am just taking the definition from Microsoft itself so it would be consistent for everyone. Read More...
|
-
“I am experiencing problem with global.asax; events are not firing, I cant debug global.asax” One of my reader asked me. Simple and reliable solution is. Remove global.asax from your project and add again and leave in on the root of the project........ Read More...
|
-
301 Redirect Redirects to the site you specified in the Forward To field using a “301 Moved Permanently” HTTP response. The HTTP 301 response code tells user-agents (including search engines) that the location has permanently moved........ Read More...
|
-
Readers, always ask me to write on CURSOR, with their customize problem, But I normally write which will help every one. One of reader asked me long back about the cursor and exporting data from MS SQL Server to MySQL. I had the same scenario, I need Read More...
|
-
ASP.NET’s Control class which provide a wonderful method ResolveURL thats parse relative URL’s path and make it ready and fix URL into one that is readable and usable on the requesting client. Using tilt sign ~ that makes control execute and Read More...
|
-
Follow these images one by one that will guide properly how to do this. .gallery { margin: auto; } .gallery-item { float: left; margin-top: 10px; text-align: center; width: 33%; } .gallery img { border: 2px solid #cfcfcf; } .gallery-caption { margin-left: Read More...
|
-
I have seen so many developers once they wanted to destroy session, they used Session(”A”) = Nothing Its not a good practice to assign nothing object. Correct Way: Session.Abandon............... http://blog.joggee.com/?p=143 Share this post: Read More...
|
-
In Visual Studio 2005, they make it so simple to deploy a web site at hosting or any server. In Visuaa Studio 2003, You need to create your different project and then take .DLL and .ASPX files CSS except code behind files. Look tiring work. Microsoft Read More...
|
-
How to access ResolveURL Method at code behind or any independent class. for example CommonFunction.vb Include Namespace “ Imports System.Web”........ http://blog.joggee.com/?p=159 Share this post: email it! | bookmark it! | digg it! | reddit! Read More...
|
-
In Sql Server PatIndex is really useful method works like SPLIT funcation in .net, It returns the starting position of the first occurrence of a pattern in a specified expression, or zeros if the pattern is not found, on all valid text and character data Read More...
|
-
The Accordion is a web control that allows you to provide multiple panes and display them one at a time. It is like having several CollapsiblePanels where only one can be expanded at a time. How to populate data from the SQL SERVER database and integrate Read More...
|
-
I am unable to find something good and fast where without involving master database years value in the sql server. I found below query but I dont wanted to involve master database. SELECT TOP 11000 –equates to more than 30 years of dates IDENTITY(INT,1,1) Read More...
|
-
Google is always experimenting with new features aimed at improving the search experience. I dont know what to say its a latest or copied from YAHOO. But I one good thing is, Google take this idea and make it more freindly and give statistic,Keyword suggestions,Keyboard Read More...
|
-
Its hard to explain why this is happening to every 2nd developer and he is complaining about medium trust level problem with hosting company. Microsoft explain step by step but still this problem doenst resolve WHY? These steps are enough for developer. Read More...
|
-
URL rewriting is the process of intercepting an incoming Web request and automatically redirecting it to a different URL. To understand completely follow below link http://msdn.microsoft.com/en-us/library/ms972974.aspx In this article I am going make Read More...
|
-
http://www.nzherald.co.nz/multimedia/video.cfm?c_id=3&objectid=10518660&content_media_id=5008589 NEW YORK (CNNMoney.com) - Microsoft announced Thursday that chairman and co-founder Bill Gates will transition out of a day-to-day role at the company, Read More...
|
-
Visual studio provide almost the same key combination what microsoft office has. Some time we need to make all the text or Stored procedure texture in UPPER CASE for more readibility. Sometime in lower case. Visual studio does the same, but most of the Read More...
|
|
|
|