sql
Index for efficient full text search using "LIKE" syntax
I have an applicatio开发者_开发知识库n which sends queries like the following to the database:[详细]
2023-04-13 03:55 分类：问答How to effectively refresh many to many relationship
Lets say I have entity A, which have many to many relationship with another entities of type A. So on entity A, I have collection of A. And lets say I have to \"update\" this relationships according t[详细]
2023-04-13 03:31 分类：问答Where is sysxlogins in Management Studio?
During the script processing I have this error: \"Supplied parameter s开发者_如何学运维id is in use.\"[详细]
2023-04-13 03:13 分类：问答Is this a correct way to allow wildcard search for a user?
Given a textbox name for example, the user requirement wants to be able to do a wildcard search (such as contains, starts with, ends with).[详细]
2023-04-13 03:11 分类：问答SQL Optimization: CONNECT BY ... START WITH
I have a query using CONNECT BY and START WITH statement like below. The query in the IN clause took less than 5 seconds to run and returns 3000 rows. fact_table contains 20M of records. How can I opt[详细]
2023-04-13 03:09 分类：问答SQL: Combining results
SELECT * FROM `restaurants` WHERE name LIKE \'%string%\' SELECT * FROM `restaurants` WHERE address LIKE \'%string%\'[详细]
2023-04-13 02:56 分类：问答Why doesn't a separately instantiated Func<T,bool> predicate not translate into SQL with Entity Framework?
I have an EF Code First Db context that I\'m using to query the database. I noticed some performance issues when passing in queries as Func<Product, bool>s from my Aggregate Repository and on in[详细]
2023-04-13 02:53 分类：问答How to get max value from 2 tables
Using Sql Server I want to get 开发者_运维问答max value from two table Table1 ID Total 101 100 102 600[详细]
2023-04-13 02:52 分类：问答strange sql error
i have the following code: <!--ajouter une carte--> <?php if($_POST[\"submit_dd\"]){ mysql_query(\"INSERT INTO data SET desc=\'\".$_POST[\"carte_nom\"].\"\' \") or die(mysql_error());[详细]
2023-04-13 02:47 分类：问答Deleting Related Rows in a Many-to-Many Relationship
I\'m deleting a row in a table that is on one site of a many-to-many relationship. I would also like to delete any related rows on the other side of that relationship.[详细]
2023-04-13 02:35 分类：问答
加载中,请稍侯......