Shulou(Shulou.com)05/31 Report--

This article shows you how to skillfully solve the multi-choice query method through the bit operation function of SQL Server. The content is concise and easy to understand, which can definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Whether you use int or varchar, multiple-choice queries for Status are not easy to deal with. For example, the Enum setting for CustomerStatus under conventional thinking is as follows: copy the code as follows: [Serializable] public enum CustomerStatus {New = 0, Active = 1, Overdue = 2, Suspended = 3, Closing = 4, Closed = 5}

The status value is stored in the database as int. What if I want to search for Customer with the status of Active,Overdue and Suspended once on the page? Does the program have to spell these three state values into strings and pass them to SQL for processing? Although it can be achieved, it is quite inefficient. Now a standard solution is given: (1). All enumerations that may be used as search criteria should be defined as follows. The copy code is as follows: public enum CustomerStatus {New = 1, Active = 1

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.