你的位置:首页 > 数据库

[数据库]sql_查询select


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