Recent questions tagged Sql

0 votes

264 views

1 answer

sql - How to perform a select query in a DO block?

I want to port the below SQL code from MS SQL-Server to PostgreSQL. DECLARE @iStartYear integer DECLARE @iStartMonth ... to create a function. See Question&Answers more detail:os...

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

0 votes

646 views

1 answer

sql - how to get max(date) from given set of data grouped by some fields using pyspark?

I have the data in the dataframe as below: datetime | userId | memberId | value | 2016-04-06 16:36: ... the given data using PySpark dataframes? See Question&Answers more detail:os...

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

0 votes

353 views

1 answer

sql - using Table variable with sp_executesql

I have a query that contain a table variable: DECLARE @Selects XML ; SET @Selects='<Selects><Select><Q_ID>1< ... the table variable to my query? See Question&Answers more detail:os...

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

0 votes

273 views

1 answer

sql - Differences between "foreign key" and "constraint foreign key"

I mean for example I can create table like create table XTable ( idt int not null primary key, value ... example. What is the difference? See Question&Answers more detail:os...

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

0 votes

539 views

1 answer

sql - BULK INSERT with variable file name

i am trying to bulk insert into Db using sql server 2005 Below is the code. declare @path varchar(500) set ... Please advise how to fix this See Question&Answers more detail:os...

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

0 votes

356 views

1 answer

sql server - Editing Record issues in Access / SQL (Write Conflict)

a problem has come up after a SQL DB I used was migrated to a new server. Now when trying to edit a ... a time using INSERT INTO from Access. See Question&Answers more detail:os...

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

0 votes

349 views

1 answer

sql server - Should I get rid of clustered indexes on Guid columns

I am working on a database that usually uses GUIDs as primary keys. By default SQL Server places a clustered ... offer this as a recommendation? See Question&Answers more detail:os...

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

0 votes

594 views

1 answer

sql - Meaning of "Select tables optimized away" in MySQL Explain plan

What is the meaning of Select tables optimized away in MySQL Explain plan? explain select count(comment_count) ... output edited for legibility. See Question&Answers more detail:os...

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

0 votes

599 views

1 answer

sql - The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'

SETUP: SQL Server 2005 & DotNetNuke 05.01.02. This started with me trying to install a DNN Module that had " ... How can I make this work? See Question&Answers more detail:os...

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

0 votes

324 views

1 answer

sql server 2008 - SQL Query with NOT LIKE IN

Please help me to write a sql query with the conditions as 'NOT LIKE IN' Select * from Table1 where EmpPU NOT ... ', '%EEE%') Getting error. See Question&Answers more detail:os...

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

0 votes

228 views

1 answer

sql - How to import Excel files with different names and same schema into database?

How to import data into a sql server table in SSIS from an excel source file that has different file names each ... abc123, 123abc,ab123c etc.,) See Question&Answers more detail:os...

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

0 votes

316 views

1 answer

sql - Finding the count of characters and numbers in a string

Hi I have a table test as below NAME --------- abc1234 XYZ12789 a12X8b78Y9c5Z I try ... the abcdefghijklmnopqrstuvwxyz and 1234567890 manually See Question&Answers more detail:os...

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

0 votes

274 views

1 answer

sql server - How do I periodically rebuild a reporting table that is very frequently accessed?

It takes about 5-10 minutes to refresh a prepared reporting table. We want to refresh this table constantly ... process in a large transaction? See Question&Answers more detail:os...

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

0 votes

393 views

1 answer

sql server - datediff rounding

I have a db table in SQL Server which contains a start date for a project. On a web status page I want to ... . Is there a better way? thanks See Question&Answers more detail:os...

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

0 votes

284 views

1 answer

sql - Group by values that are in sequence

I have some table like this row chequeNo 1 15 2 19 3 20 4 35 5 16 and I need to get the result ... possible? Would be grateful for any help See Question&Answers more detail:os...

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

0 votes

232 views

1 answer

sql - How to sort values in columns and update table?

I'm completely new to sql and can't do that myself. So I need your help. I want to sort values in ... save changes in table? Please, help. See Question&Answers more detail:os...

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

0 votes

311 views

1 answer

sql server - How to debug stored procedure in VS 2015?

I know this was asked many times, I've read them. I've checked the [Enable SQL Server debugging] in all my ... VS editor. What am I missing? See Question&Answers more detail:os...

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

0 votes

288 views

1 answer

sql - SQLXML without XML encoding?

I'm using a generic system for reporting which takes data from a database view (SQL Server 2005). In this view I ... .. Thanks for your help... See Question&Answers more detail:os...

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

0 votes

272 views

1 answer

sql - python + sqlite, insert data from variables into table

I can insert hardcoded values into an SQLite table with no problem, but I'm trying to do something like this: ... me in the right direction. See Question&Answers more detail:os...

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

0 votes

623 views

1 answer

sql server - How do I do nested transactions in NHibernate?

Can I do nested transactions in NHibernate, and how do I implement them? I'm using SQL Server 2008, so support ... way of emulating the same... See Question&Answers more detail:os...

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

0 votes

260 views

1 answer

sql server - Backup Permissions

I created a new user on the server that will access certain databases. But when I go to backup or ... role. What permissions are required? See Question&Answers more detail:os...

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

0 votes

468 views

1 answer

sql server - case statement in SQL, how to return multiple variables?

I would like to return multiple values in my case statement, such as : SELECT CASE WHEN <condition 1> THEN < ... condition 2. what will happen? See Question&Answers more detail:os...

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

0 votes

282 views

1 answer

sql - How to profile MySQL

How do I profile a MySQL database. I want to see all the SQL being run against a database. I know you ... the results from running a website. See Question&Answers more detail:os...

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

0 votes

363 views

1 answer

sql server - How to format a numeric column as phone number in SQL

I have table in the database with a phone number column. The numbers look like this: 123456789 I want to format ... look like this: 123-456-789 See Question&Answers more detail:os...

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

0 votes

449 views

1 answer

sql - Distinct random time generation in the fixed interval

I'm trying to generate a random time between 8:00 AM and 8:00 PM for each row that is selected from a ... a difference to anyone's suggestions). See Question&Answers more detail:os...

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

0 votes

396 views

1 answer

sql - INSERT INTO TABLE from comma separated varchar-list

Maybe i'm not seeing the wood for the trees but i'm stuck, so here's the question: How can i import/ ... TABLE #IMEIS; Thank you in advance. See Question&Answers more detail:os...

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

0 votes

541 views

1 answer

sql - Double Dot table qualifier

I am looking at a new database schema developed by an external vendor. There are two databases: Database1 ... dbo schema in database2. See Question&Answers more detail:os...

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

0 votes

380 views

1 answer

sql - How to get the last day of month in postgres?

How to find the last day os the month in postgres? I have a date columns stored as numeric(18) in the format( ... -6.fc3), Redshift 1.0.874 See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags