I am trying to save ThinSpace (u2009) to the database using ADO.NET classes, but instead I am getting “?” symbol in db in place of ThinSpace. String that I save to db in UTF8 format. var …
Tag: c#
How To Convert Linq To Sql?
I want write code for table, I know in SQL Server, but I don’t know Linq or EF. SQL Server code: SELECT * FROM Driver WHERE id IN (SELECT Driver FROM Drive_Car WHERE …
sql select group by int()
I want to get int using this query: “SELECT int(Abs(x1-x2)+0.5) AS len, Count(*) AS num FROM Coordinates GROUP BY int(Abs(x1-x2)+0.5) ORDER BY int(Abs(x1-x2)+0.5) ASC;”; int …
Reference to multiple rows entity-framework?
How can I reference my column in table1 to multiple rows of another table in entity-framework work with custom navigation properties? this problem can be solved in SQL with a temp table which is …
How to get error from “SQLCMD” through c#?
Running SqlCmd utility using C# this way : // Calls the sqlcmd ProcessStartInfo info = new ProcessStartInfo( “sqlcmd”, @” -S VDSS218 -i D:RaviBlank_Database_Creation_script.sql”)…
Select one of each matching results from group last record from date
I have multiple customers that are a part of a group designated by a group id. I would like to retrieve 1 record from a related table for each of the matching group members (last record before a …
Assigning multiple rows to a single row of different table SQL
Is it possible to assign several rows to a single row of a different table? Doing purchase order I have a table for Suppliers then under that I have items that are in the different table. Giving me …
MySQL – save base64 encoded data to storage drive
I’m building an app that uses a temp table where chunks of a file are uploaded to, then a stored proc is called with a function that reassembles the file into the right order. I’m just wondering if there’s anything in SQL that would allow me to outright save the reassembled file to disk (eg.…
Join multiple tables and single output using Entity Framework mvc5
I am very new to linq query so I need to join multiple tables and single output using Entity Framework mvc5 Below is my 3 table structures and Table_Application is a main table 1) Table_Application …
How do you return the max of a column (Text field)? [closed]
I can not find a way to execute the following simple query: SELECT max(@SomeCol) FROM test_table; I can do just about everything else except for that, max doesn’t return what I expect.