SQL Server 增删改查

1.INSERT

USE [DBSZM]
GO

INSERT INTO [dbo].[SZM_Function]
           ([Id],[MenuId],[FunctionName])
     VALUES
           (1501,1164,'test')
GO

2.DELETE

USE [YiBaiSZM]
GO

DELETE FROM [dbo].[SZM_Function]
      WHERE Id=1501
GO

3.UPDATE

USE [DBSZM]
GO

UPDATE [dbo].[SZM_Function]
   SET [IsDeleted] = 0
   WHERE Id=1500
GO

4.insert