Microsoft Technology DOT NET, SQL SERVER, SILVERLIGHT, JAVASCRIPT

Create TextArea control with working Maxlength property

noreply@blogger.com (sky) — Mon, 13 Aug 2007 09:17:00 +0000

We have found that text area (Multiline textbox) control in asp.net doesn't support the multiline property even you define that property.

so here is the solution for this problem

Code in .net Page

protected override void OnPreRender(EventArgs e)
{

if (MaxLength > 0 && TextMode == TextBoxMode.MultiLine)
{

// Add javascript handlers for paste and keypress
Attributes.Add("onkeypress", "doKeypress(this);");
Attributes.Add("onbeforepaste", "doBeforePaste(this);");
Attributes.Add("onpaste", "doPaste(this);");

// Add attribute for access of maxlength property on client-side
Attributes.Add("maxLength", this.MaxLength.ToString());

// Register client side include - only once per page

}
}

Code in JavaScript file

// Keep user from entering more than maxLength characters
function doKeypress(control)
{

maxLength = control.attributes["maxLength"].value;

value = control.value;

if(maxLength && value.length > maxLength-1)
{

event.returnValue = false;

maxLength = parseInt(maxLength);

}
}

// Cancel default behavior
function doBeforePaste(control)
{

maxLength = control.attributes["maxLength"].value;

if(maxLength)
{

event.returnValue = false;

}
}

// Cancel default behavior and create a new paste routine
function doPaste(control)
{

maxLength = control.attributes["maxLength"].value;

value = control.value;

if(maxLength)
{

event.returnValue = false;

maxLength = parseInt(maxLength);

var oTR = control.document.selection.createRange();

var iInsertLength = maxLength - value.length + oTR.text.length;

var sData = window.clipboardData.getData("Text").substr(0,iInsertLength);

oTR.text = sData;

}
}

using this code you can even check the copy paste and restrict the number of characters

now create a custom control and then use that control

set MaxLenght property of that control and you will be able to restrict the number of characters

Code Optimization Tool for C#

noreply@blogger.com (sky) — Mon, 13 Aug 2007 04:54:00 +0000

I just find one nice tool for the day to day development, and instant code optimization at the time of writing the code.

Once you install this tool it will tell you in the IDE itself, that which part of the code need to be change, not use full, wrong interation looping, wrong condition and all such a small mistake that may happened into day to day activities.

You can download it from
http://www.jetbrains.com/resharper/download/index.html#cSharp

Install at your own risk as i have installed it on several PCs but on one PC it removed intellisense from IDE.

Can you call private member of a class from another class?

noreply@blogger.com (sky) — Fri, 10 Aug 2007 07:18:00 +0000

Can you call private member of a class from another class?

Very strange question right?

but answer is yes. Shocked???

Check out the following code.

It is done by dot net framwork reflection

suppose we have a class

public class Class1
{

public Class1()
{

}

private string IAmCalled()
{

return "I am private member and I am called by somebody. shame on me.";

}

}

Add following line to other class/page from which you want to access private member

using System.Reflection;

Just write follwoing code in other class/page and you will see the magic

Class1 cls = new Class1();

Type t = typeof(Class1);

object obj = t.InvokeMember("IAmCalled", BindingFlags.InvokeMethod BindingFlags.NonPublic BindingFlags.Instance, null, cls, null);

Response.Write(obj.ToString());

It works!!!

please share if you have some more information.

How to Check upload file type using RegularExpressionValidator

noreply@blogger.com (sky) — Thu, 09 Aug 2007 05:44:00 +0000

You can check upload file type client side using RegularExpressionValidator as shown below

use ValidationExpression as follows

ValidationExpression="(.*\.([jJ][pP][gG]|[jJ][pP][eE][gG]|[pP][nN][gG]|[tT][iI][fF][fF])$)"

This expression restricts upload to the file type of .jpg, .jpeg, .tiff
you can edit validation expression as per your need.

How to Create / Insert Table Data From Remote server in Sql Server 2005 to local server

noreply@blogger.com (sky) — Wed, 08 Aug 2007 06:32:00 +0000

OPENROWSET can be used to access remote data from OLE DB data sources only if the DisallowAdhocAccess registry option is explicitly set to 0. When this option is not set, the default behavior does not allow ad hoc access.

To set DisallowAdhocAccess :-

Execute below script:

EXEC sp_configure 'show advanced options', 1;
GO

