H. Pauwelyn
  • Member for 6 years, 8 months
  • Last seen more than a week ago
Invalid column name
Accepted answer
3 votes

I've found it! The code must be this: ;WITH rs AS ( SELECT Id FROM AspNetRoles WHERE Minimum >= (select punten from AspNetUsers where id = 'abc') ) INSERT INTO AspNetUserRoles (...

View answer
alter authorization in SQL Server
Accepted answer
2 votes

I have found it whit a hint from @JeffersonB.Elias. I've execute this code: ALTER AUTHORIZATION ON DATABASE::FreeTimeDBSSA TO sa; GO

View answer
How to add the two values from different columns in SQL
2 votes

Try this: SELECT val1 + val2 AS sum FROM table If you will select the two original columns and the sum: SELECT val1, val2, val1 + val2 AS sum FROM table

View answer
Operand data type time is invalid for add or subtract operators
0 votes

A thing you could do without changing the datatypes is to convert form hh:mm:ss to the decimal representations. For that you can Create a function for calculate time to float: create function ...

View answer