Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 175819
4
votes
2answers
are selected: SELECT * FROM test123 WHERE ((ISNULL(c1,1) + ISNULL(c2,1) + ISNULL(c3,1) + ISNULL(c4,1) + ISNULL(c5,1)) < 2); I expect this query to return the 1st and the fifth row, but the result …
asked Apr 3 by sqlNewie
-1
votes
1answer
(ISNULL(c1,0)); or INSERT INTO #test123 (c1) SELECT CASE WHEN c1 IS NULL THEN 0 END AS c1; I receive both time the error "Invalid column name 'c1'." The Syntax (source) of INSERT INTO is: INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...); …
asked Apr 4 by sqlNewie