|
|
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...
| |
|