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]
GO

DELETE FROM [dbo].[renyuanxinxi]
      WHERE r_gonghao=683
GO

 

 

sql_insert写入

 

USE [moge]
GO

INSERT INTO [dbo].[renyuanxinxi]
           ([r_gonghao]
           ,[r_mingzi]
           ,[r_bumen]
           ,[r_xingbie])
     VALUES
      ('683', '张三', '人力资源部', '男')

sql_update  修改

 

USE [moge]
GO

UPDATE [dbo].[renyuanxinxi]
   SET [r_gonghao] = 683
      
 WHERE [r_gonghao]=624
GO

sql_alter table   列_增加

 

/****** Script for SelectTopNRows command from SSMS  ******/
alter table.[renyuanxinxi] add aa_1 int