34,593
社区成员
发帖
与我相关
我的任务
分享
update tpData set dz = dz/1000
USE AdventureWorks2008R2
UPDATE Production.Product --少了个 . 或者 dbo.
SET ListPrice = ListPrice * 2
USE AdventureWorks2008R2
UPDATE Production..Product
SET ListPrice = ListPrice * 2
--sql没有问题
create table tb1(编号 int,尺寸 int)
insert into tb1
select 1,1000 union all
select 2,1200 union all
select 3,23456 union all
select 4,1299 union all
select 7,13462
update tb1 set 尺寸=尺寸/1000
select * from tb1
/*
编号 尺寸
----------- -----------
1 1
2 1
3 23
4 1
7 13
--> 数据库版本:
--> Microsoft SQL Server 2008 (RTM) - 10.0.1600.22
--> 测试数据:[TB]
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TB]')
AND type in (N'U')) --U 代表你查询的是表
DROP TABLE [TB]
GO
---->建表
create table [TB]([name] varchar(4),[b] int)
insert [TB]
select '张三',80 union all
select '李四',70 union all
select '王五',60 union all
select '许六',100
GO
--> 查询结果
update [TB] set [b] = [b]/1000
SELECT * FROM [TB]
--> 删除表格
--DROP TABLE [TB]