sql_查询select
/****** Script for SelectTopNRows command from SSMS ******/SELECT TOP 1000 [r_gonghao] ,[r_mingzi] ,[r_bumen] ,[r_xingbie] FROM [moge].[dbo].[renyuanxinxi]
sql _ delete 删除
USE [moge]GODELETE FROM [dbo].[renyuanxinxi] WHERE r_gonghao=683GO
sql_insert写入
USE [moge]GOINSERT INTO [dbo].[renyuanxinxi] ([r_gonghao] ,[r_mingzi] ,[r_bumen] ,[r_xingbie]) VALUES ('683', '张三', '人力资源部', '男')
sql_update 修改
USE [moge]GOUPDATE [dbo].[renyuanxinxi] SET [r_gonghao] = 683 WHERE [r_gonghao]=624GO
sql_alter table 列_增加
/****** Script for SelectTopNRows command from SSMS ******/alter table.[renyuanxinxi] add aa_1 int
原标题:sql_查询select
关键词:sql