Aetos2501's questions

I am using the STRING_SPLIT function to generate rows from a scalar value @ValueData VARCHAR(512) = "One, Two, Three" as follows

In my development database it works perfectly but in production I can't run it because I can't alter the COMPATIBILITY_LEVEL of the database. I would also like to learn an alternative way to do this without using a function.

I am trying to detect when a Word or PDF document is different from the version that is loaded, I have a form in which a document is loaded through an OpenDialog which can be replaced. I do not have a method to detect if the new version that the user loads actually contains changes. If the user wants to replace the document, it is necessary to change the name so that it is replaced in another way. If the document that he wants to replace has the same name as the new one, he did not replace it.

Could you do it through a checksum or some hash of the documents and compare them?

In my WPF project I am trying to make the application icon on the taskbar blink using the following post: https://stackoverflow.com/questions/8924556/force-window-to-blink-when-a-particular- event-occurs-in-c-sharp-wpf

But when I call the method FlashApplicationWindow(); it sends me the following error

The calling thread cannot access this object because the owner is another thread.

Try sticking the call to FlashApplicationWindow(); inside BackgroundWorker but still throwing the same error.

Can someone help me how the call should be made please?

Can a project that necessarily has to be in Net Framework 4.0 be included in a solution that has all its projects in Net Framework 3.5?

The NetFramework 4.0 project implements SignalR and therefore cannot be downloaded from the Framework.

I recently came across the following code which generates a QueryString URL which I can't understand, since the generated URL is " http://localhost/?q=samsung " Where "q" is the name of the parameter, which by testing is the name of the TextBox. My question is: How does Razor know that it should take the name of the TextBox to generate the QueryString using the name of said TextBox, is there a convention or something similar? Thank you very much in advance

 <form method="get" action="@Url.Action("Index")">
        @Html.TextBox("q", Model.Search.FreeSearch)
        <input type="submit" value="Search" />
    </form>

The following query shows me a

error Conversion failed when converting the varchar value 'IF EXISTS' to data type bit.

I don't know how to solve it, column4 is of type BIT but sometimes I want to obtain the type bit and sometimes I want to obtain a text so that it has more meaning for the user, I control that with a variable called @TextoOrBit.

Thank you very much in advance for your support and if you can guide me on how to obtain the desired result.

DECLARE 
   @TextoOrBit BIT

SET @TextoOrBit = 0;

 SELECT 
   COLUMNA1,
   COLUMNA2,
   COLUMNA3,
   CASE @TextoOrBit 
      WHEN 1 THEN 
          CASE COLUMNA4 WHEN 1 THEN 'SI EXISTE' ELSE 'NO EXISTE' END
      ELSE 
          CASE COLUMNA4 WHEN 1 THEN CAST(1 AS BIT) ELSE CAST(1 AS BIT) END
   END AS  COLUMNA4_custom
 FROM
   TABLA_DATOS

I have an existential doubt about the order of execution of SQL statements , specifically in the union of related tables. FROMFirst the after the clause is executed ONand after INNER JOINeach table?. If someone could enlighten me as I frequently get wrong results in my queries and I want to understand this part of the order of execution. Thank you all in advance.

    SELECT h.SalesOrderID,
           h.OrderDate,
           h.SalesOrderNumber,
           h.TotalDue,
           d.ProductID,
           d.LineTotal,
           p.Name
      FROM AdventureWorks.Sales.SalesOrderHeader AS h
INNER JOIN AdventureWorks.Sales.SalesOrderDetail AS d
        ON h.SalesOrderID = d.SalesOrderID
INNER JOIN AdventureWorks.Production.Product AS p
        ON d.ProductID = p.ProductID

Hello friend I have a problem with a table I have a field called names inside this table and I have a list of names which I want to exclude from the table based on the name field. I have the following but it doesn't work for me.

var DataRows = Tabla.AsEnumerable().Where(item => item["Nombre"].ToString().Distinct().Where(nombre=> ListaNombres.ForEach()))

Friends, I come across that word "Handlers" (manejador in Spanish). What are they used for or what relationship do they have with the delegates? If someone could guide me about what topics to read related to Handles or some examples, I would appreciate it.

The truth is that it causes me a lot of confusion to see this type of operators, I don't know what it means or why it is placed.

checkedit1.CheckStateChanged += CheckValorSi_CheckStateChanged;