RECONFIGURE;
GO

EXEC sp_configure 'Ad Hoc Distributed Queries', 1;
GO

RECONFIGURE;
GO

After that execute following statement

select * into Destination_table from

(SELECT a.*

FROM OPENROWSET('SQLOLEDB','SERVER';'USER';'PASSWORD',

'SELECT * FROM Database.dbo.SourceTableName') AS a ) a

first it will create Destination_table in our local server , and after it will copy all data from Remote server database "Database.dbo.SourceTableName" into Destination_table.

How to select number of rows from table in sql server

noreply@blogger.com (sky) — Tue, 07 Aug 2007 10:05:00 +0000

Hello

Here are two ways to select number of rows when count is passed in parameter

1. using TOP

declare @count int

set @count = 5

select top(@count) * from temp_Users

2. using ROWCOUNT

declare @count int

set @count = 5

set rowcount @count

select * from temp_Users

Please comment more ways of performing this functionality.

set rowcount 0

Silverlight Tutorials, Silverlight Videos, Silverlight Articles, Silverlight Blog, Silverlight Example and Application

noreply@blogger.com (sky) — Tue, 07 Aug 2007 07:19:00 +0000

Good Website consist of plenty of links for Silverlight Introductions and Overviews :

It consist of Silverlight Introduction Resource, such how to get started with.

Silverlight Sites - It consist of Silverlight Site from microsoft.
Silverlight Blogs - It consist of blog post on silverlight from well known authors.
Silverlight Articles - It consist of various articles on silverlight
Silverlight Videos - It consist of Silverlight Videos.
Silverlight Applications - It consist of Silverlight Examples and Demo Applications.
Silverlight Downloads - It consist of different Silverlight Version to download.
Silverlight Resources - And more on Silverlight Resource.

Logon to get Silverlight Resource and Information

I found this interesting post on http://dotnetguts.blogspot.com/

I feel that i must share this with you.

About the School of the future

noreply@blogger.com (sky) — Wed, 01 Aug 2007 06:40:00 +0000

Hello

I found something very interesting effort by microsoft.

Yes its the school of the future which is being raising by Microsoft with the help of local authorities.

to know more visit

http://www.microsoft.com/Education/SchoolofFutureDocumentary.mspx

Enjoy!

Silverlight Tutorials

noreply@blogger.com (sky) — Fri, 27 Jul 2007 07:05:00 +0000

Hello

Good Website for Silverlight Tutorials

Silverlight with Java Script Tutorial
Silverlight Examples and samples

http://www.wynapse.com/Silverlight_Tutorials.aspx

Enjoy!

Show JavaScript Message While Closing IE Without Saving

noreply@blogger.com (sky) — Thu, 26 Jul 2007 12:51:00 +0000

Hello Friends

Following is the script to show message while navigating away from the current screen in browser.

var blnConfirmNavigation=true;
window.onbeforeunload = function (evt)
{

blnDeleteForum=false;
if(blnConfirmNavigation)
{
var message = 'You have not save the content of the page. Your changes will not be saved.';
if (typeof evt == 'undefined')
{
evt = window.event;
}
if (evt)
{
evt.returnValue = message;
}
blnDeleteForum=true;
return message;
}
}

Enjoy!

.NET Framework 3.0 Versioning and Deployment Q&A

noreply@blogger.com (sky) — Thu, 05 Jul 2007 12:41:00 +0000

Hello Friends,

I have found some Q&A related to .net framework 3.0 Versioning and deployment.

You can find answers to some questions like

What is the .NET Framework 3.0 (formerly WinFX)?
What happens to the WinFX technologies?
How does the .NET Framework 3.0 relate to the .NET Framework 2.0?
Will the name change be reflected in any of the existing .NET Framework 2.0 APIs, assemblies, or namespaces?
How does "Side by Side" work for the .NET Framework 3.0?

You can find answers to these and many other questions on following link.

http://msdn2.microsoft.com/en-us/netframework/aa663314.aspx

Hope this will help

Enjoy!

Create .NET documentation with Microsoft's Sandcastle

noreply@blogger.com (sky) — Fri, 29 Jun 2007 06:09:00 +0000

Hello

I come across an article which explains How we can create .NET documentation with Microsoft's Sandcastle.

http://articles.techrepublic.com.com/5100-3513-6174811.html

Hope this helps.

Enjoy!

Dot Net FAQs

