C#

CREATE PROCEDURE dbo.SaveJobs
@ID BIGINT OUT,
@ProjectID BIGINT,
@FileName NVARCHAR(255),
@SourceLanguage BIGINT, 
@TargetLanguage BIGINT, 
@Type BIGINT, 
@CharCount BIGINT, 
@PageCount DECIMAL(10,4), 
@ApplicableRate DECIMAL(10,4), 
@QuotedOn DATETIME
AS
INSERT INTO JOBS(ProjectID, FileName, SourceLanguage, TargetLanguage, Type, CharCount, PageCount, ApplicableRate, QuotedOn)
VALUES (
@ProjectID, 
@FileName, 
@SourceLanguage, 
@TargetLanguage, 
@Type, 
@CharCount, 
@PageCount, 
@ApplicableRate, 
@QuotedOn)

SET @ID = SCOPE_IDENTITY()

error1408 wrote:

if you had to search 50000 lines of code for the word example as fast as possible, with every kind of whitespace in the line, which method would you prefer.

REGEX

or

myString.Trim() == "example"

<br />
using (StreamReader rIn = new StreamReader("test.txt"))<br />
            {<br />
                string line = "";<br />
                while ((line = rIn.ReadLine()) != null)<br />
                {<br />
                    if (line.Trim() == "{{{tcl")<br />
                    {<br />
                        return true;<br />
                    }<br />
                }<br />
                rIn.Close();<br />
<br />
            }<br />
            return false;<br />

<br />
using (StreamReader rIn = new StreamReader("test.txt"))<br />
            {<br />
                string line = "";<br />
                Regex reg = new Regex(@"\s*\{\{\{tcl\s*");<br />
                while ((line = rIn.ReadLine()) != null)<br />
                {<br />
                    if (reg.IsMatch(line))<br />
                    {<br />
                        return true;<br />
                    }<br />
                }<br />
                rIn.Close();<br />
            }<br />
            return false;<br />

public void SetOption(string B, int C)<br />
{<br />
this.Invoke("SetOption", new object[] { ([A] from global source which has been verified to be active), B, C });<br />
}

[WebMethod]
public void Foo{string a, string b, string c}{
    HelpFoo("test", b, c);
}
private void HelpFoo(string a, string b, string c){
    ...
}

VarChar255 wrote:

The question is, what is the best algorithm to use to achive the above results?

VarChar255 wrote:

No not homework at all... actually one of my developers is having trouble with this, he wrote the code but i'd like to get some opinions from others on what patterns they use.