Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Unable to add date to access database
- Hi I am trying to add a date field from vb 2005 to access database. However when I try to run the following code I gets error message that reads "Syntax error in INSERT INTO statement." Any help regarding this is highly apprecited. [code]Imports System.DataImports System.Data.CommonPublic Class Form1 ...
- Tags: Databases, database, hemant.mukherjee@..., Table1, ByVal
- Discussion threads 2007-10-28
- Performance Issue using left or substring function in Sql Server2005Express
- Hi, I've tried the following query in SQL SERVER 2005, SQL Express 2005 and MACCESS. select * from Table1 where drid in (SELECT DrID FROM Table2 WHERE (substring(PostalCode,1,3) IN ('B0E','B1P','B2H','B2Y','B3A','B3M','B4A','B4H','E1A','E1C','E1N','G0A', …)) and (substring(Telephone,1,3) IN ('204','250','306','403','416','418','450','506','514','519','604','613','705','780','807','819','902','905'))) The query is using two table. The first one...
- Tags: Databases, desbiens_mathieu@..., performance, MACCESS, Table1, Microsoft SQL Server, Table2, execution time, SQL, Microsoft SQL Server 2005
- Discussion threads 2007-10-22
- Join a query with one of the Tables used to generate the query
- Hi to everybody,I would like to know if it's possible to do this in MSAccess SQL:Select * FROM (table1 LEFT JOIN table2 ON table1.field1 = table2.field1) LEFT JOIN table2 ON table1.field2 = table2.field1Note that table2 is being used twic
- Tags: join, sql, programming, access, software, microsoft, windows, Table2, LEFT JOIN, rayasta@..., Table1, Table1.field1
- Discussion threads 2006-12-13
- Passing parameters from VB6 to SQL
- Dim intVal as Integerintval = 2020qconn.Execute("Select * from Table1 where userid=intval")The question is how can I make sql recognize or accept intval as a predefined variable in VB6 and run the query with resultset based on the value of intval?You need to ensure that the substitution takes place before the...
- Tags: Table1, SELECT
- Q&A 2005-11-10
Additional Resources
- Raffle Tickets
- I want to have it so that if some one pledges £5 on one table. At the click of a button another table is updated with 5 tickets allocated to this person.check out how this is done with the indispensible northwind.mdb sample database free for download from microsoft. the really...
- Tags: simonevans31@...
- Q&A 2005-01-26
- Nested Select statements
- Has anyone ever used a statement like this:Select column1, column 2, (select columnA from table2) from table1 where....?This is contrary to anything I have ever seen in SQL (especially ANSI/ISO SQL), and I would appreciate your comments. ThanksSKNo I haven't, not once in in 17 yearsmore to the point...
- Tags: Databases, shelley.kuebler@...
- Discussion threads 2007-11-19
- SQL code in vb join > 3 tables
- how do i code in vb6 joining 3 or more tables in. it would be ver helpful oif you can help. thank you..SELECT whateverFROM (table1 LEFT JOIN table2 ON table1.key=table2.key)LEFT JOIN table3 ON table1.key=table3.key;
- Tags: LEFT JOIN
- Q&A 2005-07-18
- Trouble Querying Database
- I have a table with a list of issues includes duplicates associated with a file name. There is a separate query that's linked to this table by file name and includes about 10 calculated fields associated with the file name no duplicates. I would like to create a query that...
- Tags: CR2
- Discussion threads 2006-08-16
- Access Query
- Hi all, hoping you can help me with a probably simple task.In running a query i would like to be able to submit any amount of a parameter to bring back all information related to one or many ObjectID's.Any ideas how i can perform this task?Sample code looks likeSELECT Field1,...
- Tags: jim@..., Microsoft Access
- Discussion threads 2007-03-16
- Access-AutoNumField on ImportSpec
- How do I add an AutoNumber Index Field on the Import Specification in MS-AccessChris, you can't add an autonumber field to an import spec.You need to add the field after the importrun imporrt then to add an autonumber to your table run the following SQL, modifying as required.alter table table1...
- Tags: Field1
- Q&A 2005-06-27
- multi-table with alias
- I've got a database with numerous tables. I want to do a query that is like:Select projnum, projtitle, projmgr, projclerk fromProjects inner join people where people.peoplecnt=projects.projmgrI get that part to work. Now the projmgr and all other people assoc with the project are in the people table...
- Tags: SELECT
- Discussion threads 2005-03-23
- Do comments slow down PL/SQL?
- I'm not sure where this started, but at work there's this rumor going around that if you put too many comments in an Oracle PL/SQL package, it impacts performance. That is, the more comments in your code the slower it runs. I could kind of understand if...
- Tags: Method, PL/SQL, Programming Languages, Performance Management, Databases, Software Development, Software/Web Development, Human Resources, Workforce Management, Enterprise Software, Software, Data Management, Rex Baldazo
- Blog posts 2007-09-22
- create select query with diff. mdb files
- i created two ms access database to hold my data.how can i create a select query that will include the table from the other database?can someone please help me..............?any strategies/techniques/ideas will sure be of help.thanks.You need two Queries. One with Select command for one table, other with select command for...
- Tags: Storage, Databases, database
- Q&A 2006-01-06
- Oracle Bitmap Index
- I have a oracle bitmap index.I have used the script create bitmap index idx1 on table1 columns;but while running SPs the index takes more than 28 GB. I sthere any method to compress the space used.
- Tags: shibi.v@..., software, programming, oracle database, Oracle Corp.
- Discussion threads 2007-02-05
- Search and Replace Using SQL Oracle i9
- Can anyone show me a easy way to do a find and replace using SQL Oracle i9ExampleSelect row1From table1Find ‘123”Replace with ‘ABCThank you for your help
- Tags: Programming languages, Corey_56044@...
- Discussion threads 2007-04-17
- Reset ID Autonumber counter field on Table in Access
- Hi, I import data from a text file into an existing table. The text file has no column headings, so I delete all records from my existing table and populate it with data from the text file each tim. I need the ID autonumber field. However, the...
- Tags: chris.chetty@..., DAO, ID, ID Autonumber, Microsoft Access, software, SQL, text-file
- Discussion threads 2005-06-24
- SQL basics: Query multiple tables
- Whether you're learning SQL for the first time or just need a refresher, read this article to learn when to use SELECT, JOIN, subselects, and UNION to access multiple tables with a single statement.It’s sometimes difficult to know which SQL syntax to use when combining data that spans multiple tables....
- Tags: Programming languages, Databases, Shelley Doll, multiple table, SQL, database
- Technical articles 2002-08-12
- Sql Select from Databases on Multiple MSSql Servers
- Is there a way to include the server name in an sql select statement. (E.g select ([select columns] from server1.db1.dbo.table1 , server2.db2.dbo.table2 where [where statements])if not is there any other way to achieve thisLook up sp_addlinkedserverBeen a long time but yiou can then useselect * from Link.dbo.TableWhere link = server.database.Usually...
- Tags: Programming languages, Databases, awcrichton@..., SQL, database
- Discussion threads 2007-05-16
- Asking twice on MSAccess 2003
- Hi to all!I've an issue that I really have no idea why is happening...When I FIRST run the query shown below, it's asking me twice the field "[PLC]". When this happens, I only need to insert the value I'm looking for on the second pop-up window.SELECT *FROM Table1 SWHERE (((S.Field1)...
- Tags: PLC, rayasta@..., S.Field1, S.Field2
- Discussion threads 2007-02-01
- Access - filter for dates not present & w/o records
- I maintain records with a sub table of dated entries. Want to select records which have no entries for a given time period. Example - all records with no activity in December. I need all records without dates >11/30/2004 and 11/30/2004 and 11/30/2004 and 11/30/2004 and
- Tags: Microsoft Access, PO Number, PO Status, qaqcdave@..., software
- Q&A 2004-12-22
- << Previous
- page 1 of 1
- Next >>
