Access Query Tag
Is it possible to tag an access query with keywords like you can do in other MS applications?
Is it possible to tag an access query with keywords like you can do in other MS applications?
5 pts.
WRKQRY Security Flaw / Users can Alter/ Replace Data in Production Files
Can a user change or replace data, members, or the file itself (a prodcution file in a production lib) using WRKQRY...??? I have an auditor who believes in the "Define the Query" display, 2nd to last option ("Select output type and output form") you can specify 3 in the output type (3 = datafile...
Can a user change or replace data, members, or the file itself (a prodcution file in a production lib) using WRKQRY...??? I have an auditor who believes in the "Define the Query" display, 2nd to last option ("Select output type and output form") you can specify 3 in the output type (3 = datafile...
Saving the results of a SQL Server 2005 table query in a XML file
I have data in a table on a SQL Server 2005, and I need to query this table and save the results in a XML file that conforms to a given XSD. Is there an easy way of doing this?
I have data in a table on a SQL Server 2005, and I need to query this table and save the results in a XML file that conforms to a given XSD. Is there an easy way of doing this?
abort query handle 0001 is invalid
Has anyone see this error message before when running a query in Bex
Has anyone see this error message before when running a query in Bex
Current Date in Excel Query
I am using Excel 2003. I am trying to run a query that will used daily and the only thing that will change with the query is the current date. Is there a way to use a formula saved in the query that will automatically use the current date instead of having to manually input it everytime? Thank you!
I am using Excel 2003. I am trying to run a query that will used daily and the only thing that will change with the query is the current date. Is there a way to use a formula saved in the query that will automatically use the current date instead of having to manually input it everytime? Thank you!
Running a lengthy query on SQL Server 2005
We are running SQL Server 2005 and Windows 2003 Server. I ran a query in SQL on a PC with one dual code processor and 4GB and it took six hours. However, we ran the same query in SQL on a brand-new server that has 4 quad core processors and 32GB of RAM, and it took 12 hours. Why would this be?
We are running SQL Server 2005 and Windows 2003 Server. I ran a query in SQL on a PC with one dual code processor and 4GB and it took six hours. However, we ran the same query in SQL on a brand-new server that has 4 quad core processors and 32GB of RAM, and it took 12 hours. Why would this be?
Writing a specific query in SQL Server 2005
I have a table called "ticketing" and I want to bring from that table the record with the most current date. What kind of query should I write in SQL Server 2005 to bring up that result?
I have a table called "ticketing" and I want to bring from that table the record with the most current date. What kind of query should I write in SQL Server 2005 to bring up that result?
Access 2007 form from a query
I have an Access 2007 database that lists rules for specific types of systems. I've run the specific query to pull up the rules I need and put it in a form. The rules are un-editable and that is what I need but how do I get 1 field to be editable so the users can answer the questions posted by...
I have an Access 2007 database that lists rules for specific types of systems. I've run the specific query to pull up the rules I need and put it in a form. The rules are un-editable and that is what I need but how do I get 1 field to be editable so the users can answer the questions posted by...
Toggling a case sensitive query in SQL Server 2005
It appears that my queries of stored procedures, tables, columns, etc. are case sensitive in SQL Server 2005. Is there a “case sensitive” option that I can toggle on and off?
It appears that my queries of stored procedures, tables, columns, etc. are case sensitive in SQL Server 2005. Is there a “case sensitive” option that I can toggle on and off?
Increasing the performance of a slow query in SQL Server 2000
I am using SQL Server 2000 SP4 on Windows 2003 Server, and I am having a problem with my queries. One of them was running fine a couple of weeks ago, but all of a sudden it is taking considerably longer to process than it used to. How might I resolve an issue like this from the database?
I am using SQL Server 2000 SP4 on Windows 2003 Server, and I am having a problem with my queries. One of them was running fine a couple of weeks ago, but all of a sudden it is taking considerably longer to process than it used to. How might I resolve an issue like this from the database?
Looking for a database name query in SQL
Is there a query in SQL that could return me the name of a database, or whether it is connected to SQL Server or Oracle?
Is there a query in SQL that could return me the name of a database, or whether it is connected to SQL Server or Oracle?
Is there a quick way of running a query to select records based on" current sysdate - 1" i.e yesterday.
Is there a quick way of running a query to select records based on current sysdate - 1 ie yesterday. Using Martin Gilbert's suggestion I get the current date & it works perfectly CD CHAR(CURRENT(DATE)) CURDAT SUBSTR(CD, 1, 2) || SUBSTR(CD,...
Is there a quick way of running a query to select records based on current sysdate - 1 ie yesterday. Using Martin Gilbert's suggestion I get the current date & it works perfectly CD CHAR(CURRENT(DATE)) CURDAT SUBSTR(CD, 1, 2) || SUBSTR(CD,...
Copying a SQL Server stored procedure with a query
I want to copy a SQL Server 2005 stored procedure by using a query, much like the way a table is copied with one. Does a query exist that could perform this task for me?
I want to copy a SQL Server 2005 stored procedure by using a query, much like the way a table is copied with one. Does a query exist that could perform this task for me?
Using co-related queries in SQL
How do you use co-related queries in SQL and why would they be useful? Is there any effect on performance when executing a co-related query?
How do you use co-related queries in SQL and why would they be useful? Is there any effect on performance when executing a co-related query?
how to access the p2p networks in a simple client
can p2p network (emule bit torrent or kad network) can be queried with a native client as telnet ? if so, where can this query syntax are documented ? (white paper or an ISO ref. documents)
can p2p network (emule bit torrent or kad network) can be queried with a native client as telnet ? if so, where can this query syntax are documented ? (white paper or an ISO ref. documents)
mdb talk to jdbc
is it possible to make an inner procedure in (any) jdbc db that will produce simple p2p connection with another db for example a mdb, this is highly needed that the other db will be a flat file (mdb), if you know any way to create connection through another db, with a non-java db (not a jdbc...
is it possible to make an inner procedure in (any) jdbc db that will produce simple p2p connection with another db for example a mdb, this is highly needed that the other db will be a flat file (mdb), if you know any way to create connection through another db, with a non-java db (not a jdbc...
Can SQL make noises?
can you get SQL to 'make a noise' to indicate when a query has been executed? I.e. for long running queries, you wouldn't have to keep checking
can you get SQL to 'make a noise' to indicate when a query has been executed? I.e. for long running queries, you wouldn't have to keep checking
Combined Address
I have one tblContacts that has "Home" and "Work" address included within it, I also have an option button 1="Work" and 2="Home". I need to prepare a mailling report, but only for the defaut address. Someone suggested that I create a calculated field. I tried this but all that it is doing is...
I have one tblContacts that has "Home" and "Work" address included within it, I also have an option button 1="Work" and 2="Home". I need to prepare a mailling report, but only for the defaut address. Someone suggested that I create a calculated field. I tried this but all that it is doing is...
Is there a query to search text of all SQL Server database objects that reference a specific table/instance?
We want to migrate to SQL Server 2005. We need to find all database objects such as Stored Procedures, Views, Triggers, User Defined Functions accessed specific tables, DTS packages that reference a specific table/instance. Is there a query that will allow me search the text of all?
We want to migrate to SQL Server 2005. We need to find all database objects such as Stored Procedures, Views, Triggers, User Defined Functions accessed specific tables, DTS packages that reference a specific table/instance. Is there a query that will allow me search the text of all?
