CREATE FUNCTION [dbo].[Split]
(
@RowData nvarchar(max),
@SplitOn nvarchar(5)
)
RETURNS @RtnValue table
(
Id int identity(1,1),
Data nvarchar(max)
)
AS
BEGIN
Declare @Cnt int
Set @Cnt = 1
While (Charindex(@SplitOn,@RowData)>0)
Begin
Insert Into @RtnValue (data)
Select
Data = ltrim(rtrim(Substring(@RowData,1,Charindex(@SplitOn,@RowData)-1)))
Set @RowData = Substring(@RowData,Charindex(@SplitOn,@RowData)+1,len(@RowData))
Set @Cnt = @Cnt + 1
End
Insert Into @RtnValue (data)
Select Data = ltrim(rtrim(@RowData))
Return
END
///
This function how to write in mysql.....
help me plz....
reply me quick.....................
Loading

Jignesh TrivediPosted Aug 19, 2013, 10:55 PM
hi,
I think, you can use any free tool avalaible on internet.
like
http://en.kioskea.net/download/download-2777-mssql-to-mysql-conversion-utility
http://www.convert-in.com/mss2sql.htm
http://www.codeproject.com/Articles/29106/Migrate-MySQL-to-Microsoft-SQL-Server
hope this will help you.