Viewing 15 posts - 421 through 435 (of 452 total)
When we build an application, or even work with a platform like SQL Server, what' s the right balance between simplicity and choice? I'm not sure, but I think that...
December 7, 2009 at 12:58 pm
Technically speaking, the explanation for the answer is not correct. The explanation given is that SQL server ignores trailing spaces when comparing strings.
But in this example, SQL server isn't comparing...
December 7, 2009 at 11:24 am
Steve Eckhart (12/4/2009)
select cast(1.67574 as decimal(38,10)) = 1.675400000 which has precision 6 and scale 10, right?and
select cast(10000 as decimal(38,10)) = 10000.0000000000 which has precision 1 and scale 10, right?
wrong, and...
December 4, 2009 at 8:06 am
vk-kirov (12/4/2009)
Something about this can be found in BOL, topic "Precision, Scale, and Length (Transact-SQL)": http://technet.microsoft.com/en-us/library/ms190476.aspx
We have two numbers of type NUMERIC(38,10), so their precision = 38 and scale =...
December 4, 2009 at 8:00 am
I actually think Dan Linstedt had a good point, even if it was lost in the marketing-speke of the rest of his post. To wit: why do you have constraints...
November 23, 2009 at 8:36 am
duda (11/9/2009)
SELEC[T]...
November 9, 2009 at 8:01 am
jacroberts (10/27/2009)
October 27, 2009 at 9:17 am
Well, this question does provide one good bit of information.
Based on the answer %s at the time of of writing, I estimate than somewhere between 66% and 74%* of...
October 14, 2009 at 8:09 am
Tom Garth (9/30/2009)
SQL Server indexes are organized in a B-tree structure. The "B" in B-tree stands for what?
The question is specifically referring to SQL Server indexes. The Microsoft definition would...
September 30, 2009 at 10:43 am
Excellent article! I especially want to thank you for
I have not done a performance comparison of all the different methods. Each of the methods mentioned above has its own place....
September 25, 2009 at 8:45 am
Here are the two relevant statements from Books Online:
"Returns the value of the current timestamp data type for the current database." (in the definition)
"@@DBTS returns the last-used timestamp value of...
September 23, 2009 at 10:30 am
john.arnott (9/22/2009)
...
The important point here would seem to be that the environment from which a query is run can affect its output. I haven't tried embedding this sort...
September 22, 2009 at 12:19 pm
Chirag (9/3/2009)
This is what i did
begin tryEXECUTE sp_rename N'fakename', N'fakename2', 'OBJECT'
end try
begin catch
select @@ERROR
end catch
Yes. That will catch the error as it happens. So you determined the value of @ERROR...
September 3, 2009 at 6:59 am
Chirag (9/3/2009)
I found the question confusing. It asks for value of @@Error which is 15248. I put the statement in a TRY/CATCH and got the @@Error as 15248.
The question is...
September 3, 2009 at 6:02 am
Good article. I have a 3rd party app which will begin using the FILESTREAM attribute in the next major release, and this article gives me a good overview of how...
August 28, 2009 at 6:45 am
Viewing 15 posts - 421 through 435 (of 452 total)