Viewing 11 posts - 136 through 146 (of 146 total)
well, you install it.
SQL Server installs at least 3 tools to let you work with the database.
First, the stand-by command-line tool, osql.
Next, the graphical equivalent (but it's WAYYYY better than...
August 4, 2004 at 2:46 am
Try to recompile the package in Oracle. If you're using a tool like TOAD, you can easily see the compile state of the package. Then, look inside the package to...
August 4, 2004 at 2:42 am
A bug with Access 2000 (and maybe 2002, but fixed in 2003) with linked SQL Server tables might cause a table that you've linked to, when you change data, to...
August 4, 2004 at 2:39 am
Yep. All of the expressions not used in aggregate functions need to be in the group by clause.
August 4, 2004 at 2:33 am
Hmm...
you could store it as an integer also:
cast(someintfield as smalldatetime)
ex:
select 1, cast(1 as smalldatetime)
1 1900-01-02 00:00:00
You can format the time part away for a datetime or smalldatetime...
August 4, 2004 at 2:31 am
DTSRunUI isn't redistributable, but of course, DTSRun is. You could script DTSRun in a VBScript.
It is also possible to add a couple of stored procedures to the database to run...
July 10, 2004 at 4:55 pm
I'm almost sure that ColdFusion is using ODBC to communicate with SQL Server, and ODBC mangles the SQL you might pass into it into its own version of SQL before...
July 10, 2004 at 4:50 pm
Maybe .Net 1.0 will work on Win95, but I'm pretty sure that .Net 1.1 won't.
You must have a compelling need to do this on Win95.
Can you upgrade the system to...
July 10, 2004 at 4:46 pm
Hmm... there are the NLSSORT and NLS_SORT functions to try as well...
As far as case-insentive searches and indexes... unless you're hitting a desktop database like Access, you probably can code...
July 6, 2004 at 2:58 am
assuming you're trying to run the script on your computer, the simplest way is from the command line:
C:\>osql -E -d mydatabase -i mysqlfile.sql
...of course, this implies that
C:\program...
July 5, 2004 at 9:34 pm
Are you sure you want to do a join? It almost looks like you want to do a UNION query, i.e.,
select id, column1, '1' as tblid
from table1
union all
select id,...
June 25, 2004 at 5:02 pm
Viewing 11 posts - 136 through 146 (of 146 total)