Viewing 15 posts - 4,381 through 4,395 (of 8,731 total)
The problem is that your date is not really a date. Is a numeric value that will be implicitly converted to a date to extract the year, month and day....
August 17, 2015 at 7:14 am
Simply use CONVERT( datetime, TheData) or CAST( TheData AS datetime).
Reference: https://msdn.microsoft.com/en-us/library/ms187928.aspx
FYI, datetime is not stored in any format. The formats are for display and the same value can be shown...
August 14, 2015 at 1:50 pm
Or you can go the other way around. :hehe:
SELECT *
FROM @JOIN_TABLE JT
INNER JOIN @TEST_PK PK
ON ...
August 14, 2015 at 12:28 pm
Lynn Pettis (8/14/2015)
Luis Cazares (8/14/2015)
Small correction, they're not there for backwards compatibility, but for SQL Standard compatibility.
True, but not every RDBMS implements them either. What good is a standard...
August 14, 2015 at 9:27 am
g.britton (8/14/2015)
August 14, 2015 at 9:04 am
Lynn Pettis (8/14/2015)
g.britton (8/14/2015)
What's the purpose of doing a cross join between the master.dbo.syscolumns table, and then not using it? Sorry, inquiring minds want to know.
to get enough numbers to...
August 14, 2015 at 9:02 am
Rod at work (8/14/2015)
What's the purpose of doing a cross join between the master.dbo.syscolumns table, and then not using it? Sorry, inquiring minds want to know.
Well, the point is that...
August 14, 2015 at 8:58 am
Ed Wagner (8/14/2015)
crookj (8/14/2015)
BL0B_EATER (8/14/2015)
Ed Wagner (8/14/2015)
SQLRNNR (8/13/2015)
Ed Wagner (8/13/2015)
DonlSimpson (8/12/2015)
SQLRNNR (8/12/2015)
Luis Cazares (8/12/2015)
WayneS (8/12/2015)
Ed Wagner (8/12/2015)
Ed Wagner (8/12/2015)
SQLRNNR (8/12/2015)
whereisSQL? (8/12/2015)
Ed Wagner (8/12/2015)
Eirikur Eiriksson (8/12/2015)
Ed Wagner (8/12/2015)
Steve Jones - SSC...
August 14, 2015 at 7:52 am
Small correction, they're not there for backwards compatibility, but for SQL Standard compatibility.
August 14, 2015 at 7:50 am
I agree with everything that Sean said. You need an UPDATE and probably a SELECT. That's when stored procedures come in handy, as you only need to execute one line...
August 14, 2015 at 7:44 am
Lynn Pettis (8/13/2015)
Another question, should I book now or still wait...
August 13, 2015 at 2:12 pm
I don't have an Oracle database to test against it, but it seems that you can insert and delete rows from Dual if you have Admin rights.
The fun part is...
August 13, 2015 at 2:05 pm
I realized that I have a lot of free time at work when I'm in the Top Members section for the last 30 days, thinking on writing a new article...
August 13, 2015 at 1:42 pm
Fill factor is not really defined by the amount of data in the table but on the rate of data modifications.
To generate some tests, I did the following:
IF OBJECT_ID( 'STATE_COUNTY_CODES')...
August 13, 2015 at 1:34 pm
Viewing 15 posts - 4,381 through 4,395 (of 8,731 total)