Hio,
I want to update teh database Slim98 with some values out of database Slim0.
The databasestructure is equal.
update Slim98.dbo.article
set Slim98.dbo.article.insuranceinventory = Slim0.dbo.article.insuranceinventory,
Slim98.dbo.article.overwriteBufferStock = Slim0.dbo.article.overwriteBufferStock,
Slim98.dbo.article.insInvDateSet = Slim0.dbo.article.insInvDateSet
where Slim98.dbo.article.code = Slim0.dbo.article.code and Slim98.dbo.article.warehouse = 'M01-'
getting message:
Server: Msg 107, Level 16, State 3, Line 1
The column prefix 'Slim0.dbo.article' does not match with a table name or alias name used in the query.
Server: Msg 107, Level 16, State 1, Line 1
The column prefix 'Slim0.dbo.article' does not match with a table name or alias name used in the query.
Server: Msg 107, Level 16, State 1, Line 1
The column prefix 'Slim0.dbo.article' does not match with a table name or alias name used in the query.
Server: Msg 107, Level 16, State 1, Line 1
The column prefix 'Slim0.dbo.article' does not match with a table name or alias name used in the query.
1 2362
Hio,
I want to update teh database Slim98 with some values out of database Slim0.
The databasestructure is equal.
update Slim98.dbo.article
set Slim98.dbo.article.insuranceinventory = Slim0.dbo.article.insuranceinventory,
Slim98.dbo.article.overwriteBufferStock = Slim0.dbo.article.overwriteBufferStock,
Slim98.dbo.article.insInvDateSet = Slim0.dbo.article.insInvDateSet
where Slim98.dbo.article.code = Slim0.dbo.article.code and Slim98.dbo.article.warehouse = 'M01-'
getting message:
Server: Msg 107, Level 16, State 3, Line 1
The column prefix 'Slim0.dbo.article' does not match with a table name or alias name used in the query.
Server: Msg 107, Level 16, State 1, Line 1
The column prefix 'Slim0.dbo.article' does not match with a table name or alias name used in the query.
Server: Msg 107, Level 16, State 1, Line 1
The column prefix 'Slim0.dbo.article' does not match with a table name or alias name used in the query.
Server: Msg 107, Level 16, State 1, Line 1
The column prefix 'Slim0.dbo.article' does not match with a table name or alias name used in the query.
i think you're missing the FROM CLAUSE
try something like:
update Slim98.dbo.article
set Slim98.dbo.article.insuranceinventory = Slim0.dbo.article.insuranceinventory,
Slim98.dbo.article.overwriteBufferStock = Slim0.dbo.article.overwriteBufferStock,
Slim98.dbo.article.insInvDateSet = Slim0.dbo.article.insInvDateSet
FROM SLIM0.DBO.ARTICLE
where Slim98.dbo.article.code = Slim0.dbo.article.code and Slim98.dbo.article.warehouse = 'M01-'
-- ck
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Sarah Tanembaum |
last post by:
Beside its an opensource and supported by community, what's the fundamental
differences between PostgreSQL and those high-price commercial database (and
some are bloated such as Oracle) from...
|
by: Terry Olsen |
last post by:
I've got 2 different web pages, both updating the same SQL database. One is
for the Technician and one is for the Manager. The technician's update page
works fine but the Manager's update page...
|
by: hans.bonefaas |
last post by:
Hi all,
I hope someone can help me with the following problem in ASP.net.
I want to edit the information for a record in a database (MS Access).
On the page I placed several textboxes and...
|
by: Jonathan Upright |
last post by:
Greetings to anyone who can help:
I'm using WebMatrix to make ASP.NET pages, and I chose the "Editable
DataGrid" at the project selector screen. As you may know, it defaults
to the Microsoft...
|
by: Reney |
last post by:
I haven't used the VS Studio's drag&drop method to create my connection,
adapters and datasets, but I typed them all. The situation is like this:
There is a listbox with members pulled from the...
|
by: Kevin Hodgson |
last post by:
I'm experiencing a strange Dataset Update problem with my application.
I have a dataset which has a table holding a set of customer information
records. (address, contact, info, etc.)
I have a...
|
by: Xah Lee |
last post by:
in March, i posted a essay “What is Expressiveness in a Computer
Language”, archived at:
http://xahlee.org/perl-python/what_is_expresiveness.html
I was informed then that there is a academic...
|
by: Siong.Ong |
last post by:
Dear all,
my PHP aims to update a MySQL database by selecting record
one by one and modify then save.
Here are my PHP, but I found that it doesnt work as it supposed to be,
for example, when...
|
by: CTG |
last post by:
"update set UPDATE-FLAG=false, UPDATE-DT= '10/09/2007
4:09:59 PM' WHERE ICCID='I1' "
UPDATE_FLAG is a YES/NO
ICCID is TEXT
I have tried YES, NO as well but still fails,
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development projectplanning, coding, testing,...
| |