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