Insert T (T1) values(‘Check = 1010 mohan = 25’) Now I should just update the 25 as 35
databaseanswers.net Latest Questions
My database table looks like this: id articleId createDate modifiedDate content 1 145 01.01.2021 01.01.2021 blabla 2 145 01.01.2021 02.01.2021 blabla 3 145 01.01.2021 03.01.2021 blabla 4 146 02.10.2021 02.10.2021 blabla 5 147 05.04.2021 05.04.2021 blabla 6 147 05.04.2021 07.04.2021 blabla So if a content is updated and saved again, then it is saved again in DB with modified date and same articleId. What I’m try to get is all content (latest ,not repeated) ...
I have a scenario where I have one table like this This is basically a CRM connection where one entity can be connected to several entities which are further connected ...
Input: When Process ID = 610 ID Value 50 2 60 16 // 2 80 128 I have two separate queries that fetch two values from the same table so I am trying to merge them together instaed of calling the table twice. select [serialno],[storedatetime], [value1], [value2], ...
I am trying to dmatching users based on similar conditions. For example, if I have an userId of 1 and I have some goals like ‘weight loss, Burn fat, etc’ and in the matching API what I will do is ...
i want to get data for date x to today, but error, why this query error, give me explain, because declare @aging as datetime set @aging = '6/20/2022' and @aging in (Select Getdate ()) Declare @agingEOM as datetime set @agingEOM ...
I want to change the names of some tables primary keys, somebody experienced problems with it ? Like Performance, drawbacks, etc ?
I want to filter customers who come in the first week only and for new customers who come for the first time in the following week will not be included. For example, I have data like this: CustomerID CustTrans Weeks C001 2022-09-03 36 C002 2022-09-02 36 C003 2022-09-03 36 C004 2022-09-02 36 C002 2022-09-08 37 C001 2022-09-05 37 C002 2022-09-11 38 C002 2022-09-23 39 C004 2022-09-19 39 C001 2022-09-18 39 C003 2022-09-26 40 C005 2022-09-17 38 C006 2022-09-25 40 C001 2022-09-25 40 For the code ...
I have a task to compare (like Excel) content in 2 versions. Content is defined as a set of columns (field_id), which can have 1 or more positions with values (string_value). I am trying to join one table (SOURCE) with itself where ...
My value is ABC005/2022 how can i split this and get value only 005 in value from this? Column_Name 1 ABC005/2022 2 ABC006/2022 3 ABC007/2022 how can i get only like this? GetValue 1 005 2 006 3 007