Viewing 15 posts - 3,826 through 3,840 (of 6,035 total)
This is not a MS Access forum and a database is not a bowl of fruit, but here is how you exclude specific rows from a SQL query.
select Fruit
from...
May 27, 2015 at 3:03 pm
GETDATE() returns local time and GETUTCDATE() returns UTC time.
May 27, 2015 at 2:58 pm
One of the advantages of a medieval style IT shop, where the rules are not spelled out on paper, is that you as the DBA can simply lord it over...
May 27, 2015 at 11:48 am
Depending on the organization, I'm not opposed to allowing Developers read-only access to production, especially if they are expected to wear the Data Analyst hat on occasion. Even more advanced...
May 27, 2015 at 10:57 am
dlsilsbury 63952 (5/21/2015)
...Out of interest how do you mark a view as a system view?
No. System views are those distributed with SQL Server. There is rarely a reason to mark...
May 27, 2015 at 9:24 am
Kyrilluk (5/27/2015)
Eric M Russell (5/27/2015)
Jeff Moden (5/27/2015)
Kyrilluk (5/27/2015)
Eric M Russell (5/26/2015)
Kyrilluk (5/26/2015)
May 27, 2015 at 8:06 am
Kyrilluk (5/27/2015)
Eric M Russell (5/27/2015)
Kyrilluk (5/27/2015)
Eric M Russell (5/26/2015)
Kyrilluk (5/26/2015)
May 27, 2015 at 8:01 am
Jeff Moden (5/27/2015)
Kyrilluk (5/27/2015)
Eric M Russell (5/26/2015)
Kyrilluk (5/26/2015)
May 27, 2015 at 7:50 am
Kyrilluk (5/27/2015)
Eric M Russell (5/26/2015)
Kyrilluk (5/26/2015)
May 27, 2015 at 7:29 am
robin.pryor (5/26/2015)
May 26, 2015 at 1:23 pm
Luis Cazares (5/26/2015)
Eric M Russell (5/26/2015)
A simple CAST operation from date/time to date won't necessarily prevent usage of an index on a date/time column. For example, given the following table...
May 26, 2015 at 11:33 am
I'm not understanding your usage of that WHERE clause.
The syntax for a joined update is basically the following:
UPDATE A
SET ..
FROM A
JOIN B ..
WHERE ..
May 26, 2015 at 11:27 am
You can also reference scalar user defined functions within check constraints.
May 26, 2015 at 11:03 am
Confirm there is not a trigger on this table, or some other change data capture mechanism, that inserts into an audit table for which the datatype of Age is still...
May 26, 2015 at 11:00 am
Lynn Pettis (5/26/2015)
itortu (5/26/2015)
SELECT orderno
FROM _order
WHERE CAST(FLOOR(CAST(order_date AS FLOAT)) AS DATETIME)
BETWEEN CAST('5/14/2015' AS DATETIME)
AND CAST('5/15/2015' AS DATETIME)
ORDER BY order_date asc
The...
May 26, 2015 at 10:51 am
Viewing 15 posts - 3,826 through 3,840 (of 6,035 total)