sql query analyzer 2017

Determine which SQL Server Database components version is installed Use isql, osql, or Query Analyzer to execute one of the following queries against the database engine instance. SELECT serverproperty (' ProductLevel ') SELECT @ @VERSION SELECT serverproperty (' ProductVersion ') Use the table below to determine your version of Database components.

usage is: SELECT * from Flow_user where regexp_like (username, ' [Zhang Wangli] Fly ')4.[^ ]: Represents a single character that is not listed within the parentheses. The value is the same as [], but it requires that the matched object be any character other than the specified character.For example SELECT * from [user] WHERE u_name like ' [^ Zhang Li Wang] three 'Will find the surname "Zhang", "Li", "Wang" "Zhao Three", "Magozo" and so on;For example SELECT * from [user] WHERE u_name like ' old

Only one occurrence of each identical data in the Query data tableSELECT DISTINCT (order_no) from Ibsp_record_feeThe data in the Query data table decimal place is not 0SELECT * FROM Ibsp_pay_record PR where Pr.amountOrSELECT * FROM Ibsp_pay_record PR where pr.amount!= cast (pr.amount as Decimal (13,0))Delete table and ID sequenceTRUNCATE TABLE Ibsp_balance_account_data(Oracle)Oracle