noreply@blogger.com (sky) — Thu, 28 Jun 2007 15:42:00 +0000

ASP.net FAQs
1) http://www.syncfusion.com/faq/aspnet/default.aspx

2) http://www.aspnetfaq.com/

3) http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=4081&lngWId=10

4) http://blogs.crsw.com/mark/articles/254.aspx

5) http://www.techinterviews.com/?p=176 & http://www.techinterviews.com/?p=193

6) http://www.eggheadcafe.com/articles/20021016.asp

7) http://www.cmap-online.org/Default.aspx?tabindex=4&tabid=-17

C# FAQs
1) http://www.andymcm.com/

2) http://www.syncfusion.com/faq/windowsforms/default.aspx

3) http://www.c-sharpcorner.com/faq.asp

4) http://msdn.microsoft.com/vcsharp/productinfo/faq/default.aspx

5) http://www.yoda.arachsys.com/csharp/faq/

6) http://www.gotdotnet.com/team/csharp/learn/faq/

7) http://www.syncfusion.com/faq/windowsforms/default.aspx

List courtesy

http://dotnetguts.blogspot.com/

Enjoy!

Microsoft dot net framework 3.0 overview

noreply@blogger.com (sky) — Thu, 28 Jun 2007 07:46:00 +0000

Hello Friends

I am writing this article to give you almost all the needed information about the WinFx (.Net framework 3.0). I inspired to write this article is just because I feel that on the internet all the information are scattered every where and it was quite tough for me to collect the information and tools to proceed with the new era of software development. And I am also sure that now it won’t that much easy for us to move from .net2 to WinFx as we could move from .0 to .1 to .2 frameworks. I tried to write this article by my own words so that it would be easy to understand and addressing the proper direction as all the developers is needed. I am sure that once you gone through this document, you will have much comfort to learn and start up for .net 3.0.

ADDRESSING THE NEEDS OF TECHNOLOGY
Before you go through this article, I would like to ask you some of the questions that were arising in my mind when I was exploring the WinFx. Please keep all this questions in your mind and then proceed further in this article.

1. The first thing I would like to ask you is about How many time you feel that the windows application development and Web development is totally different in terms of creating the UI for both.

2. Have you ever thought that the Windows application can have same look and feel that we can give with the help of Html in web sites. How much flexibility your designer could have to prepare the GUI in Photoshop for the Windows Form.

3. How many communication methods you know and how many of them you had tried to implement by analyzing the requirements of software. Let me say that you might know XML web services, Remoting, MSMQ... and hardly tried to implement all this of them and hardly analyze the requirement to choose the right one from those methods.

4. How many times you had to deal with the very complex Business logic in your application and how many time you need to debug your code to ensure that the data manipulated by your code is the right one. This could be the case when you are implementing the ERP system. Whenever you had tried to implement that complex code, how dose your code looks likeJ, and how many of your team members can understand without your help.

5. How do you represent your code to your customer, your team members, and your Project leader with 99% of identical documents so all of them can easily understand whatever you have done in that? I am sure, that could never be possible, can be?

6. How many types of Software application you know? Let me say that you might be knowing, Standard Windows application, Web sites, Smart client application and Windows CE. Is there any new type of application that customer can or even already demand?

Once you find out the answer of all this questions, you will find nothing but the new technology from Microsoft named WinFx which is nothing but the code name of .net Framework

Ok, so now we have a vision that why we need some evolution for better intelligent and automated development environment. Let me explain in very brief about the WinFx technology just as an introductory part of it. I have given a link from where you can find detail information for those particular topics

You can find interesting White paper on WinFx from

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/intronetfx30.asp

EVOLUTION AND INTRODUCTION

There are so many basic needs which inspire Microsoft to release .net frameworks. But let me point one direction so that I can better explain you framework 3.0.

.Net Frameworks are running as an intermediate Layer between your applications developed using .net and Operating system. And so it’s of course considered as a Managed Code and that reduce the Risk for crashing an application. CLR is taking the responsibility to manage your code and manage the resource your application is using. And if we move to the future, .net Framework 3.0 is waiting for us
Just in brief, .net 3 (WinFx) is wrapper on .net 2.0 with some unbelievable features that make me to jump on my deskJ. The wrappers are again divided into four corner of Boxes.

1. WPF (Windows Presentation Foundation). New era for Windows Desktop Application UI designing. Following are some of the main features

