Advertisement

1 - 10 of 366 containing alltags:("SQL Syntax") (0.002 seconds)
Hi Experts,  I am making a VB application in which user will type SQL query in Rich Text Box. I want SQL verbs/syntax automatically change color after typing. For example  if user types SELECT ...
Zones: Visual BasicDate Answered: 09/23/2002 Grade: B Views: 4
Dear experts, I don't understand why there is a syntax error in my SQL. PLS ADVISE!     strSQL = "INSERT INTO Transaction(name, amount,date, beg_Bal,end_Bal, type, memo) values (" _           ...
Zones: MS AccessDate Answered: 04/28/2003 Grade: A Views: 0
Hi, We have a table in our database called 'Filter' and this is used as part of an application. Table e.g:           FilterNo           Descript                                                 ...
Zones: MS SQL ServerDate Answered: 02/25/2004 Grade: B Views: 0
Hi! I believe I ahve a very simple question abour Remedy application access through Remedy client  to read and write to the the database. The first question I have, is Remedy Database  complete...
Zones: DatabasesDate Answered: 10/28/2004 Grade: C Views: 0
Hi, I believe I need some help on this one. SELECT     dbo.ProjectLines.OldHALNum, dbo.ProjectLines.VendorCode, dbo.ProjectLines.Description, dbo.ProjectLines.ExtendedDescription,             ...
Zones: DatabasesDate Answered: 01/25/2005 Grade: A Views: 0
Hi - I have a sql script that is fairly basic in that it selects data  from a couple of tables an d gets outputted into a users excel sheet. This normally works fine until we find that sometimes t...
Zones: MS SQL ServerDate Answered: 01/13/2005 Grade: A Views: 0
I have a table with the following data product    cost    adjustment    quantity parta        $1                             10 partb        $2                              5 partc           ...
Zones: MS SQL ServerDate Answered: 02/11/2005 Grade: B Views: 0
I am trying  to close to hard code a value into a column however I keep getting syntax errors when I erform my INSERT. Here is the end of my SQL: I need to insert the value qryCockpit into the dat...
Zones: ASP.Net ProgrammingDate Answered: 06/07/2005 Grade: A Views: 0
Hi All! In a VBA program, I'm retrieving data from a database into an ADO recordset. The database is actually an Oracle DB, but I guess the SQL syntax for this is the same in SQL Server, so I a...
Zones: MS SQL ServerDate Answered: 09/23/2005 Grade: A Views: 0
I am creating a view, and I would like to create a new column that is made up of the data from 2 existing columns, plus some text of my own.  Here is an example: There are the following columns in...
Zones: MS SQL ServerDate Answered: 11/29/2005 Grade: A Views: 0