Recent questions tagged sql

0 votes

1.0k views

1 answer

I have a table like this Date Year Month Day Turn_1 Turn_2 Turn_3 28/08/2014 2014 08 28 Foo Bar Xab And i ... Turn_2', turn_3 as 'Turn_3' )) See Question&Answers more detail:os...

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

0 votes

813 views

1 answer

sql server ce - SQLServerCE Problem with parameterized queries from .NET

I am pulling the hair out of my head trying to figure this one out. I can't make Parameterized queries to work ... db.Close() End Sub End Class See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql server - Conversion failed in cursor in stored procedure

Input like 111111 and 101,102,103,104 I want to check whether user has access on this requests or not.. ... RETURN @Result END Thanks in advance See Question&Answers more detail:os...

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

0 votes

863 views

1 answer

sql server - Get Sundays For a given month Date in a function SQL

I am facing a problem. I want to get no of sunday in a month using a function although i have achieved a ... )%7 in (4) return @fdays end See Question&Answers more detail:os...

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

0 votes

892 views

1 answer

sql - conditional stored procedure with/without passing parameter

I created a stored procedure which when passed nothing as parameter should return the entire table. But if the ... of the table? Thank you See Question&Answers more detail:os...

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

0 votes

823 views

1 answer

sql server - SSIS failing to save packages and reboots Visual Studio

This is my first experience with SSIS so bear with me... I am using SSIS to migrate tables from Oracle to ... really holding up my work. HELP! See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - mysql - Dynamic column alias

Hi I have "sql query" to see number of the job done for each member in the last week so I create "sql query ... use near 'NOW()-INTERVAL 1 WEEK See Question&Answers more detail:os...

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

0 votes

867 views

1 answer

sql server - Force SET IDENTITY_INSERT to take effect faster from MS Access

I'm working on upsizing a suite of MS Access backend databases to SQL Server. I've scripted the SQL to ... the switch at the client location. See Question&Answers more detail:os...

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

0 votes

771 views

1 answer

sql server: generate primary key based on counter and another column value

I am creating a customer table with a parent table that is company. It has been dictated(chagrin) that I ... me strange results without it. See Question&Answers more detail:os...

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

0 votes

942 views

1 answer

sql - Join tables with rows

I am trying to join three tables in SQL Server 2008 R2, where I want the items in the second table to ... this, any help would be appreciated. See Question&Answers more detail:os...

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

0 votes

840 views

1 answer

sql - Inserting MS Access Row Into Database using vb.net

So im trying to add fields to a database. It is .mdb database, microsoft access. The Name of the ... autoincrements, does this change anything? See Question&Answers more detail:os...

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

0 votes

725 views

1 answer

sql server - How to use dynamic SQL to add value of 2 columns

I have small table which contains students marks. Table data is shown in below image. It is look like below ... AS P' EXEC SP_EXECUTESQL @SQL See Question&Answers more detail:os...

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

0 votes

941 views

1 answer

sql - Why Oracle is saying not a GROUP BY expression?

I am Trying to retrive data from the Oracle database table with following conditions All entries found by zip ... will be greatly appreciated See Question&Answers more detail:os...

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

0 votes

824 views

1 answer

sql - How to use dynamic column names in an UPDATE or SELECT statement in a function?

In PostgreSQL 9.1, PL/pgSQL, given a query: select fk_list.relname from ... where relname is of type name ... . Is there a better way? See Question&Answers more detail:os...

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

0 votes

804 views

1 answer

sql server - Create XML with variable element names from a data table with values and names

I wasn't able to find a relevant post, so I decided to ask. I have the following table in my SQL ... >IRVTBEBB</buy57ref> </Message> Thanks See Question&Answers more detail:os...

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

0 votes

835 views

1 answer

sql - How to SUM from MySQL for every n record

I have a following result from query: +---------------+------+------+------+------+------+------ ... ------+-------+ How to make this possible ? See Question&Answers more detail:os...

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

0 votes

999 views

1 answer

sql - Trimmining a column with bad data

My data looks like ID LPNumber 1 30;#TEST123 2 302;#TEST1232 How can I update MyText to drop everything before the ... of checking for the ";" See Question&Answers more detail:os...

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

0 votes

896 views

1 answer

sql - how to create ISO-8601 gregorian date table in postgres

I'm looking to create a date table in a postgres database. The sample data is expected to look like ... this direction would be appreciated. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql server - Hibernate + MSSQL + Fulltext Search via Contains

My goal is to use the MSSQL Fulltext Function with HQL. For what case I wrote a specific SQLFunction mapping the ... .6ga and MSSQL Server 2008. See Question&Answers more detail:os...

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

0 votes

867 views

1 answer

sql server - SQL select print out results of stored procedure

My businesses application supports only reporting with selected data from SQL server.In one business ... go exec sp_test_print_out_to_select See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql server 2008 r2 - SSIS how to convert string (DT_STR) to money (DT_CY) when source has more than 2 decimals

I have a source flat file with values such as 24.209991, but they need to load to SQL Server as type money. ... . That's getting a cast error. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql - mysql select to return blanks for all but first row of repeating column

Is it possible to create a mysql select (directly or using a stored procedure) that will return blanks for ... blanks within the sql call. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql - Access VBA to trim space around a specific character or words(s) in a column

I have this piece of code that originally uses the replace function(VBA) to replace certain characters in a ... wrong. Thanks everyone! Guy See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - Postgres Copy from Variable with CSV data

I know you can run a copy command like this from a file: "COPY zip_codes FROM '/path/to/csv/ZIP_CODES.txt' ... {csv_data}' DELIMITER ',' CSV;" See Question&Answers more detail:os...

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

0 votes

831 views

1 answer

sql - Columns to Rows in MS Access

I am trying to create a query in MS Access to ultimately take the output from this: Name Cat 1 Cat 2 Cat 3 Cat 4 Cat 5 ... 5 X4 0 1 0 X5 0 9 9 See Question&Answers more detail:os...

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

0 votes

966 views

1 answer

sql - Difference between two columns in mysql

I have two columns (credit and debited_amount) and I want to calculate the difference between them.Only need to ... WHERE `expires_on`>now(); See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - making Linq case sensitive

I am using vs 2010 with linq to sql and sql server 2008. how would i made this case sensitive var Groups ... =abc and groupname=ABC is same See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql server - BULK insert error with UNC path and windows Authentication

I have two servers, One is application server which has webservice and other server is a DB server,which has ... issue. Thanks in advance Sai See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags