sql
django/python: raw sql with multiple tables
I need to perform a raw sql on multiple tables. I then render the result set. For one table I would do:[详细]
2023-04-13 08:41 分类:问答Join a table to itself
this is one on my database tables template. Id int开发者_运维百科 PK Title nvarchar(10) unique ParentId int[详细]
2023-04-13 08:37 分类:问答Hitting stored proc - javax.ejb.EJBException
I\'m trying to hit a stored procedure but I\'m getting this error message: \'javax.ejb.EJBException\'... I\'ve never worked with stored procedures so the exception is a bit Greek to me.[详细]
2023-04-13 08:37 分类:问答Failed to enable constraints. When using a data table adapter
I\'m getting Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.[详细]
2023-04-13 08:06 分类:问答How to add links to related posts on the current post page PHP SQL
Im quite new to php and sql and Im trying to build a news site and im really stuck on trying to display a list of links to posts related to the current post being displayed,here is the code for the to[详细]
2023-04-13 08:02 分类:问答How to get ID for INSERT if name already used, else generate new one
I\'m having a bit of trouble with an INSERT query. I have a table I\'m inserting a value into that\'s like this:[详细]
2023-04-13 07:57 分类:问答SQL Server 2008 datetime type time comparison
Is the following query the most inefficient way to filter by only the time part datetime field in SQL Server 2008?[详细]
2023-04-13 07:54 分类:问答Grouping MySQL results to only allow a record to add to the total if the last one found is over two hours old
I am currently tracking actions performed by employees in a table, which has three rows: id, user_id, and action_time, customer_id. In order to track performance, I can simply pick an employee on a da[详细]
2023-04-13 07:50 分类:问答Restricting the access to specific pages
I\'m building a quiz web application.The functionality of the site is just about complete.However, I\'d like to create a script that allows me to input new quizzes and questions from my web browser as[详细]
2023-04-13 07:39 分类:问答Find which parameters of stored procedures are nullable (optional)
I know I can use the following query to find all stored procedures and thei开发者_运维问答r parameters :[详细]
2023-04-13 07:29 分类:问答