Can anybody help me with the update statement below:
update AttributeValues A
set
B.atvl_value = hold_pickid,
C.atvl_value = hold_dispatchdate
from AttributeValues A
inner join Attrib...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21837686.html
Zones:
MS SQL ServerDate Answered: 06/02/2006 Rating: 9.0 Views: 0
I have just created a new database in SQL Server 2005 and I am update fields within another database.
Apparently the databases are set-up differently. How can I change the collation of the new da...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2279...
All the sql required is as follows:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Paging_Cursor]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Pagi...
http://www.experts-exchange.com/Database/Oracle/Q_21489482.html
Zones:
OracleDate Answered: 07/13/2005 Rating: 9.4 Views: 0
Have the following tables in "Database1" from where I want to transfer data:
CREATE TABLE [dbo].[tblArticles] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[category] [int] NOT NULL ,
[title] [v...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20896995.html
Zones:
DatabasesDate Answered: 04/20/2004 Rating: 8.0 Views: 0
In the table defined below I want to ensure that only one of:
absDiscount
perDiscount
is defined at any one time - that is, you cannot have a definition for both of these for a single re...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21055666.html
Zones:
MS SQL ServerDate Answered: 07/12/2004 Rating: 7.6 Views: 0
I have the following situation:
* I have many tables that store the following information:
[id] [int] IDENTITY (1, 1) NOT NULL ,
[publishDate] [smalldatetime] NOT NULL ,
[title] [varch...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21117816.html
Zones:
MS SQL ServerDate Answered: 09/08/2004 Rating: 6.6 Views: 0
Whats the difference between Latin1_General_CI_AS and SQL_Latin1_General_CP1_CI_AS?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21958338.html
Zones:
MS SQL ServerDate Answered: 08/22/2006 Rating: 9.2 Views: 0
Hi,
I tried to run this change on my sp (SQL2005 Standard):
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER procedure [dbo].[spBerechnungswerteIntegrieren01]
as
--Werte für Ge...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22421613.html
Zones:
MS SQL ServerDate Answered: 03/01/2007 Rating: 9.2 Views: 49
During the installation af a new istance of sql server 2005, which option should I choose in order to obtain the collation Latin1_General_CI_AI?
Thanks!
http://www.experts-exchange.com/Database/Miscellaneous/Q_23962212.html
I have a SQL 2000 DB with collation SQL_Latin1_General_CP1_CI_AS, I am attempting to upgrade and host this in SQL 2005 Enterprise x64 bit.
When I run the installer for SQL Server 2005 I get serv...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2241...
