sqlserver也只是刚刚会用,可是如果要从事数据库方面的工作,肯定不是只会用就行吧,要拿到月薪4000元以上的工资,需要掌握到什么程度呢,需要具有哪些素质?
哪位知道?请说的详细一些。
sql server数据库学到什么程度工资可以拿到4000元以上?
答案:2 悬赏:30 手机版
解决时间 2021-01-28 12:21
- 提问者网友:鼻尖触碰
- 2021-01-28 02:45
最佳答案
- 五星知识达人网友:長槍戰八方
- 2021-01-28 03:12
也拿4000的 不过很少 要很有经验 在一个公司做久
全部回答
- 1楼网友:低音帝王
- 2021-01-28 03:30
汉字说的是列名,自己改下,学sql的,这点应该看的出来啦
(1)
insert into tablename values('12478509258 ', '张伟聪', '75', '80', '82')
update tablename set 工资 = 2000 where 教师姓名 = '刘八'
delete from tablename where 教师姓名 = '赵六'
(2)
use master;
go
if db_id (n'sales') is not null
drop database sales;
go
-- get the sql server data path
declare @data_path nvarchar(256);
set @data_path = (select substring(physical_name, 1, charindex(n'master.mdf', lower(physical_name)) - 1)
from master.sys.master_files
where database_id = 1 and file_id = 1);
-- execute the create database statement
execute (create database student
on primary
( name = studentdata1,
filename = @data_path + studentdata1.mdf,
size = 5m,
maxsize = 20m,
filegrowth = 2m ),
filegroup file1
( name = studentdata2,
filename = @data_path + studentdata2.ndf,
size = 2m,
maxsize = unlimited,
filegrowth = 5% ),
filegroup file2
( name = studentdata3,
filename = @data_path + studentdata3.ndf,
size = 2m,
maxsize = 30m,
filegrowth = 1m )
log on
( name = studentlog1,
filename = @data_path + studentlog1.ldf,
size = 2mb,
maxsize = 20mb,
filegrowth = 2mb )
),
( name = studentlog2,
filename = @data_path + studentlog2.ldf,
size = 2mb,
maxsize = 20mb,
filegrowth = 2mb )
);
go
(3)
select * into newtable from tablename where 学生所属系 = '计算机系'
select * from tablename where 学生所属系 = '计算机系' and 英语成绩 < 60
select distinct 学生所属系,count(学生姓名) from tablename group by 学生所属系 order by 学生所属系
select avg(计算机基础) from tablename where 学生所属系 = '经贸系'
select 高数 from tablename where 学生所属系 = '计算机系' order by 高数 desc
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