I have a few questions to ask about SQL and I need clarification. If I'm running SQL on my server and I want to backup my database, can I not just goto the "Data" folder and just copy the con...
I need to put together a list of all of the table field names in my 2003 MS Access database. How can I easily do that?
I want to create a pretty diagram in Visio 2003. I don't care about the diagram linking back to a real database (in SQL Server). I have some DDL SQL script for several tables that I want to g...
Hi,
I'm just beginning with triggers...
I've got a trigger that updates 'modify_ts' on the 'product' table after a update, but I want it to update the 'modify_ts' of the 'product' table ...
Strangely enough, as powerful as MS SQL Server 2000 is, it is also that difficult sometimes to find solutions for its quirks. I need help with the following issue dealing with the System.Data....
Hello experts,
I have a column that has names. The names is in a format like this:
"LastName,FirstName"
I would like to add a space after the comma. Do any of you know the syntax to...
How to alter my sequence so that last value of sequence should be one more than the max value value of primary key cloumn of the table.
It seems i need to have a procedure which will alter al...
Hi,
I am working on Oracle environment and need to propose to my management which tool out of the two Toad for Oracle Professional Vs PL/SQL developer is better. Can someone throw some insig...
I am trying to set up SQL state for ASP.NET on a Windows 2003 server with MS SQL server 2005. I am getting this error:
Cannot open database "ASPState" requested by the login. The login fail...
Hi Experts
Is there a way to import, reliably, a System DSN from another computer?
Thanks.
I would like to use an Access-style "COUNTIF" SQL function that counts the number of records in a returned dynaset based on condition. For example:
COUNTIF(NAME,"JONES")
Where COUNTIF is...
I am trying to do a simple isnert statemtn on an ACCESS database from .NET, I ahve tried passing it a DateTime Object as a parameter as well as changing it to a string format. When I do a sele...
Good day
Can u please assist with the ffg:
I have a table that stores data in columns
adhoc eg
DATE NAME MARK1 MARK2 MARK3 MARK4 ........ MARK24
AUG R...
Hi Experts,
I would like to clear the log file of a database in SQL Server 7.0.
The problem is that the data file for my database is only 200 MB but the logfile for the same database is a...
I am trying to call a stored procedure from Crystal Reports and I'm passing a parameter. I need the parameter to be a uniqueidentifier datatype, but it is being treated as a varchar. Is there ...
I'm hoping the solution to this is something really easy that I'm just overlooking. Currently I'm using DTS to load data from a comma delimited CSV file into temporary tables which are then c...
I have this assignment and I was wondering how would I write the program...
So far I have...
#include <iostream>
#include <stdlib.h>
#define Number 15
struct coffee{
char month [10]
...
Hi ,
One of my friends is preparing for an interview - data warehouse . Can any one help me with some questions .Pls is urgent
Thanks,
Taly:)
I want to create a batch file taht will register a system DSN for use with an ASP web app
basically
I need it to connect using SQL Server Driver
DSN = test
uid = test
pwd = pwd
Serve...
Hi All,
Can someone can explain me what is the cardinality of a database table? How de we specity the Cardinality of a table in a Database Design Report?
Thanks in Advance,
Regards,
Badri.
Hello,
I am trying to at least connect to the database on our AS400. After I am able to do that I would then like to be able to run UPDATE or INSERT to the AS400 from the MS SQL Server...
Hi,
Does anyone know what the equivalent to decode() (which is used in Oracle ) for MS Access.
Thank you,
Attachie
one field - varchar(10) - contains a whole bunch of this:
98.75
9803.00
98030.00
99.05
.71
.70
.00
i MUST cast as decimal asap. i tried this:
cast(field as decimal(18,2))
...
Hi Dear Experts, I am facing the following error: [Microsoft][ODBC SQL Server Driver][SQL server]Cannot open database requested by the login. the login failed when i call the following command...
Ok this is from a storefront and it is apparently trying to update the database. but here is the entire error.
Error Diagnostic Information
ODBC Error Code = S1000 (General error)
[Mi...
