Hi Guys

Thanks for your reply

I used stored procedure for inserting keywords into a text data filed.Now I need to do update function

My code is as below Please let me...

I used my text field as nvarch ar(max).But I need a list of keywords in the same row separated by comas.Now I understand about normalisation.But unfortunately I am not able...

I stored it as single keyword per each row

eg:'a' in first row

'b' second row etc.could you please let me know abt the solution

In my text data field I am using sample data as 'a' , 'b' ,'c' etc.Each of this key word is stored in seperate rows.I need to create a stored...

Thanks for your reply

Yes exactly.

"If so, I strongly urge you to consider normalising that design". How do I normalise that design??

CREATE TABLE [dbo].[MyTableSearch](

[Myfield] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL

) ON [PRIMARY]...

Thanks alot Guys....

Thanks alot!!I will try and let you know

Hi

I dont knw what exactly you mean..I am new to stored procedure and xml data field..So Please provide some eg with code

Hi I think that my trigger is working...but there is some mistakea in my code...

I am not able to use TSQL trigger since i have xml datatype is there...

So pls...

helloo

Hi

I did the changes as u mentioned for clr trigger ...

my code is as below

- Hide quoted text -

using

System;

using

System.Data;

using

System.Data.Sql;

using

System.Data.SqlTypes;

using

System.Data.SqlClient;

using

Microsoft.SqlServer.Server;

using

System.Xml;

using

System.IO;

//using System.Transactions;

public

partial...

Thanks alot!!!

I dont have any idea about TSQL ...Please help me

I am using Visual Studio 2008 for Clr trigger insert....

I created a CLR trigger for insert command by above code...

using System;

using System.Data;

using System.Data.Sql;

using System.Data.SqlTypes;

using System.Data.SqlClient;

using Microsoft.SqlServer.Server;

using System.Xml;

using System.IO;

//using System.Transactions;

public...

thanks for your quick response ..eventhogh i changed the code it didnt work

Do u knw y the insert command is not working there?what is wrong with my code?