|
- What is the difference between . text, . value, and . value2?
Using Value or Text is usually a bad idea because you may not get the real value from the cell, and they are slower than Value2 For a more extensive discussion see my Text vs Value vs Value2
- How to return the output of stored procedure into a variable in sql . . .
I want to execute a stored procedure in SQL Server and assign the output to a variable (it returns a single value) ?
- Shortest way to check for null and assign another value if not
Shortest way to check for null and assign another value if not Asked 15 years, 11 months ago Modified 10 months ago Viewed 399k times
- sql - How to select only the first rows for each unique value of a . . .
In the table, one customer like John Smith can have multiple addresses I need the SELECT query for this table to return only first row found where there are duplicates in 'CName' For this table it should return all rows except the 3rd (or 1st - any of those two addresses are okay but only one can be returned) Is there a keyword I can add to the SELECT query to filter based on whether the
- How to query for Xml values and attributes from table in SQL Server . . .
How do i get the "value" of the node itself? There seems to be no way to select m * to see the secret, magical, intermediate table it constructed What's the syntax to query the value of an element? e g the value of <Metric>8675309< Metric> is "8675309"
- whats the largest number float type can hold? - Stack Overflow
I'm new to programming and have recently come up with this simple question float type has 32 bits in which 8 bits are for the whole number part (the mantissa) so my question is can float type hold
- What exactly is GUID? Why and where I should use it?
GUID technically stands for globally unique identifier What it is, actually, is a 128 bit structure that is unlikely to ever repeat or create a collision If you do the maths, the domain of values is in the undecillions Use guids when you have multiple independent systems or clients generating ID's that need to be unique For example, if I have 5 client apps creating and inserting
|
|
|