cupdatesqlserver

Ⅰ sqlServer update語句 具體看補充

例如:
A.type,name,val 假設取到val的值
B.b1,b2
C.c1,c2
...

select decode(a.type,m.type,m.val,n.type,n.val) val
from a,
(select a.type,a.name,b.b2 from a,b where a.type = b.b1)m,
(select a.type,a.name,c.c2 from a,c where a.type = c.c1)n
where a.type = m.type(+)
and a.name = m.name(+)
and a.type = n.type(+)
and a.name = n.name(+)
;

Ⅱ SQLSERVER 多表關聯如何更新

update 表C

set 表C.c3=表B.b3
from 表C
where 表C.c1=表A.a2 and 表C.c2=表B.b2
您說的還沒搞明白，從語法上講應該是這樣的，不知道行不行，只做過2個表之間關聯更新的，您這個要3個表，而且B表和 C表的關聯有沒有呢？

Ⅲ 關於sqlserver某個欄位的update更新操作

update a set a.telephone=b.telephone

from table2 a
inner join table1 b on a.joid_id=b.user_id

或者
update table2
set telephone=a.telephone
from table1 a
WHERE table2.joid_id=a.user_id

兩種方式都可以

Ⅳ 想在sqlserver函數里執行update有什麼方法

Update 語句主要用於修改表中的數據：UPDATE 表名稱 SET 列名稱 = 新值 WHERE 列名稱 = 某值

Ⅳ sqlserver update 很多欄位,如更新100多個欄位 該怎麼寫

update表名set欄位A='a',欄位B='b',欄位C='c'

Ⅵ 怎麼插銷sqlserver的update

操作方法如下：
include <iostream>

#include <stdio.h>
int jc(int m){
if(m!=1) return m*jc(m-1);
else return 1;
}
int c(int m,int n){
if(m>=n) return jc(m)/(jc(n)*jc(m-n));
}
int main(void){
int m,n;
scanf("%d%d",&m,&n);
printf("%d\n",c(m,n));
return 0;
}

Ⅶ sqlserver update語句怎樣更改兩個數據

UPDATE是我們常SQL語句之一,update主要用於更改表中的現有數據.
UPDATE詳細語法
{
table_name WITH ( < table_hint_limited > [ ...n ] )
| view_name
| rowset_function_limited
}
SET
{ column_name = { expression | DEFAULT | NULL }
| @variable = expression
| @variable = column = expression } [ ,...n ]

{ { [ FROM { < table_source > } [ ,...n ] ]

[ WHERE
< search_condition > ] }
|
[ WHERE CURRENT OF
{ { [ GLOBAL ] cursor_name } | cursor_variable_name }
] }
[ OPTION ( < query_hint > [ ,...n ] ) ]

< table_source > ::=
table_name [ [ AS ] table_alias ] [ WITH ( < table_hint > [ ,...n ] ) ]
| view_name [ [ AS ] table_alias ]
| rowset_function [ [ AS ] table_alias ]
| derived_table [ AS ] table_alias [ ( column_alias [ ,...n ] ) ]
| < joined_table >

< joined_table > ::=
< table_source > < join_type > < table_source > ON < search_condition >
| < table_source > CROSS JOIN < table_source >
| < joined_table >

< join_type > ::=
[ INNER | { { LEFT | RIGHT | FULL } [OUTER] } ]
[ < join_hint > ]
JOIN

< table_hint_limited > ::=
{ FASTFIRSTROW
| HOLDLOCK
| PAGLOCK
| READCOMMITTED
| REPEATABLEREAD
| ROWLOCK
| SERIALIZABLE
| TABLOCK
| TABLOCKX
| UPDLOCK
}

< table_hint > ::=
{ INDEX ( index_val [ ,...n ] )
| FASTFIRSTROW
| HOLDLOCK
| NOLOCK
| PAGLOCK
| READCOMMITTED
| READPAST
| READUNCOMMITTED
| REPEATABLEREAD
| ROWLOCK
| SERIALIZABLE
| TABLOCK
| TABLOCKX
| UPDLOCK
}

< query_hint > ::=
{ { HASH | ORDER } GROUP
| { CONCAT | HASH | MERGE } UNION
| {LOOP | MERGE | HASH } JOIN
| FAST number_rows
| FORCE ORDER
| MAXDOP
| ROBUST PLAN
| KEEP PLAN
}

Ⅷ C# Update sqlserver

public void CommandSql()
{
String ConnString = @"Data Source=DEV-TP-02\SQLEXPRESS;Initial Catalog=TEST;User ID=login;Password=111;";
SqlConnection myConnection = new SqlConnection(ConnString);
myConnection.Open();
SqlCommand myCommand = new SqlCommand("update tablename set xxx= xxx",myConnection);
myCommand.ExecuteNonQuery();
}

Ⅸ sqlserver update語句怎樣更改兩個數據

Update 語句用於修改表中的數據。

語法：

UPDATE table_name
SET column_name = new_value
WHERE column_name = some_value

Person:

方法二：

1） MySql多表更新方法：

MySql語法：UPDATE table_references SET col_name1=expr1 [, col_name2=expr2 ...] [WHERE where_definition]

例子：UPDATE A a , B b SET a.a1 = b.b1 , a.a2 = b.b2 WHERE a.a3 = b.b3

2） SQLServer多表更新方法：

SQLServer語法：UPDATE { table_name WITH ( < table_hint_limited > [ ...n ] ) | view_name | rowset_function_limited } SET { column_name = { expression | DEFAULT | NULL } | @variable = expression | @variable = column = expression } [ ,...n ] { { [ FROM { < table_source > } [ ,...n ] ] [ WHERE < search_condition > ] } | [ WHERE CURRENT OF { { [ GLOBAL ] cursor_name } | cursor_variable_name } ] } [ OPTION ( < query_hint > [ ,...n ] ) ]

例子：UPDATE a SET a.a1 = b.b1 , a.a2 = b.b2 FROM A a , B b WHERE a.a3 = b.b3