BLOG.JOGGEE : Visio, SharePoint, SQL SERVER

SQL SERVER - UDF - User Defined Function - Get Number of Days in Month

joggee — Wed, 09 Jul 2008 18:26:00 GMT

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

Stephen Forte's Database Training

joggee — Wed, 09 Jul 2008 18:24:00 GMT

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 techniques and updates

because of its simplicity and for everybody to be in

with the latest with the database programming.

Visit my blog and learn a lot from it.

I would like to personally thank Stephen Forte for

imparting his knowledge at the conference and I

hope you too will have get an addition point from

this topic.

—————————————————————————————–

Setup TSQL Problems

CREATE TABLE Classes (

ClassID int NOT NULL,

Class varchar (50),

Students int NOT NULL, CONSTRAINT

PK_Classes PRIMARY KEY CLUSTERED

(ClassID

) )
¼br /> GO..................... http://blog.joggee.com/?p=34

SQL Server 2005- How to prevent Execution - Goto (T-SQL)

joggee — Wed, 09 Jul 2008 18:20:00 GMT

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

New Feature in VB.NET 2005 - The Continue Statement,Next iteration

joggee — Wed, 09 Jul 2008 18:14:00 GMT

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 Preview

` // Continue Statement in Visual Basic 8.0

` For using Continue statement.

For i As Integer = 0 To 100..................... http://blog.joggee.com/?p=50

ASP.NET - How to get current webpage name.

joggee — Wed, 09 Jul 2008 18:11:00 GMT

Here is the single line of code for getting current

webpage name.

Dim pag As String.................... http://blog.joggee.com/?p=66

SQL Server 2005 - How to shrink the truncated log file.

joggee — Wed, 09 Jul 2008 18:05:00 GMT

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

Javascript - Display alternate message in textbox

joggee — Wed, 09 Jul 2008 17:55:00 GMT

You can set timeout as your wish.

———————————————————————-

<html>

var text = 0;

var message=new Array();
message[0] = "Welcome to Rana's Blog Code Project!"
message[1] = "Get free source code from Rana's Blog."
message[2] = "Solution will be provided on request."
message[3] = "Good bye from Rana's blog code project."

function changeText() {
if (message.length > 0) {
document.change.descript.value=message[text];
text++; }............ http://blog.joggee.com/?p=59

Sql Server Tips - Removing or Replacing non-alphanumeric characters in strings

joggee — Wed, 09 Jul 2008 17:45:00 GMT

–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

SQL SERVER 2005 , How to Partition the table.

joggee — Wed, 09 Jul 2008 17:34:00 GMT

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 Server 2005 provides a function, which replaces all of the additional resources we used to generate row numbers......... http://blog.joggee.com/?p=17

SQL SERVER 2005 - What is NULLIF ?

joggee — Wed, 09 Jul 2008 17:29:00 GMT

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

ASP.Net 2005 - How to Restore all the break point

joggee — Wed, 09 Jul 2008 17:26:00 GMT

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

Google searches web’s dark side

joggee — Wed, 09 Jul 2008 17:11:00 GMT

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

ASP.NET - Format datagrid columns.

joggee — Wed, 09 Jul 2008 16:38:00 GMT

There are two ways to modify the format of the data in a Datagrid/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........ http://blog.joggee.com/?p=37

Stephen Forte’s Database Training

joggee — Wed, 09 Jul 2008 16:38:00 GMT

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

View as HTML

joggee — Wed, 09 Jul 2008 16:32:00 GMT

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 to my gmail account and open it at school

to print the lesson plan.

I had noticed that the printed lesson plan did not have my graph.

Can you advise me how I can have my graph along with my lecture?

Reply : Here are the options when you open an email having attachment . ........ http://blog.joggee.com/?p=40