Recent questions tagged SQL

0 votes

898 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

898 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

853 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

932 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

774 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

906 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

715 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

566 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

776 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

736 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

745 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

597 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

704 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

629 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

675 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

612 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

732 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

656 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

728 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

630 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

620 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

672 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

851 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

565 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

658 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

926 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

650 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

828 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