· Now onwards there are no WinForm Controls that we are using till .net 2.0. Everything is XML. Whatever you write will be the XML for the desigining. Officially Microsoft gives its name XAML

· Because of this XML everything you can do in Html pages will now possible in Winform design also

· Cascading Style like web is possible in Winform also

· Designer draw the screen in Photoshop just like they where doing for web page. And then you can do the same step as you were doing to convert that layout in html

· Provides new type of application known as "WPF Browser based application", which can run in Internet Explorer just like the ActiveX and Applets are running

· 3D modeling.

· Animation like GIF file can be possible for the windows form.

Links
WPF Architecures and functionality
http://msdn.microsoft.com/library/en-us/dnlong/html/wpf101.asp
WPF for beginners
http://wpf.netfx3.com/
Find the features in detail for WPF
http://en.wikipedia.org/wiki/Windows_Presentation_Foundation
Introduction Videos
http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20060817wpfkg/manifest.xml
First Hands on lab
http://www.microsoft.com/downloads/details.aspx?FamilyID=05755a9d-98fa-4f16-bfdc-023e3fd34763&DisplayLang=en

2. WCF (Windows Communication Foundation). New era for Communication methods for the Distributed application development and Grid Computing with much flexibility that we never have before. This is something they are calling Service Oriented Application Architecture.

· Web service, WSE, Remorting, MSMQ... all of this is now a mapped in single API

· Easy to deploy and integration with Application.

· XML web service access speed will no more issue with the help of WCF.

Links
Learning WCF (Architecture and Foundation)
http://msdn.microsoft.com/library/en-us/dnlong/html/wcfarch.asp
Introduction of Developing WCF
http://msdn.microsoft.com/library/en-us/dnlong/html/introtowcf.asp

3. WF (Windows Workflow Foundation). This is really really very cool features that Microsoft comes up with .net 3.0. With the help of this foundation you can implement any complex Business logic which you could not even think for it. Just within a few hours you can implement few weeks of work. The features are

· Draw the Flow chart and the coding part will be written automatically. Of course you have to feed some line of code

· Represent your logic on document which is actually the code you implement

· No more syntax and commenting for Code, because your logic is in form of Flow charts

· Maintain the State of Object (Application Objects) with the Help of State Chart. Draw the state diagram for your Object and it will reach exactly in the state as per you have drawn with in IDE

· I could not believe on my eyes when I saw the demonstration of Parallel Computing and Multi threading application development. Just to draw the flow chart with some parallel Flow in sequence, that’s all to do. Not to think anything for the thread and multi process management

Links
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnlong/html/hmnwkfwwf.asp
Understanding Components in WF
http://msdn.microsoft.com/msdnmag/issues/06/12/windowsworkflow/

4. Windows Info Card: I didn’t understand anything about this. If any one of you can understand please inform me

HOW TO START FOR WinFx (Tools and Resources)
I researched and find the proper tools so that you don’t have to research again to start up with ,net 3.0. It was hard time for me to organized all this information in proper direction

1. Visual Studio 2005 is the tool for WinFx development. So nothing to worry about new tool

2. Install and download, net 3.0 frameworks. But with this installation, your 2005 IDE will not allow you to create the WinFx applications
http://www.microsoft.com/downloads/details.aspx?FamilyID=10cc340b-f857-4a14-83f5-25634c3bf043&displaylang=en

3. For the WPF development (Windows Form Design based on WinFx) install the "Microsoft Visual Studio Extension for WPF". Once you install this you can create the WPF form, WPF windows application, WPF pages, WPF controls, WPF browser application (This is not web app). Also these extensions allow you to create WCF services
http://www.microsoft.com/downloads/details.aspx?familyid=F54F5537-CC86-4BF5-AE44-F5A1E805680D&displaylang=en

4. For the Workflow development, Install the "Microsoft Visual Studio Extension for Workflow Foundation". Once you install this you can Create Sequence, Sequence Services, Sequence State Diagram.
http://www.microsoft.com/downloads/details.aspx?familyid=5D61409E-1FA3-48CF-8023-E8F38E709BA6&displaylang=en

That’s all to Do. And now you can be an expert for .net 3.0

Now there so many tools they have given for the XAML editing and WPF designing. Just like we have so many tools for the Html. Although we can do everything in VS IDE for the Html, designer will still prefer Dreamweaver for the Complex Html design. same way even though VS IDE gives everything for XAML creating and editing for the windows forms, Microsoft IDE is not proper tool for complex WinForm design like 3D modeling. Because of that Microsoft has given two tools

