Recent questions tagged SQL

0 votes

275 views

1 answer

sql server - Populate Dataset With Table Names From Stored Procedure

I have a stored procedure that returns multiple tables. It populates my dataset correctly but it names my tables ... name the tables properly? See Question&Answers more detail:os...

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

0 votes

347 views

1 answer

sql server - CHECKSUM and CHECKSUM_AGG: What's the algorithm?

We perform checksums of some data in sql server as follows: declare @cs int; select @cs = CHECKSUM_AGG(CHECKSUM( ... . Can anyone enlighten me? See Question&Answers more detail:os...

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

0 votes

211 views

1 answer

sql server displaying missing dates

SiteVisitID siteName visitDate --------------------------------------------------- ... and columns are simplified version of the actual table See Question&Answers more detail:os...

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

0 votes

455 views

1 answer

sql server 2008 - How can I retain CDATA tags when storing query results in an Xml variable?

When I generate Xml in Sql Server 2008 R2 using For Explicit (because my consumer wants one of the elements ... End Try Begin Catch End Catch See Question&Answers more detail:os...

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

0 votes

271 views

1 answer

sql server 2008 - Column does not exist in the IN clause, but SQL runs

I have a query that uses the IN clause. Here's a simplified version: SELECT * FROM table A JOIN table B ... message. Can anyone explain why? See Question&Answers more detail:os...

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

0 votes

423 views

1 answer

sql server 2008 - SQL: Using DATEADD with bigints

I have some SQL to convert javascript dates to SQL dates which works great. However, I've encoutered some data ... this on SQL Server 2008. See Question&Answers more detail:os...

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

0 votes

343 views

1 answer

sql - java.lang.UnsatisfiedLinkError: no sqljdbc_auth in java.library.path

I'm created a .jar of my java application, and when i'm try to run that .jar from cmd, i get an error ... >(AuthenticationJNI.java:3 ... 28 more See Question&Answers more detail:os...

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

0 votes

458 views

1 answer

sql server - How to Bulk Insert from XLSX file extension?

Can anyone advise how to bulk insert from .xlsx file? I tried the below query already: BULK INSERT #EVB FROM 'C ... , there is no error message. See Question&Answers more detail:os...

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

0 votes

481 views

1 answer

sql server 2008 - SSIS LookUp is not dealing with NULLs like the docs say it should

I have an SSIS data flow that uses a lookup. Sometimes the value to be looked up (in my stream, not in the ... have a look up value for null.) See Question&Answers more detail:os...

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

0 votes

373 views

1 answer

sql - Why am I getting a "[SQL0802] Data conversion of data mapping error" exception?

I am not very familiar with iseries/DB2. However, I work on a website that uses it as its primary database. ... those bad records in my query? See Question&Answers more detail:os...

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

0 votes

338 views

1 answer

sql - Ambiguous column name error

When executing the following (complete) SQL query on Microsoft SQL Server 2000: SELECT B.ARTIFACTTNS, B.ARTIFACTNAME, ... how can I correct it? See Question&Answers more detail:os...

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

0 votes

371 views

1 answer

sql - Find last day of a month in Hive

My question is : Is there a way to do find the last day of a month in Hive, like Oracle SQL function ? : LAST_DAY(D_Dernier_Jour) Thanks. See Question&Answers more detail:os...

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

0 votes

226 views

1 answer

sql server - SQL Functions - factorial

I am a beginner in SQL Functions. What is the best way to create a function for factorial in SQL Server- Say 10! See Question&Answers more detail:os...

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

0 votes

460 views

1 answer

sql server - The INSERT statement conflicted with the FOREIGN KEY constraint

Error: System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint " ... the Item table. See Question&Answers more detail:os...

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

0 votes

338 views

1 answer

sql server 2005 - Selecting GETDATE() function twice in a select list-- same value for both?

I have a SELECT statement that uses GETDATE() for two different column values. I'm wondering if by the ... return identical values every time? See Question&Answers more detail:os...

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

0 votes

207 views

1 answer

sql server - Full text catalog/index search for %book%

I'm trying to wrap my head around how to search for something that appears in the middle of a word / ... "rebooked" or something like that. See Question&Answers more detail:os...

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

0 votes

908 views

1 answer

sql server - Pyodbc: Login Timeout Error

I am trying to connect to MS SQL Server using pyodbc from a remote machine running Ubuntu 16.04. import pyodbc ... pyodbc version is 4.0.23 See Question&Answers more detail:os...

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

0 votes

243 views

1 answer

sql - How to deal with semantic version data type in BigQuery

I know that there is no data type in BigQuery. What would you prefer to deal with semantic versions in BigQuery? ... - is used for prerelease. See Question&Answers more detail:os...

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

0 votes

239 views

1 answer

sql - Query to ORDER BY the number of rows returned from another SELECT

I'm trying to wrap my head around SQL and I need some help figuring out how to do the following query in ... result of user_id in the select. See Question&Answers more detail:os...

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

0 votes

286 views

1 answer

sql server - How do you group by any time based interval?

In SQL SERVER How do you group by any time based interval? To save someone time I have come up with ... TIMES)/@interval)*@interval),@startdate) See Question&Answers more detail:os...

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

0 votes

451 views

1 answer

sql - Function to get number of weekdays between two dates excluding holidays

I have an sql query that casts 2 dates and checks if they are equal. But even though the dates are ... THEN RETURN NULL; END getWorkingDays;' See Question&Answers more detail:os...

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

0 votes

266 views

1 answer

sql - Oracle pivot operator

I am new to oracle pivot. Is this possible? I have two columns Type and Value type value --------------- a ... ---- A B null b1 a1 null Thanks See Question&Answers more detail:os...

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

0 votes

177 views

1 answer

sql - Returning result even for elements in IN list that don't exist in table

I am trying to find the easiest way to return a result set that indicates if some values are or are not present ... ... (working with Oracle 11) See Question&Answers more detail:os...

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

0 votes

245 views

1 answer

sql - how to design a schema where the columns of a table are not fixed

I am trying to design a schema where the columns of a table are not fixed. Ex: I have an Employee ... , indexing, performance, reporting etc. See Question&Answers more detail:os...

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

0 votes

222 views

1 answer

sql server - What Kind of Relationship is Between These Tables?

I have two tables that have foreign keys to each other's primary key. This DB is in French. I will ... here: Example records for some tables See Question&Answers more detail:os...

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

0 votes

193 views

1 answer

sql - How do I create a cross reference table/query for my data?

I have two simple tables in my database. A "card" table that contains Id, Name, and text of a card, ... " solutions are greatly accepted here. See Question&Answers more detail:os...

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

0 votes

223 views

1 answer

sql - Oracle get checksum value for a data chunk defined by a select clause

Is there any method in SQL (Oracle) using which I can get something like: select checksum(select * from table) from table; See Question&Answers more detail:os...

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

0 votes

250 views

1 answer

sql - Return a query from a function?

I am using PostgreSQL 8.4 and I want to create a function that returns a query with many rows. The ... to use functions as query templates. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags