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