Microsoft Blends:
Using this tools you can create better XAML documents without writing any XAML syntax by your own. Create Style Sheets for Windows Form in form of Resouce Dictionary. This is exactly you can do in Dreamweaver for Html documents and Css file in form of Class Dictionary
http://www.microsoft.com/products/expression/en/expression-blend/try.mspx

Microsoft Design:
Using this tools you can create much complex XAML document with 3D modeling also. This can be compare as ADODB photoshop where you can craete the layout and export it as html document
http://www.microsoft.com/products/expression/en/expression-design/free-trial.mspx

There are also some third party tools are available for this designing, but i used to play with these two tools only and really amazing tools that we could not even realize before for the web application

Some of the features in Microsoft Design and Blend can only be possible in Windows Vista Environment like Glass Windows, 3D animation of windows control. Microsoft is on the way to produce number of more and more controls for the WinFx, and they will release mostly each year. There are number of Microsoft Partner Company has started to build third party control based on WinFx but none of them has released even beta version
OK, so now I think you have better startup for windows framework 3.0. So for what you are waiting for.

Whatever I have written here is all about what I understood and learnt. I might be wrong in some of the cases and so if you find any further and correct information please add your reply to this topic.

So, let’s begin our new journey for the future that we may have to face especially the person who worked on Microsoft Technology

Learning Resource
http://wpf.netfx3.com/ (Contains Videos, Sample Application, Codes, Tricks for WPF, WCF, WF and CardSpace)
http://www.netfxguide.com/guide/_net_framework_3_0.aspx (Complete Guide for WinFx, Almost Everything you needed to start with .net 3)

About Microsoft Surface

noreply@blogger.com (sky) — Thu, 28 Jun 2007 07:03:00 +0000

Hello All

Microsoft has planned to launch a greate product called "Surface"

Microsoft Surface represents a fundamental change in the way we interect with digital content.

With Surface, we can actually grab data with our hands, and move information between objects with natural gestures and touch.

Surface features a 30-inch tabletop display whose unique abilities allow for several people to work independently or simultaneously.

And strange is you dont need to use a mouse or a keyboard. ;)

really a nice thing.

for more information visit

http://www.microsoft.com/surface/

Have a look at one of the demos

Enjoy!

Small example of decimal result of numeric operation in SQL server

noreply@blogger.com (sky) — Fri, 22 Jun 2007 07:14:00 +0000

Hello

here is the small example to get result of numeric operation in decimal in sql server

declare @a decimal(10,2)
declare @a1 int
declare @a2 int

set @a1 = 3
set @a2 = 2
set @a = @a1/@a2
print @a

this will give "1.00". which is wrong result...

to get correct result you just need to cast one of the integer value in decimal as shown below

declare @a decimal(10,2)
declare @a1 int
declare @a2 int

set @a1 = 3
set @a2 = 2

set @a = @a1/cast(@a2 as decimal)
print @a

this will give "1.50". which is the result we are looking for.

Enjoy!

Date/Time Conversions Using SQL Server

noreply@blogger.com (sky) — Thu, 21 Jun 2007 15:45:00 +0000

Hello friends

here is the list of all sql date time formats,

DATE FORMATS
Format #	Query (current date: 12/30/2006)	Sample
1	select convert(varchar, getdate(), 1)	12/30/06
2	select convert(varchar, getdate(), 2)	06.12.30
3	select convert(varchar, getdate(), 3)	30/12/06
4	select convert(varchar, getdate(), 4)	30.12.06
5	select convert(varchar, getdate(), 5)	30-12-06
6	select convert(varchar, getdate(), 6)	30 Dec 06
7	select convert(varchar, getdate(), 7)	Dec 30, 06
10	select convert(varchar, getdate(), 10)	12-30-06
11	select convert(varchar, getdate(), 11)	06/12/30
101	select convert(varchar, getdate(), 101)	12/30/2006
102	select convert(varchar, getdate(), 102)	2006.12.30
103	select convert(varchar, getdate(), 103)	30/12/2006
104	select convert(varchar, getdate(), 104)	30.12.2006
105	select convert(varchar, getdate(), 105)	30-12-2006
106	select convert(varchar, getdate(), 106)	30 Dec 2006
107	select convert(varchar, getdate(), 107)	Dec 30, 2006
110	select convert(varchar, getdate(), 110)	12-30-2006
111	select convert(varchar, getdate(), 111)	2006/12/30

