Recent questions tagged sql

0 votes

235 views

1 answer

sql server - SQL Express for production?

Is using SQL Express in a production environment a reasonable choice? I looked at Microsoft's comparison ... Express an unreasonable choice? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

861 views

1 answer

sql - Mixing explicit and implicit joins fails with "There is an entry for table ... but it cannot be referenced from this part of the query"

SELECT i.*, r.name AS roomname, c.name AS cat, p.key AS imgkey, p.extension AS imgext FROM items i, ... referenced from this part of the query. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

364 views

1 answer

sql - Convert date to YYYYMM format

I want to select value = 201301 select getdate(), cast(datepart(year, getdate()) as varchar(4))+cast(datepart( ... the normal way to do this? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

333 views

1 answer

sql server - What does the SQL # symbol mean and how is it used?

Can someone please explain to me what the # symbol means in MS SQL Code. I've tried Googling it, and even ... of "those" days. Please help. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

348 views

1 answer

sql - Oracle DB: How can I write query ignoring case?

As I had written in title, I have SQL query, run on Oracle DB, lets say: SELECT * FROM TABLE WHERE TABLE.NAME ... of them, how can this be done? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

287 views

1 answer

sql server - How to declare local variables in postgresql?

There is an almost identical, but not really answered question here. I am migrating an application from MS ... will simplify the translation. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

194 views

1 answer

sql - Add column to table and then update it inside transaction

I am creating a script that will be run in a MS SQL server. This script will run multiple statements and ... executing as a transactional unit. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

201 views

1 answer

sql server - Performance of different approaches to time-based data

I'm asking this in the context of PerformanceDBA's claim in this answer to another question that this query: ... is in some simple tests. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

826 views

1 answer

sql - Trigger Error: The current transaction cannot be committed and cannot support operations that write to the log file

So I am getting the following error message from SQL Server when sp_SomeProc tries to execute an invalid sql statement ... (Val) SELECT 'Hello' See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

482 views

1 answer

sql server - TSQL: Try-Catch Transaction in Trigger

I am trying to put a try-catch statement inside a trigger using Microsoft Server 2005. BEGIN TRANSACTION BEGIN ... there any way around this? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

254 views

1 answer

sql server - Windows Azure SQL Database - Identity Auto increment column skips values

Currently working on an ASP.Net MVC 4 application using Entity Framework 5. Used CodeFirst for initial ... Please share your thoughts. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

298 views

1 answer

sql - RODBC queries returning zero rows

Issue: RODBC (falsely) returning zero rows Situation: I'm using RODBC to connect to a DSN I created using a commercial ... ): [1] tools_2.12.2 See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

318 views

1 answer

sql server - Positioning tables and charts in BIDS SSRS

See (image.1) - As you can see, in the design view I have my two tables on the left and two pie ... or workaround to this would be appreciated. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

257 views

1 answer

sql server - Instead of NULL how do I show `0` in result with SELECT statement sql?

I have one stored procedure which is giving me an output (I stored it in a #temp table) and that output I'm ... statement to make NULL as 0 ? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

286 views

1 answer

sql - How can I join two tables but only return rows that don't match?

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

451 views

1 answer

sql - oracle delete query taking too much time

I have a query like DELETE from tablename where colname = value; which takes awfully long time to execute. What ... have an index on colname. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

278 views

1 answer

sql - PostgreSQL table variable

Is there anything like table variables in T-SQL? In Sql Server it looks like this: DECLARE @ProductTotals ... odetocode.com/Articles/365.aspx See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

290 views

1 answer

sql - Combining (concatenating) date and time into a datetime

Using SQL Server 2008, this query works great: select CAST(CollectionDate as DATE), CAST(CollectionTime as TIME) from ... ? Thanks for any help. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

403 views

1 answer

sql - Operator does not exist: json = json

when I try to select some record from a table SELECT * FROM movie_test WHERE tags = ('["dramatic","women ... learn something about this error. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

391 views

1 answer

sql - How can I insert identity manually?

CREATE TABLE masterTbl ( id INT IDENTITY(1,1) CONSTRAINT pk_id PRIMARY KEY, name VARCHAR(100)) INSERT INTO masterTbl ... ) How is this possible? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

341 views

1 answer

sql - What are the pros/cons of using a synonym vs. a view?

This is a generic database design question - What are the benefits of using a synonym in database development ... FOR IdentitySystem.dbo.LCTs See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

491 views

1 answer

sql - Calculating percentages with GROUP BY query

I have a table with 3 columns which looks like this: File User Rating (1-5) ---------------- ... calculation to apply to each user/rating group. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

331 views

1 answer

sql - Is inner join the same as equi-join?

Can you tell me if inner join and equi-join are the same or not ? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

380 views

1 answer

sql server 2008 - How many characters in varchar(max)?

How many characters can a SQL Server 2008 database field contain when the data type is VARCHAR(MAX)? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

254 views

1 answer

sql - Truncate Table Within Transaction

Can the SQL "truncate table" command be used within a transaction? I am creating an app and my table has a ... the log so that rollback works. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

298 views

1 answer

sql server - SQL count rows in a table

I need to send a SQL query to a database that tells me how many rows there are in a table. I could get all ... in a table to the SQL server? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

308 views

1 answer

sql server 2005 - Updating report parameters based on parameter selection? (SSRS)

I've created a report in SSRS with two report parameters. I'd like the second to update it's values based ... list once they select an agent. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

415 views

1 answer

sql - Database Design Question - Categories / Subcategories

I have a question for how I would design a few tables in my database. I have a table to track Categories ... Server 2008 R2 if that matters. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags