如何从SQL查询中分离属性 [英] How to separate attribute from sql query

问题描述

如何从传入的SQL查询中分离属性.我想从in查询中获取分离的属性.例如，当任何一个搜索数据(例如在2000到10000之间选择诺基亚移动奖品")搜索时，我想将所有属性分开，以对其中一个应用索引.我使用sql server profiler从传入的查询中获取查询工作量

How to separate attribute from incoming sql query.I want to get separate attribute from an in query. for example when any one search data like "select nokia mobile prize between 2000 to 10000" In this query I want to separate all the attribute to apply index on one of them. I use sql server profiler to get query workload from incoming query

推荐答案

Hi,

DECLARE @Param1 BIGINT

SET @Param1 = 45;

SELECT Col1 FROM Table1 WHERE YourParam1 = @Param1

您还可以查看存储过程.

希望对您有所帮助！

You can also have a look at Stored Procedures.

Hope it helps!

这篇关于如何从SQL查询中分离属性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！