sqlsever 存储过程收到一个关键字入参,将其组装为'%关键字%'格式,用于查询条件LIKE使用
时间: 2024-02-03 15:11:31 浏览: 21
可以按照下面的方式编写存储过程来实现:
```sql
CREATE PROCEDURE search_keyword
@keyword VARCHAR(50)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @search_string VARCHAR(100)
SET @search_string = '%' + @keyword + '%'
SELECT * FROM your_table WHERE your_column LIKE @search_string
END
```
在上面的存储过程中,我们将输入的关键字作为参数传入存储过程,然后使用字符串拼接的方式将其组装为`'%关键字%'`的格式,最后将其用于查询条件的`LIKE`操作。在查询结果中,将返回所有符合条件的记录。
相关问题
sql sever 关键字查询
你是想查询 SQL Server 中的关键字吗?如果是的话,以下是 SQL Server 中的关键字列表:
ADD, ALTER, AND, ANY, AS, ASC, AUTHORIZATION, BACKUP, BEGIN, BETWEEN, BREAK, BROWSE, BULK, BY, CASCADE, CASE, CHECK, CHECKPOINT, CLOSE, CLUSTERED, COALESCE, COLLATE, COLUMN, COMMIT, COMPUTE, CONSTRAINT, CONTAINS, CONTAINSTABLE, CONTINUE, CONVERT, CREATE, CROSS, CURRENT, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_USER, CURSOR, DATABASE, DBCC, DEALLOCATE, DECLARE, DEFAULT, DELETE, DENY, DESC, DISK, DISTINCT, DISTRIBUTED, DOUBLE, DROP, DUMP, ELSE, END, ERRLVL, ESCAPE, EXCEPT, EXEC, EXECUTE, EXISTS, EXIT, EXTERNAL, FETCH, FILE, FILLFACTOR, FOR, FOREIGN, FREETEXT, FREETEXTTABLE, FROM, FULL, FUNCTION, GOTO, GRANT, GROUP, HAVING, HOLDLOCK, IDENTITY, IDENTITY_INSERT, IDENTITYCOL, IF, IN, INDEX, INNER, INSERT, INTERSECT, INTO, IS, JOIN, KEY, KILL, LEFT, LIKE, LINENO, LOAD, MERGE, NATIONAL, NATURAL, NCHAR, NOCHECK, NONCLUSTERED, NOT, NULL, NULLIF, OF, OFF, OFFSETS, ON, OPEN, OPENDATASOURCE, OPENQUERY, OPENROWSET, OPENXML, OPTION, OR, ORDER, OUTER, OVER, PERCENT, PLAN, PRECISION, PRIMARY, PRINT, PROC, PROCEDURE, PUBLIC, RAISERROR, READ, READTEXT, RECONFIGURE, REFERENCES, REPLICATION, RESTORE, RESTRICT, RETURN, REVERT, REVOKE, RIGHT, ROLLBACK, ROWCOUNT, ROWGUIDCOL, RULE, SAVE, SCHEMA, SELECT, SESSION_USER, SET, SETUSER, SHUTDOWN, SOME, STATISTICS, SYSTEM_USER, TABLE, TABLESAMPLE, TEXTSIZE, THEN, TO, TOP, TRAN, TRANSACTION, TRIGGER, TRUNCATE, TSEQUAL, UNION, UNIQUE, UNPIVOT, UPDATE, UPDATETEXT, USE, USER, VALUES, VARYING, VIEW, WAITFOR, WHEN, WHERE, WHILE, WITH, WITHIN GROUP, WRITETEXT.
这些关键字在 SQL Server 中具有特殊的含义,不能作为表名、列名等标识符使用。
用SQL sever语句创建一个带参数的存储过程,根据员工编号查询三个人的收入情况
好的,以下是创建一个带参数的存储过程,根据员工编号查询三个人的收入情况的SQL Server语句:
```
CREATE PROCEDURE GetEmployeeSalary
@EmpID INT
AS
BEGIN
SELECT TOP 3 Salary
FROM EmployeeSalary
WHERE EmployeeID = @EmpID
ORDER BY Salary DESC
END
```
以上存储过程的作用是根据输入的员工编号(@EmpID),查询该员工的薪水情况,并返回薪水前三高的记录。其中,@EmpID 是输入参数,用于指定要查询的员工编号。EmployeeSalary 是存储员工薪水信息的表,包含 EmployeeID(员工编号)和 Salary(薪水)两个字段。
在调用该存储过程时,需要提供一个整数型参数 @EmpID 的值,如下所示:
```
EXEC GetEmployeeSalary @EmpID = 1001
```
以上语句将查询员工编号为 1001 的员工的薪水情况,并返回薪水前三高的记录。当然,你可以将 @EmpID 的值替换为其他员工编号来查询不同员工的薪水情况。