SELECT b.* FROM employee a, dept b WHERE a.id = '00' AND FIND_IN_SET(b.id, a.deptId) FIND_IN_SET is a function of mysql . Other databases are not applicable
sqlserver it seems that the same effect can be achieved through the CHARINDEX function, but there is no environment test
I am using SSMS2017, this version (perhaps earlier version has) has a function, that is, after the cursor is punctuated to something (variable, field, table name, etc.), the same string nearby will be highlighted, such as figure: " " >> similar func...
the data sent from the front desk is of date type, and then query how to report such an error in the field of date type of sql server database based on this data: ,date : : : ...
SELECT Table_1. , Table_2. , Table_3.* FROM ((Table_1 INNER JOIN Table_2 ON Table_1.DataTime = Table_2.DataTime) INNER JOIN Table_3 ON Table_2.DataTime = Table_3.DataTime) where Table_1.DataTime = 1 is not necessarily merging three tables with the same ...
I successfully run the following sql statement to find the ideal data exec sp_executesql N Select * FROM FC_Repair WHERE F_RepairDepartmentId in ( ace7f0e7-f158-4587-920d-e76546885198 , bf421a22-786b-40fd-8af...
could you tell me how to query the sql statement and how to implement it on ef? thank you ...
The sql statement is as follows SELECT sum(case when CONVERT(varchar(100), b.BillDate, 112) >= 20180101 AND CONVERT(varchar(100), b.BillDate, 112) < 20180126 then b.totalmoney else 0 end)AS , sum(case when CONVERT(varchar(100), b.BillDate, 11...
does the, CASE WHEN THEN statement have to be used with the select statement in SQL server? declare @i int set @i=100 case @i when 100 then print 100 when 200 then print 200 else print 300 end the above statement reported an error ...
recently, I am working on a book information management system. There is a table marc that stores the information of books. There are more than 20 fields in it. when importing data, it is required to check the duplicates according to 7 fields, and the...