Viewing 15 posts - 1,741 through 1,755 (of 7,429 total)
Instead of quoted identifiers try changing using regular single quotes and remove from around the numbers the qutes altogether and see what happens.
June 25, 2004 at 6:54 am
Conditional sometimes shows when a statement contains statements lime IF, CASE or WHILE
June 24, 2004 at 1:14 pm
If in a select statement then
CASE WHEN @EmployeePhone is NULL THEN NULL ELSE '<EmployeePhone>' + @EmployeePhone + '</EmployeePhone>'
June 24, 2004 at 1:09 pm
Sounds like you are using VB. Becuae VB is single threaded in nature sometimes these are things you cannot overcome. Might try VB.NET or try under C++ which ou can...
June 24, 2004 at 1:07 pm
ExecuteWithResultsAndMessages2 is not required but make sure you provide a proper object for the Messages parameter.
object.ExecuteWithResultsAndMessages( Command , Length , Messages )as QueryResults
Ex. dmoDB is a Database object
Dim strMsg...
June 24, 2004 at 1:03 pm
If it doesn't parse successfully it will throw an error. However keep in mind it is Parse Only you are using.
So say I have a database object name dmoDB and...
June 24, 2004 at 12:57 pm
Unfortunately INFORMATION_SCHEMA views do not have that in their output. I do know there is at least one sp that will dor the trick (sp_help 'tablename') but I don't recall...
June 24, 2004 at 12:28 pm
We found xp_smtp_sendmail much easier (download here: http://sqldev.net/xp/xpsmtp.htm) especially since we didn't have to install an exchange server or have access on one to get up and running.
June 24, 2004 at 12:24 pm
Odds are someone added them to the model db and as model is the template they get added each time a new db is created automatically. Just remove them from...
June 24, 2004 at 12:16 pm
I have looked at this so many times and you hurt potential performnace doing this sort of thing. However that said you can do like so.
SELECT
field1, field2, … field30
FROM
table1
WHERE
(CASE @var
WHEN...
June 24, 2004 at 11:57 am
No, that is not the recommended way. That works fine as long as there is one page of data (less than 8k worth of data) but you can run into...
June 24, 2004 at 7:30 am
It just isn't allowed. Text can be used as a datatype only for SP variables for the input/output (really only as input) but you cannot set inside the SP itself....
June 23, 2004 at 9:22 pm
Not really, probably either a known issue or some bad programming. ANy specific details around this you can provide?
June 23, 2004 at 9:20 pm
Consider there are several factors at play.
1) If the field is fixed length or a non-null varchar column then the data has to resize in each row and page splits...
June 23, 2004 at 2:19 pm
This is what you are after
WHERE colName BETWEEN '20040101' AND '20040131'
If you want the month of January only.
Of you are being provided the date as mm/yyyy
Then contatinate to the date...
June 23, 2004 at 2:13 pm
Viewing 15 posts - 1,741 through 1,755 (of 7,429 total)