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