First, let’s define what we need. We need a table (view) with these fields: ProductId, ProductName, ProductViewCount, and RootCategoryId. Imagine, the Category table has RootCategoryId field already. Then we can use this query to receive the result: SELECT P.Id AS ‘ProductId’, P.Name AS ‘ProductName’, PVC.ProductViewCount, C.RootCategoryId FROM Category C INNER JOIN ProductCategory PC ON PC.CategoryId … Read more
The two likely problems that I can see without you adding the error code. is that you are missing the column names in your insert statement. is that a user is putting an apostrophe in one of your text boxes. This is a SQL Injection vulnerability. Try something similar to this instead: using (SqlConnection con … Read more
In ServiceStack.OrmLite v4, as specified by mythz in the comments, everything should work as-is. In v3, if you want to have byte arrays serialized as binary instead of base 64 strings, you should inherit from SqliteOrmLiteDialectProvider and override the functions responsible for converting CLR values from and to SQL values to handle byte arrays. public … Read more
I’m assuming your datetime variable is a VARCHAR – this can be directly cast via CONVERT: Declare @YourVariable Varchar (15) = ‘JAN 01 1996’ Select Convert(Date, @YourVariable) 1996-01-01 2 solved Converting datetime variable format
Assuming that I understand the problem: you have a number of rows with sections (“Cates”) and symbols (“Type”); if there are any symbols ending in a minus sign then these indicate a row without a minus sign should be removed; symbols are never “mixed” per section, i.e. a section can never have “A” and “B-“; … Read more
First, I created a single table database to mimic the data structure: static void CreateAndSeedDatabase() { Context context = new Context(); TimeTracker entry1 = new TimeTracker() { UserId = 1, LoginTime = new DateTime(2000, 1, 1, 0, 0, 0), LogoutTime = new DateTime(2000, 1, 1, 1, 0, 0) }; TimeTracker entry2 = new TimeTracker() { … Read more
SELECT * FROM yourTable WHERE (FilteredPhoneCall.createdon >= dateadd(day,datediff(day,1,GETDATE()),0) AND FilteredPhoneCall.createdon < dateadd(day,datediff(day,0,GETDATE()),0)) OR (FilteredPhoneCall.modifiedon >= dateadd(day,datediff(day,1,GETDATE()),0) AND FilteredPhoneCall.modifiedon < dateadd(day,datediff(day,0,GETDATE()),0)) solved select yesterday date in where condition
In SQL Server, the update should start: update TBLSurvey set Status = -1 from TBLSurvey . . . The syntax for update in SQL Server is here. If I had to guess, it looks like you are confused with aspects of MySQL syntax. solved Incorrect syntax near the keyword ‘set’ and ‘as’ [closed]
Here is the query for the exact results you are looking for. select A.id, sum(A.sal + ISNULL(B.sal, 0) + ISNULL(C.sal, 0) ) sal from TableA A left join TableB B on A.id = B.id left join TableC C on A.id = C.id group by A.id Also, in case TableC or TableB were to contain records … Read more
This is for MS SQL Server. You can easily replicate this if you use any other RDBMS declare @email varchar(100) set @email=”[email protected]” select substring(@email,1,charindex(‘@’,@email)-1) 3 solved Select @ before values