I have a very basic UPDATE SQL - UPDATE HOLD TABLE Q SET Q TITLE TEST WHERE Q ID 101 This query runs fine in Oracle Derby MySQL - but it fails in SQL server 2008 with following error Msg 102 Level 15 State 1 Line 1 Incorrect syntax near Q If I remove all occurrences of the alias Q from SQL then it works But I need to use the alias

The syntax for using an alias in an update statement on SQL Server is as follows UPDATE Q SET Q TITLE TEST FROM HOLD TABLE Q WHERE Q ID 101 The alias should not be necessary here though

[sql] How to write UPDATE SQL with Table alias in SQL Server 2008?

You can always take the CTE, (Common Tabular Expression), approach.

;WITH updateCTE AS
(
    SELECT ID, TITLE 
    FROM HOLD_TABLE
    WHERE ID = 101
)

UPDATE updateCTE
SET TITLE = 'TEST';

Examples related to sql

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Generic XSLT Search and Replace template • Access And/Or exclusions • Pyspark: Filter dataframe based on multiple conditions • Subtracting 1 day from a timestamp date • PYODBC--Data source name not found and no default driver specified • select rows in sql with latest date for each ID repeated multiple times • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database

Examples related to sql-server

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Count the Number of Tables in a SQL Server Database • Visual Studio 2017 does not have Business Intelligence Integration Services/Projects • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database • How to create temp table using Create statement in SQL Server? • SQL Query Where Date = Today Minus 7 Days • How do I pass a list as a parameter in a stored procedure? • SQL Server date format yyyymmdd

Examples related to sql-server-2008

• Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object • How to Use Multiple Columns in Partition By And Ensure No Duplicate Row is Returned • SQL Server : How to test if a string has only digit characters • Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query • Get last 30 day records from today date in SQL Server • How to subtract 30 days from the current date using SQL Server • Calculate time difference in minutes in SQL Server • SQL Connection Error: System.Data.SqlClient.SqlException (0x80131904) • SQL Server Service not available in service list after installation of SQL Server Management Studio • How to delete large data of table in SQL without log?

Examples related to sql-update

• Update some specific field of an entity in android Room • How to perform update operations on columns of type JSONB in Postgres 9.4 • MySQL - UPDATE multiple rows with different values in one query • How to update multiple columns in single update statement in DB2 • Update Multiple Rows in Entity Framework from a list of ids • Update MySQL using HTML Form and PHP • CodeIgniter query: How to move a column value to another column in the same row and save the current time in the original column? • mysql after insert trigger which updates another table's column • Update values from one column in same table to another in SQL Server • I want to use CASE statement to update some records in sql server 2005

Examples related to alias

• How to open google chrome from terminal? • Aliases in Windows command prompt • SQL alias for SELECT statement • How do I run a shell script without using "sh" or "bash" commands? • Is the 'as' keyword required in Oracle to define an alias? • Make a Bash alias that takes a parameter? • List Git aliases • How to write UPDATE SQL with Table alias in SQL Server 2008? • Should I use alias or alias_method? • SQL - using alias in Group By