Not Return Any Record if Value Exists
If I have a table that has the following data (f1 & f2 are the field names): f1 f2 a 1 a 2 a 0 b 1 b 2 b 3 I want to write a query that would not return b because b has a f2 = 3. So, in other words: I have [...]

Answer Question   |  September 24, 2008  8:32 PM
Oracle, Oracle SQL, SQL

Linking to a table in SQL with Visual Basic
How could I link to a table in SQL using Visual Basic?

Answer Question   |  September 26, 2008  6:12 PM
SQL, SQL tables, Visual Basic

Designing a report in SQL from an Excel worksheet
I am trying to design a report from an Excel worksheet, and I’m not sure how to get this information into SQL. I have 180 files with multiple tabs in each that house all the data I need, but I only need one tab from each of the files. Is there an easy way to [...]

Answer Question   |  September 23, 2008  3:20 PM
Microsoft Excel, SQL, SQL Server reporting

Updating values in a table in a SQL database
I have a SQL database with a table. I need to insert a new record into that table if there is no entry for a particular column that day, or I need to update the record if that new record already exists. I am using a count column in the table to accomplish this, and [...]

Answer Question   |  November 12, 2008  5:04 PM
SQL, SQL Database, SQL stored procedures

Questions about a SQL database with hourly transaction log backups
We have a SQL database with a full recovery model that backs up the database once a day, along with hourly backups for the transaction logs. However, we only have one transaction log backup file, and it is overwritten every time. Are transaction log backups cumulative, and if so, does that one file contain all [...]

Answer Question   |  September 23, 2008  4:50 PM
SQL, SQL Database, SQL Server backup, SQL transaction logs

Writing a query in SQL for use in SQL Server 2005
I’d like to write a query that would allow me to view items with a characteristic of my choosing and filter out the others. Is it possible to write something like this in SQL and use it in SQL Server 2005?

Answer Question   |  September 17, 2008  3:14 PM
Query, SQL, SQL Query, SQL Server 2005

Writing a specific query involving primary keys in SQL
I need to write a query in SQL that will get the fifth-from-last record from my database when either a primary key is defined or no primary at all is defined. How would this query look?

Answer Question   |  September 16, 2008  5:51 PM
Primary keys, Query, SQL, SQL Query

Error inserting data in table
hi plz help me ,i want to insert some data in a table but some error ocurred. ————————————————————— using System; using System.Data.SqlClient; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; public partial class _Default : System.Web.UI.Page { SqlConnection con; SqlDataAdapter da; SqlCommand cmd; System.Data.DataTable dt; protected void [...]

Answer Question   |  September 20, 2008  6:50 AM
ASP.NET, C#, GridView, SQL

Maintaining a company table in SQL
I am not sure if I should mix budget data and sales data in one table in SQL or separate it. Also, if I add descriptors into the table, this will only increase record sizes and reduce the value of caching by padding each record out with repeated data. Is using small descriptor tables at [...]

Answer Question   |  September 20, 2008  7:56 PM
SQL, SQL tables

Receiving a DOS output with a Visual Basic script in SQL
I would like to solve this following complex script in SQL by using Visual Basic, either version 5.0 or 6.0. My first table name is tblClient, with fields ClientID and ClientName. My second table name is tblPurchase, with fields ClientID, Item Name, Qty and Price. I would like to pass one SQL query and receive [...]

Answer Question   |  September 9, 2008  7:48 PM
DOS, SQL, Visual Basic, Visual Basic 5, Visual Basic 6, Visual Basic in SQL Server

how to view data in gridview with a sqldatasource
hi , i m amit i want a help to view datasource and grideview,when i make connection in datasourse and use this connection in gridview and run it page can not display gridview structure. plz help me

Answer Question   |  September 9, 2008  11:02 AM
ASP.NET, C#, DataSource, GridView, SQL

Unable to open a SQL application on two different machines
If someone in our office opens a SQL application, no one else is able to open it. We all receive the message: “Another application is using this file.” How can we solve this problem?

Answer Question   |  September 9, 2008  8:18 PM
SQL, SQL error messages

Printing Reports to Dotmatrix Printer from Visual Basic 5.0 OR 6.0
Respected Sir, In SQL I would like to solve the following complex script by using Visual Basic 5.0 or 6.0 Versions. First Table Name: tblClient Fields: ClientID, ClientName Second Table Name: tblPurchase Fields: ClientID, Item Name, Qty, Price Here How can I pass one SQL query for a Dos print out by opening a text [...]

Answer Question   |  September 28, 2008  7:32 PM
Printers, SQL, VB, VB5, Visual Basic

Migrating SRS reports to new data structure
I’m migrating to a new database with different tables and fields but want to continue to use the SQL SRS reports that I previously had (there are hundreds of them). Is anyone aware of a tool that will allow me to map the new and old data structure and update the rdl files for SRS?

Answer Question   |  September 28, 2008  10:59 PM
RDL, SQL, SRS

SQL File Member Can SQL on i allows users to select a specific member to be processed without using a OVRDBF command
Cqn SQL on i allows users to select a specific member to be processed without using a OVRDBF command

Answer Question   |  September 5, 2008  10:32 PM
OVRDBF, SQL

Definition of the withGrant parameter in SQL
When giving permissions to database users in SQL, what does the withGrant parameter do?

Answer Question   |  September 5, 2008  8:09 PM
Parameters, Permissions, SQL

AS400 ILE program with Embedded SQL
I need to load a file based on several search criteria and then use the file to display in a subfile

Answer Question   |  March 24, 2011  1:13 PM
ILE, SQL

can a file be loaded from an embedded sql statement?
can a file be loaded from an embedded sql statement? I want to use the file that was loaded to display the data in a subfile.

Answer Question   |  August 29, 2008  6:28 PM
SQL, SQL statements

WRKDBF replacement?
Does anyone know of a good, free alternative to WRKDBF? I’ve been using it for years. However we just upgraded our business software. In this new version it has ISO date fields. For those fields that are null (essentially are 0001-01-01), WRKDBF can’t handle it and blows up. I’m NOT a programmer by any means [...]

Answer Question   |  December 9, 2011  4:01 PM
SQL, WRKDBF

How to get local time of a SQL server?
Hwo to get local time of a SQL server and store it in a variable of a client program written in C#?

Answer Question   |  August 27, 2008  8:03 AM
C#, SQL, SQL Server