InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 14:40:07 GMT20http://www.sqlservercentral.com/Forums/Topic1042941-338-1.aspxSorry! I dont know that.I creat my thread :[url]http://www.sqlservercentral.com/Forums/Topic1365604-392-1.aspx[/url]Thu, 27 Sep 2012 23:07:56 GMTmaida_rhhttp://www.sqlservercentral.com/Forums/Topic1042941-338-1.aspx[quote][b]maida_rh (9/26/2012)[/b][hr][b][font="Arial Black"]I want to compare a column value if following char are in the string then need to split it ?MY C# CODE :[/font][/b][code="other"]string val = strtxt.Text.Trim(); if (val.Contains("N") == true && val.Contains("E") == true && val.Contains("M") == true && val.Contains("H") == true && val.Contains("T") == true && val.Contains("V") == true && val.Contains("L") == true && val.Contains("C") == true) { string[] pvalues = val.Split(new char[] { 'N', 'E', 'M', 'H', 'T', 'V', 'L', 'C' }); foreach (string s in pvalues) { if (s.Trim() != "") { lstsplit.Items.Add(s); lblmsg.Text = "split succesfully"; } } } else { lblmsg.Text = "split cant be done"; }[/code][font="Arial Black"]I used above code to compare and split the string and want to do in sql server trigger after insert on table. Any help regarding this.[b][/b][/font][/quote]You should not hijack someone else's thread. Instead you should start your own. I would however recommend that before you start a thread that you read the first link in my signature about best practices when posting questions. Your post raises more questions then it answers. Why in a trigger? Are you familiar with string splitting in sql? If not, then you should read the article in my signature about splitting strings. The more details you provide in your question the better the answer you will get.Wed, 26 Sep 2012 07:52:51 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1042941-338-1.aspx[b][font="Arial Black"]I want to compare a column value if following char are in the string then need to split it ?MY C# CODE :[/font][/b][code="other"]string val = strtxt.Text.Trim(); if (val.Contains("N") == true && val.Contains("E") == true && val.Contains("M") == true && val.Contains("H") == true && val.Contains("T") == true && val.Contains("V") == true && val.Contains("L") == true && val.Contains("C") == true) { string[] pvalues = val.Split(new char[] { 'N', 'E', 'M', 'H', 'T', 'V', 'L', 'C' }); foreach (string s in pvalues) { if (s.Trim() != "") { lstsplit.Items.Add(s); lblmsg.Text = "split succesfully"; } } } else { lblmsg.Text = "split cant be done"; }[/code][font="Arial Black"]I used above code to compare and split the string and want to do in sql server trigger after insert on table. Any help regarding this.[b][/b][/font]Wed, 26 Sep 2012 06:11:59 GMTmaida_rhhttp://www.sqlservercentral.com/Forums/Topic1042941-338-1.aspx[quote][b]christophe.bernard 47659 (1/6/2011)[/b][hr]Hi,thanks you so much for your sample now i understand that we can add a relation between the table deleted and inserted ..Sorry i'm a beginner and i WANT to understand ;)thanks and have a nice year ..Christophe[/quote]Glad I could help and welcome to SSC!!!Thu, 06 Jan 2011 07:52:07 GMTLutzMhttp://www.sqlservercentral.com/Forums/Topic1042941-338-1.aspxHi,thanks you so much for your sample now i understand that we can add a relation between the table deleted and inserted ..Sorry i'm a beginner and i WANT to understand ;)thanks and have a nice year ..ChristopheThu, 06 Jan 2011 07:28:29 GMTchristophe.bernard 47659http://www.sqlservercentral.com/Forums/Topic1042941-338-1.aspxHere's a setup to play with including some tests to check whether a sproc will be fired or not.[code="sql"]USE tempdbGOif object_id('temp','U') is not null drop table tempCREATE TABLE temp( idCourse INT, Libelle VARCHAR(300))GOCREATE TRIGGER compare ON tempINSTEAD OF UPDATE ASBEGIN -- check if there is one single row where the value of column Libelle has changed IF EXISTS ( SELECT 1 FROM DELETED d INNER JOIN INSERTED i ON i.idCourse = d.idCourse WHERE i.Libelle <> d.Libelle ) BEGIN PRINT 'FIRE STORE PROCEDURE' END ELSE BEGIN PRINT 'NOT FIRE STORED PROCEDURE' ENDENDGOINSERT INTO tempSELECT 1,'1' UNION ALLSELECT 2,'2'UPDATE temp SET Libelle = Libelle+1 UPDATE temp SET Libelle = Libelle+1 WHERE idCourse = 2UPDATE temp SET Libelle = LibelleWHERE idCourse = 2UPDATE temp SET Libelle = Libelle+1 WHERE idCourse = 3[/code]Wed, 05 Jan 2011 07:48:15 GMTLutzMhttp://www.sqlservercentral.com/Forums/Topic1042941-338-1.aspxHi lutz,sorry but i can't understand !?have you got an example or the method i must to use ?!no it"s not a homework ;-(thanks christopheWed, 05 Jan 2011 06:18:39 GMTchristophe.bernard 47659http://www.sqlservercentral.com/Forums/Topic1042941-338-1.aspxYour approach will only compare the first updated value, whereas "first" is equal "first random" in this case since there is no ORDER BY.When you use triggers always make sure to be ready to deal with multiple result sets.So, instead of assigning the first value to a variable, compare the two tables (inserted and deleted) directly using NOT EXISTS().Question aside (please, don't get me wrong): is this some kind of homework?Wed, 05 Jan 2011 04:42:31 GMTLutzMhttp://www.sqlservercentral.com/Forums/Topic1042941-338-1.aspxHi,i'm a beginner with t sql => sql server 2005.i have this table : T_courses with these fields : idCourse (int), Libelle varchar(300), dateCourse (datetime)i must to create a trigger who is fired on update table => T_COURSESbut with the old libelle and new libelle i must to compare these two field AND if there is a difference fire a stored proceduremy question is: how to compare these two strings ?here is it my code for the moment :[quote]CREATE TRIGGER TR_COURS_UPDATE ON T_COURSESFOR UPDATEASdeclare @oldLibelle varchar(300)declare @newLibelle varchar(300)SELECT @oldLibelle = (SELECT TOP 1 FROM DELETED)SELECT @newLibelle = (SELECT TOP 1 FROM INSERTED)IF(oldLibelle <> @newLibelle) -- => how to compare these stringBEGIN PRINT 'FIRE STORE PROCEDURE'ENDELSEBEGIN PRINT 'NOT FIRE STORED PROCEDURE'END[/quote]THANKS FOR YOUR TIME AND SAMPLE !do you think my code is ok ?happy new year..guysChristopheWed, 05 Jan 2011 04:28:42 GMTchristophe.bernard 47659