Recent questions tagged SQL

0 votes

856 views

1 answer

sql server - mssql convert varchar to float

I have a field value productlength of 0.123. This is from a view and has a data type of varchar. I need ... string? Any clever ways around this? See Question&Answers more detail:os...

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

0 votes

877 views

1 answer

sql server - INSERT INTO with exec with multiple result sets

SQL Server allows me to insert the returned result set of a stored procedure as: DECLARE @T TABLE ( ID ... INTO @T2 exec dbo.pVendorBalance See Question&Answers more detail:os...

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

0 votes

811 views

1 answer

sql - The ALTER TABLE statement conflicted

alter FUNCTION [Kuri].[fnGetAge](@kuri_cust_Id int,@amt decimal) RETURNS SMALLINT AS BEGIN DECLARE ... CONSTRAINT [FK_Payment_kuri_Customer] See Question&Answers more detail:os...

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

0 votes

899 views

1 answer

sql - Bulk load data conversion error (truncation)

I am getting this error Bulk load data conversion error (truncation) for row 1, column 12 (is_download) here ... this record to have this error See Question&Answers more detail:os...

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

0 votes

748 views

1 answer

sql server 2008 - Cannot access temporary tables from within a function

I would like to get count of specific records. So my query will look like the following... SELECT ID, NAME, ... way to accomplish the task ? See Question&Answers more detail:os...

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

0 votes

877 views

1 answer

sql server - Permissions issue in SSMS: "The SELECT permission was denied on the object 'extended_properties', database 'mssqlsystem_resource', ... Error 229)"

Here's the simplest repro case possible. Create a brand new database. (I'm using SQL 2005.) Create a login, ... dbo.TestTable VALUES (1000) GO See Question&Answers more detail:os...

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

0 votes

686 views

1 answer

sql server - performance of union versus union all

I have to run a select statement across several tables. I am sure the tables return different records. I ... tables return different records? See Question&Answers more detail:os...

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

0 votes

544 views

1 answer

sql - MySQL columns with DEFAULT NULL - stylistic choice, or is it?

In many flavors of SQL, there are three ways you can implicitly set a column to NULL on every row ... I made any incorrect assumptions. See Question&Answers more detail:os...

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

0 votes

743 views

1 answer

sql - SELECT $ (dollar sign)

I have good experience in SQL Server, But suddenly I discovered this strange SELECT command SELECT $ or SELECT $ FROM ... of 0.00 What is that? See Question&Answers more detail:os...

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

0 votes

715 views

1 answer

sql - TSQL DateDiff to return number of days with 2 decimal places

I need to compare 2 dates and return the number of days in between with 2 decimal places. For ... HoursBeforeFirstCall None seem to work. See Question&Answers more detail:os...

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

0 votes

704 views

1 answer

sql - update query with join on two tables

I have customer and address tables. Query: SELECT * FROM addresses a, customers b WHERE a.id = b.id returns 474 ... this does not seem to work. See Question&Answers more detail:os...

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

0 votes

565 views

1 answer

sql - WHERE clause using values that could be NULL

I need to do something like this: DECLARE @firstname VARCHAR(35) DECLARE @lastname VARCHAR(35) SELECT * FROM ... any way to accomplish this? See Question&Answers more detail:os...

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

0 votes

682 views

1 answer

sql server - Handling Timeouts inside stored procedures

I have a stored procedure that executes a couple of queries. Each query might fail because of a timeout. ... make the application more complex. See Question&Answers more detail:os...

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

0 votes

594 views

1 answer

sql - How to eliminate non-working hours in Oracle

I have two columns of DateTime type. The first one stores the DateTime when a process it started, the other ... -between-two-dates-in-oracle See Question&Answers more detail:os...

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

0 votes

643 views

1 answer

sql - Select Sum and multiple columns in 1 select statement

Is there a way to select the sum of a column and other columns at the same time in SQL? Example: SELECT sum(a) as car,b,c FROM toys See Question&Answers more detail:os...

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

0 votes

590 views

1 answer

sql server - .NET database calls slow when using COM Interop, fast via query analyser

I have an Sql query that looks up a person based on SSN and returns the PersonID (identity column). There ... query plan as the other clients. See Question&Answers more detail:os...

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

0 votes

711 views

1 answer

sql - Get the number of digits after the decimal point of a float (with or without decimal part)

I have following list of Amount (float) in my table. Amount 123 123.1 123.0123 123.789456 How can i get ... to handle this. My answer is below See Question&Answers more detail:os...

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

0 votes

634 views

1 answer

sql - Generate a sequential number (per group) when adding a row to an Access table

I have an MS Access (.accdb) table with data like the following: Location Number -------- ------ ABC ... with as question was put on-hold See Question&Answers more detail:os...

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

0 votes

689 views

1 answer

sql - How to concatenate multiple rows?

I have the following query which returns the salary of all employees. This work perfectly but I need to collect extra ... Five, Six 3 350 Seven See Question&Answers more detail:os...

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

0 votes

602 views

1 answer

sql server 2005 - Splitting variable length delimited string across multiple rows (SQL)

I have a table that contains in one column a variable length delimited string for example: 20,0, 5,,^24,0, ... Any ideas of a better approach? See Question&Answers more detail:os...

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

0 votes

601 views

1 answer

sql - How to create Alternative Row Background colors in SSRS for values in a group

I am using this expression to get alternative colors for my row group: =iif(RunningValue(Fields!Status_Reason.Value, ... This is my groups: See Question&Answers more detail:os...

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

0 votes

644 views

1 answer

sql - How do I read this text file and Insert into MySQL?

sample user id User Name U456 Mathew U457 Leon U458 Cris U459 Yancy U460 Jane and so on up to 500k. I need to read ... How do I do this in PHP? See Question&Answers more detail:os...

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

0 votes

818 views

1 answer

sql - SSRS - Group_Concat Equivalent using an Expression?

Can I use expressions in Sql Server Reporting services to combine all of the values of a column within a group? I'm trying ... A, B test 2 C, D See Question&Answers more detail:os...

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

0 votes

534 views

1 answer

sql - Set empty strings ('') to NULL in the whole database

In my database are many text columns where values are empty strings (''). The empty strings need to be set to ... empty strings ('') to NULL? See Question&Answers more detail:os...

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

0 votes

616 views

1 answer

sql server - Write advanced SQL Select

Item table: | Item | Qnty | ProdSched | | a | 1 | 1 | | b | 2 | 1 | | c | 3 | 1 | | a | 4 | 2 | | b | 5 | ... | 4 | | b | 2 | 5 | | c | 3 | 6 | See Question&Answers more detail:os...

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

0 votes

898 views

1 answer

sql server 2005 - Get number of weekdays (Sundays, Mondays, Tuesdays) between two dates SQL

So, I'd like to, for a Start Date and End Date, determine how many particular days of the week occur ... be supported in SQL Server 2005+) See Question&Answers more detail:os...

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

0 votes

615 views

1 answer

sql server - SQL query problem

Let′s say I have two tables, "Garden" and "Flowers". There is a 1:n-relationship between these tables, ... in flowers) myGarden rose tulip See Question&Answers more detail:os...

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

0 votes

793 views

1 answer

sql - Error while using ExecuteNonQuery c#

I have a problem while using ExecuteNonQuery. This is my code : var connString = @"Data Source=serwer01;Initial ... it. Maybe anyone know it? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags