Another alternative is to enclose it using [] Example like '%TEST[_]%' string str = "TEST_" str= str.Replace("_", "[_]");

In order to sync, you must prepare a window service. Window service will continue to update your sql server database accorting to the time interval mentioned.

Alternative is associated with Brightness. Please correct me if I am misunderstanding it. I was looking for some sample code to change contrast. Can you please provide some piece of code associated with SetMonitorContrast function

Can we change the contrast settings programaticaly? I mean, after changing, the impact can be seen in the monitor menu of contrast figure .

App-domain, According to my understanding is, like in the presentation layer, I am giving memory to at dll at run-time, on completion of operation, this is segregated from the presentation layer ? Please correct if there is any mistake.

modified on Thursday, March 31, 2011 7:13 AM

hi Can u please tell me the real life example for the begin init and end init utilization in datatable and in which situation it should be used. Thanks

In the stored procedure, I have a UDT table which have one column. and also a UDF(multi valued) that returns five columns , this UDF have one parameter of string type How can i call that UDF(multi valued) in the select statement ? like following mentioned. Select from tablename T Inner Join UDF(column) F on F.id = T.ID The ID is common column in both tables and also i want to create join between them

hi Ryan, Thanks for the reply. Actually i wanted to search 90% in a non consecutive way. Example the string to search is abcdef it's original length is 6 it's 90% length is 5. and i want to search any five characters from this 90% in a non consecutive way from the following records. "Search Matched" - Non matched because only 4 characters matched "Sabaschede" - matched and found five characters in it. can i do it without using any loop ? And I have millions of records, also have to consider it's performance

hi,

RyanEK wrote:

-- return 90% of a string declare @s varchar(6) set @s = '123456' select substring(@s, 1, cast(floor(0.9 * len(@s)) as int)) -- usage select * from [table] where charindex(substring(@s, 1, cast(floor(0.9 * len(@s)) as int)), [field]) > 0

Thanks for the kind attention. It will work fine if I have to start from position 1 only. But the string to search that I mentioned in the post. was abcdef and it's 90% can be abcde or bcdef similarly i can have larger strings as well and it's propability will be have more string to search. Is it possible to resolve it without any iteration ? Thanks

hi, I have to search 90% characters in a string. Suppose the string is "abcdef" and it;s character length is 6 and it's 90 percent character length will be 5 Now i have to search it's any 5 character in the following string string1 stringabcdef astrbincgdef Please suggest something ... Is there any way to do so with loop Thanks

I have to search keyword "searching" Out of this keyword i have to find any 8 characters in the following string "string to search" . Can u suggest any approach ?

hi

SELECT *
FROM Employees
WHERE (FirstName LIKE N'%ф3rcwvcwvcehveivewiuvgetiugheiheiogheighetighiogheioghioegheiowghioghi
oetjehbvjwebvjefbvjefbvjhebvfjkwbejkfbvjhebvjewbvbevjkewkjvjevfw
jhevfjhebvjefbvejwkfbvewjvbejwbvjefbvjewbvfjkebvjkefvbjefvbjefbvefw
ewvhbewjvbejvbejvfbejfvbjehfvbjewfbvjwefvbewjfvbejhvfbjkevbjhefbvefb
ewkljhvewfvekfjvekfvewkljfbvkejfvbkefbvkewfv%')

In the above query, I have more than 128 characters to search in like predicate, what should be in this case ? and the error message is The identifier that starts with is too long. Maximum length is 128.

Thanks for replying... If I have to search for keyword abcurlф in the table what should be the query in this case? Presently it is not displaying any result if i search even only with ф and displays those records which have ? character

hi, I was trying to update the Cyrillic characters · Serbian characters in sql server database, but everytime i shows ??? after updation Please suggest something. Thanks

I am using the dbml file for database tables in the project . My query is should i manually dispose these unmanaged objects whereever i use this class ?

Thanks it worked

normal. Suppose i send 9 rows to excel through datatable class. and the remaining 65000 are blank, i wanted to hide these blank rows

around 60,000 rows are blank, this means it will create performance issue

i am exporting the data to excel and finally i get the blank row below the data. I want to hide those rows without iteration

Is there any way to hide the blank rows in excel without using loop ?