目录
- 函数练习
- [判断(数据库、表、函数、存储过程等)是否存在]
- CREATE FUNCTION
- EXECUTE AS
- eg.
USE master
GO
IF EXISTS(SELECT * FROM SYSDATABASES WHERE name='LeetCode')
BEGIN
DROP DATABASE LeetCode
SELECT 1 AS deleted_leetcode
END
CREATE DATABASE LeetCode
USE LeetCode
GO
SELECT *
FROM SYSOBJECTS
WHERE xtype='U'
EXEC sp_help
-- 函数
-- 第2高工资
USE master
GO
IF EXISTS(SELECT * FROM sysdatabases WHERE name='LeetCode')
DROP DATABASE LeetCode
GO
CREATE DATABASE LeetCode
GO
USE LeetCode
GO
SELECT * FROM sysobjects WHERE xtype='U' OR xtype='FN'
IF EXISTS(SELECT * FROM sys.objects WHERE name='Salary')
DROP TABLE Salary
GO
CREATE TABLE Salary
(
Id INT IDENTITY PRIMARY KEY,
Salary INT
)
INSERT INTO Salary VALUES
(100), (200), (300)
GO