TIME FORMATS
8 or 108	select convert(varchar, getdate(), 8)	00:38:54
9 or 109	select convert(varchar, getdate(), 9)	Dec 30 2006 12:38:54:840AM
14 or 114	select convert(varchar, getdate(), 14)	00:38:54:840

Enjoy!

How to get length of data in Text,NText and Image columns?

noreply@blogger.com (sky) — Thu, 21 Jun 2007 15:45:00 +0000

There is sometimes a need to figure out the maximum space that is being used by a particular column in your database. You would initially think that the LEN() function would allow you to do this, but this function does not work on Text, NText or Image data types .

So to solve this problem
SQL Server has a DATALENGTH() function.

For e.g.

SELECT name, LEN(packagedata) FROM dbo.sysdtspackages

this query will give error.

the correct query is

SELECT name, DATALENGTH(packagedata) FROM dbo.sysdtspackages

Enjoy!

SQL server Identity Column information

noreply@blogger.com (sky) — Thu, 21 Jun 2007 15:44:00 +0000

Hi,

SQL Server 2000 has three functions that return IDENTITY information. The result of each of these three functions is dependent on three factors:

1. The session scope (which connection produced the IDENTITY value?)

2. The table scope (which table produced the IDENTITY value?)

3. The statement scope (where is the statement that produced the IDENTITY value?)

(SQL Statements that are contained in the same batch, stored procedure, or trigger are considered to be in the same scope.
So, if I call an INSERT that fires a trigger, I have two different scopes: scope 1 is inside the batch that called the INSERT, and scope 2 is inside the trigger.)

1. SELECT @@IDENTITY
This is everyone's favorite function, unchanged from earlier versions of SQL Server. It returns the last IDENTITY value produced on a connection, regardless of the table that produced the value, and regardless of the scope of the statement that produced the value.

2. SELECT IDENT_CURRENT ('tablename')
This new function returns the last IDENTITY value produced in a table, regardless of the connection that created the value, and regardless of the scope of the statement that produced the value.

3. SELECT SCOPE_IDENTITY ()
This new function returns the last IDENTITY value produced on a connection and by a statement in the same scope, regardless Of the table that produced the value.

Thank you

How to debug sql stored procedures?

noreply@blogger.com (sky) — Thu, 21 Jun 2007 15:43:00 +0000

Hello,

i have found a nice link for answer.

http://www.15seconds.com/issue/050106.htm

hope you will find the answer.

Thank you

How to remove noise words from SQL server?

noreply@blogger.com (sky) — Thu, 21 Jun 2007 15:41:00 +0000

How to remove noise words from SQL server?

• Check the language of your sql using following syntax

select @@languagee.g. result : us_english

• Now here you have “English language” so…• Remove required word from following files…

1. the noise.* files under your \WINNT\System32 directory

2. noise.enu (US_English) and noise.eng (UK_English) noise word files under your SQL Server default folder of \FTDATA\SQLServer\Config.

• After making these changes and before saving the file changes, you must stop the “Microsoft Search“ service, before you can save the FTDATA noise word files. When your modifications are completed, you must run a Full Population.

Enjoy.

Function to split string in SQL

noreply@blogger.com (sky) — Thu, 21 Jun 2007 15:39:00 +0000

Hello

I have found one interesting function using which you can split the text with some character like ',' or any other character.

CREATE function [dbo].[Split] (@String nvarchar(4000), @Delimiter char(1))
Returns @Results Table (Items nvarchar(4000))
As
Begin
Declare @Index int
Declare @Slice nvarchar(4000)

Select @Index = 1
If @String Is NULL Return

While @Index != 0
Begin
Select @Index = CharIndex(@Delimiter, @String)
If @Index <> 0

Select @Slice = left(@String, @Index - 1)

else

Select @Slice = @String
Insert into @Results(Items) Values (@Slice)
Select @String = right(@String, Len(@String) - @Index)

If Len(@String) = 0 break

End
Return
End

Now how to use this function

select * from dbo.Split('a,b,c,d',',')

this will give following result

Items
-----
a
b
c
d

How this function can make your life easy!

Suppose if you want to insert more than one row in a table depending on above function result

you can just do as follows

insert into Table_Name (Column_Name)
select * from dbo.Split('a,b,c,d',',')

Enjoy