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