There are several good resources for MS SQL.
www.sqlmag.com
and
www.sqlservercentral.com
are the two that I like best.
For the logins, what OS are you using? For external users, you will
likely need SQL accounts, and if the internal accounts are using an MS
OS, you can use their Windows
You can use the group by and having clause:
use test;
drop table if exists duptest;
create table duptest(
x int
, z varchar(25)
) type=innodb;
insert into duptest(x, z) values(1, 'Val1');
insert into duptest(x, z) values(2, 'Val2');
insert into duptest(x, z) values(3, 'Val3');
If I understand your question correctly, you're wanting to grab the
records where the date is greater than or equal to a date plus 7 days.
If so, then:
SELECT * FROM myTable WHERE date_field = CAST('2003-10-19' AS DATETIME)
+ 7
Or you can use the DATEADD function:
SELECT * FROM myTable WHERE
Oops, you are subtracting the date, so use - 7 instead of + 7...
Dan
-Original Message-
From: Dan Lampkin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 5:05 PM
To: 'DevList'; 'mySQL Mailing List'
Subject: RE: mysql to mssql query
If I understand your question correctly
Hello All,
I've looked online and searched through many threads in the lists and
can't find a good reference for the cnf file. I've found the page with
the command line options, but there are options I see in the list
threads that aren't in the page.
Is there a reference that lists all of