SQL: IF clause within WHERE clause
Use a CASE statementUPDATE: The previous syntax (as pointed out by a few people) doesn’t work. You can use CASE as follows: Or you can use an IF statement like @N. J. Reed points out.
sql-server
XOR in SQL Server
You can implement a XOR like this – don’t forget that the question will require you to use <= to correctly use the XOR operator:
How do I fix the error ‘Named Pipes Provider, error 40 – Could not open a connection to’ SQL Server’?
Solving this problem is very easy: Go to control panel. search for services. Open Local services window from your search results Restart your MSSQLSERVER service. Screenshot of the steps:
Format number as percent in MS SQL Server
M.Ali’s answer could be modified as
How do I format a number with commas in T-SQL?
In SQL Server 2012 and higher, this will format a number with commas: You can also change 0 to the number of decimal places you want.
Subtract one day from datetime
Try this OR
sql query to return differences between two tables
IF you have tables A and B, both with colum C, here are the records, which are present in table A but not in B: To get all the differences with a single query, a full join must be used, like this: What you need to know in this case is, that when a record can be found in A, but not in B, … Read more
Regex pattern inside SQL Replace function?
You can use PATINDEX to find the first index of the pattern (string’s) occurrence. Then use STUFF to stuff another string into the pattern(string) matched. Loop through each row. Replace each illegal characters with what you want. In your case replace non numeric with blank. The inner loop is if you have more than one … Read more
Why SQL Server throws Arithmetic overflow error converting int to data type numeric?
Numeric defines the TOTAL number of digits, and then the number after the decimal. A numeric(3,2) can only hold up to 9.99.
Is there a Max function in SQL Server that takes two values like Math.Max in .NET?
You’d need to make a User-Defined Function if you wanted to have syntax similar to your example, but could you do what you want to do, inline, fairly easily with a CASE statement, as the others have said. The UDF could be something like this: … and you would call it like so …