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. c:/path/to/file/filename), or if I need
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.