[求助]关于UPDATE的问题 - 编程论坛

#2

Kendy1234562007-08-20 11:51

UPDATE MST_SYAIN SET 报酬月额 = WRK_Housyuuteigaku.标准月额 from MST_SYAIN
INNER JOIN WRK_Housyuuteigaku ON WRK_Housyuuteigaku.职员编号 = MST_SYAIN.职员编号

你连SQL最基本的语法规则都没弄清楚先好好看书吧

#3

C大少2007-08-20 13:28

为什么这么写？什么规则？

#4

leixiangchao2007-08-20 13:45

看看书就知道了

#5

C大少2007-08-20 13:52

[ WITH <common_table_expression> [...n] ]
UPDATE
[ TOP ( expression ) [ PERCENT ] ]
{ <object> | rowset_function_limited
[ WITH ( <Table_Hint_Limited> [ ...n ] ) ]
}
SET
{ column_name = { expression | DEFAULT | NULL }
| { udt_column_name.{ { property_name = expression
| field_name = expression }
| method_name ( argument [ ,...n ] )
}
}
| column_name { .WRITE ( expression , @Offset , @Length ) }
| @variable = expression
| @variable = column = expression [ ,...n ]
} [ ,...n ]
[ <OUTPUT Clause> ]
[ FROM{ <table_source> } [ ,...n ] ]
[ WHERE { <search_condition>
| { [ CURRENT OF
{ { [ GLOBAL ] cursor_name }
| cursor_variable_name
}
]
}
}
]
[ OPTION ( <query_hint> [ ,...n ] ) ]
[ ; ]

谁能吧这些参数都翻译一下啊？