0 Row affected
Could you please assist with the following? UPDATE dbo.[Elution_Report_Template] SET [Elutriation_Set_SqM] = dbo.[Elution_Report].[Elutriation_Set_SqM], [Elutriation_Pump_SqM] = dbo.[Elution_Report].[Elutriation_Pump_SqM],

Answer Question   |  June 29, 2009  5:32 AM
Database engineering, Query, rows affected, SQL, Update

Pictures in a DB
In my DB I have a picture in each record but it now says I have no more space available…How do I get round this?

Answer Question   |  June 29, 2009  3:26 AM
Binary data, Database administration, Image databases

Reminder: “Cert success story” contest ends June 30th
As some of you may already be aware, one of our bloggers, Ed Tittel, is currently running a contest on his blog IT Career JumpStart. The contest is called Share Your Certification Success Story, Win an MS Voucher, and the six winners who share the best stories about someone whose life was affected (job, promotion, [...]

Answer Question   |  June 26, 2009  8:25 PM
Careers, Certifications, IT careers, Microsoft certifications

Showing a substiute value in a report if conditions are met – Access
In one of my tables, there is a date field which shows dates of an event happening (called “Issue Date”). This gets input through various measures. Input form or directly into the table or query. One of the reports I am trying to design is a report that will show all materials that have been [...]

Answer Question   |  July 14, 2009  10:54 AM
Access 2003, Microsoft Access, Reports

Information Security Degrees
As an IT security professional, does it really matter which school a degree is earned from? For example, I have two schools that are both online and regionally accredited: American Military University and University of Maryland University College. AMU offers a B.S. in Information Systems Security, and UMUC offers B.S. in Information Assurance. UMUC’s program, [...]

Answer Question   |  June 30, 2009  10:21 PM
american military university, amu, Degree, information assurance, Information security careers, Information Systems Security, IT careers, IT education, nsa cae, Security careers, umuc, university of maryland university college

dynamic temporary table variable usage
We have an sqr (running against a MS SQL Server DB), that references a dynamic temporary table variable in several begin-sql and begin-select statements. I am getting a syntax error in one begin-select statement where I can’t resolve the problem. It occurs after the INNER JOIN on the [$Temp_Final_IDlist] temp table. It appears as if [...]

Answer Question   |  June 25, 2009  7:53 PM
Dynamic SQL, INNER JOIN, SQL tables, SQL variables

Failover issues in a SQL Server 2005 mirrored database
I have a SQL Server 2005 mirrored database with a witness. Everything seems to be working OK but I am having problems in the instance a failover occurs. Once the primary server goes down, my access to the database continues normally once both servers are back up and running and the old mirror is left [...]

Answer Question   |  June 25, 2009  4:23 PM
Database mirroring, DSN, Failover, SQL Server 2005, SQL Server 2005 connectivity, SQL Server Database Mirroring

Deleting Nightly Database Backups (dumps)
How do you set up a maintenance plan to delete or overwrite daily database backups (*.bak) file. My maintenance plan in SQL 2005 does not work…it doesn’t do the cleanup it continuously appends to folder and I have to manually delete the files everyday

Answer Question   |  June 25, 2009  3:57 PM
Database Backup, Database backup and recovery, Database maintenance, SQL 2005

MS-Access
Hi all, I’ll try to describe the problem in a simple way: I once created an Access DB with everything necessary, e.g. mdb, mdw and then put them all in a shared network file something ununderstandable happened: a colleague, whom I granted ONLY read-access, click on the DB he could write in the DB!!! Although [...]

Answer Question   |  June 25, 2009  2:47 PM
Access 2003, Access Database, Microsoft Access, Windows XP

Access Database Capacity
What is the data volume that an Access Database can effectively handle?

Answer Question   |  June 29, 2009  2:42 PM
Access Data Volume, Access Database, Access Database Capacity, Microsoft Access

top values and ranking
What function do i use to give a field a ranking based on it’s current sorted position in a query. I do not want to use a running sum on a report – it needs to be in the underlying query as I am going to have to join several together.

Answer Question   |  June 24, 2009  11:04 AM
RANK function, SQL

about visual basic.net
Hi I install vb.net ready and make connection ready, but when I try to using SQL statement it is error: my SQL is dim strSQL as string=”select * from tblCustome where CustomerID=”& intCustomerID the error is it does not no the string &? Please show me the solution how to solve this error! thank my [...]

Answer Question   |  December 15, 2010  1:15 AM
Database connectivity, SQL, VB.NET, VB.NET 2003, Visual Basic .NET

Disconnecting a Crystal 8.5 report while report is open in VB6
Hi I am developing an application which is written in VB6 and uses Crystal Reports 8.5 and has MSAccess as its database. The Users connect to the database via ODBC and the reports also use ODBC to connect to the data source. I have simply added the Crystal Report object to the forms which require [...]

Answer Question   |  June 24, 2009  1:11 AM
Crystal Reports 8.5, Microsoft Access, VB 6, Visual Basic 6

Using MySQL message API on Windows
I am new to MySQL message API. I want to use MySQL message API on Windows platform. But MySQL message API is tested and developed on open source platform (Linux, Unix, etc). I think MySQL message API is nothing but a udf, which uses spread toolkit (spread daemon). So I tried to build a dll [...]

Answer Question   |  June 23, 2009  3:12 PM
API, C programming, cygwin, MySQL, UDF, Windows

CSV file to database table
Hi Experts, I have a question is the csv file can be converted to a database table with same column and data i hav gone through the CSV format tag,not getting idea about this i just would like to know is there any procedure or sysntax to do this thanks for the hlp

Answer Question   |  June 25, 2009  10:57 AM
CSV format, CSV input file

Update DateStructure Field through SQL Query
I wanna update a field in the table(which is a Data Structure) through Sql Query.. Can anyone help in this regard>>

Answer Question   |  June 26, 2009  6:44 AM
Data structures, SQL, SQL queries

Networking certifications
I want to learn computer networking but I wanna get a career certificate, is that good enough?

Answer Question   |  June 23, 2009  4:54 AM
Certifications, IT careers, Networking certifications

Execute a query on table in different db that will make a table in currentdb
Cheers, I have an Access 2007 application that uses mostly vb.net code to create an excel spreadsheet with all the necessary data in the right places… The program uses a specific set of data that resides in a different database. What I would like to do is connect to the foreign table (which I can [...]

Answer Question   |  June 23, 2009  9:55 PM
Access 2007, Database, Visual Basic, Visual Basic .NET

Conversion of table into XML
How to load a table into XML in a CLOb using Oracle 8.1.4

Answer Question   |  June 22, 2009  10:10 AM
CLOB, Oracle 8.1.4, Table to XML, XML

pasting a database query into crystal
I am creating reports in Crystal 8.5 because it is required for the CRM system we use. I am having trouble pasting the SQL query that I need into the report. It will populate but it is not updating the contents of the report. Can anyone hel with this?

Answer Question   |  June 19, 2009  4:37 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports Database, SQL queries