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 111282

SQL Server 2008 R2 (major build version 10.50.xxxx). Please also tag with sql-server.

2
votes
2answers
I found this syntax already answered to a diff question, but I am getting the error of More than 1 result returned what do I need to alter in my syntax in order to defeat this error? Declare @O …
asked Feb 9 '17 by StarsFlyFree FromCozyNights
0
votes
1answer
I keep getting an error of Conversion failed when converting date and/or time from character string. when I run my query. How should this be altered in order for the query to execute succesfull …
asked Nov 23 '16 by StarsFlyFree FromCozyNights
2
votes
1answer
I am attempting to do a calculation in SQL Server 2008 and I am getting incorrect results. Below is sample DDL and the query that I used, how should my statement be re-written in order to produce the …
asked Dec 18 '16 by StarsFlyFree FromCozyNights
0
votes
1answer
My syntax below works (may not be the most efficient syntax, but it almost serves the purpose). The issue that I have with it, is that when the UPDATE statement is run, due to the JOIN condition each …
asked Feb 6 '17 by StarsFlyFree FromCozyNights
0
votes
1answer
I am passing a parameter to a dynamic sql string and have the parameter properly encompassed in ' marks to work in my dynamic sql. However, now I am needing to use the value in a diff location in my …
asked Nov 26 '16 by StarsFlyFree FromCozyNights
1
vote
3answers
I am attempting to use MAX() in my WHERE clause but I am getting an error of Msg 4145, Level 15, State 1, Line 10 An expression of non-boolean type specified in a context where a condition is ex …
asked Feb 1 '17 by StarsFlyFree FromCozyNights