Search results for query: *

Hi, People, I need to write a query in SQL Server that groups together different elements from a column using some separator like a comma. I have a table that is more or less like this: ++++++++++++++++++++++++++++++++++++++++++ + department1 + John + + department1...

Hi. I am sending e-mail using ASP.NET 2.0 with MailMessage and SMTPClient objects. Everything works fine and the e-mail is sent normally. I get the message in my e-mail box. The problem is that my main customer does not get it. Here is the answer from his server: "Status: 5.5.0...

Hi. I want to query my database with a string and I want SQL Server to see common letters and letters with accents as the same thing. I need it to see "análise" and "analise" as the same thing so that when I query "análise" in the text box, all results are returned, including "análise" and...

Hi. Sorry if it is a silly question. I want to build a conditional WHERE clause for a stored procedure. My procedure has some attributes like @param1 @param2 These params correspond to filters in my web application. If users select an item from a ListBox, the application will populate these...

Hi. Recently I noticed that when ordering rows in a text column, SQL Server will put "A Place to go" before "Abort", for example. It considers the white space as a character that comes earlier than any other letter. Well, I don't know if that is a rule when ordering elements in english, but in...