Recent questions tagged SQL

0 votes

269 views

1 answer

sql - Create a trigger that updates a column on one table when a column in another table is updated

i have two tables Order(id, date, note) and Delivery(Id, Note, Date) I want to create a trigger that updates ... get the date and row id? thanks See Question&Answers more detail:os...

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

0 votes

251 views

1 answer

sql server - SQL Bulk import from CSV

I need to import a large CSV file into an SQL server. I'm using this : BULK INSERT CSVTest FROM 'c ... (including MSDN) is terribly unhelpfull. See Question&Answers more detail:os...

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

0 votes

309 views

1 answer

sql - Subtracting Dates in Oracle - Number or Interval Datatype?

I have a question about some of the internal workings for the Oracle DATE and INTERVAL datatypes. According to ... SELECT statement #2). Thanks See Question&Answers more detail:os...

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

0 votes

271 views

1 answer

sql server - SQL query for getting data for last 3 months

How can you get today's date and convert it to 01/mm /yyyy format and get data from the table with delivery ... delivery month as 01/mm/yyyy. See Question&Answers more detail:os...

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

0 votes

261 views

1 answer

sql server - Parse file name and path from full path

I need to parse file name and file path from full path using SQL Query. Eg. Fullpath - ... Path EXPORT001.csv \SERVERD$EXPORTFILES See Question&Answers more detail:os...

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

0 votes

192 views

1 answer

sql - MySQL SELECT x FROM a WHERE NOT IN ( SELECT x FROM b ) - Unexpected result

I expect the result of the third query below to contain id=732. It doesn't. Why is that? mysql> SELECT id ... seen at http://pastebin.ca/1462094 See Question&Answers more detail:os...

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

0 votes

501 views

1 answer

sql - can we have a foreign key which is not a primary key in any other table?

it is written in every book that foreign keys are actually primary key in some other table but can we have a ... primary key in any other table See Question&Answers more detail:os...

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

0 votes

385 views

1 answer

sql server - 900 byte index size limit in character length

What is the total character limit for a 900 byte index limit that SQL Server 2012 has. I created a column ... inside the 900 byte index column? See Question&Answers more detail:os...

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

0 votes

237 views

1 answer

sql - Java JDBC connection status

I am (successfully) connecting to a database using the following: java.sql.Connection connect = DriverManager.getConnection( ... for me to use. See Question&Answers more detail:os...

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

0 votes

370 views

1 answer

sql - How to create an Oracle sequence starting with max value from a table?

Trying to create a sequence in Oracle that starts with the max value from a specific table. Why does this not ... ) INCREMENT BY 1 CACHE 20; See Question&Answers more detail:os...

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

0 votes

203 views

1 answer

sql - What is difference between foreign key and reference key?

I am very confused about those two terms. Are they the same or different? Some books and people say they are ... 't find a conclusive answer. See Question&Answers more detail:os...

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

0 votes

596 views

1 answer

sql - Check if a parameter is null or empty in a stored procedure

I know how to check if a parameter is null but i am not sure how to check if its empty ... I have ... example.. I would appreciate the help. See Question&Answers more detail:os...

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

0 votes

457 views

1 answer

sql - ORDER BY items must appear in the select list if SELECT DISTINCT is specified

I added the columns in the select list to the order by list, but it is still giving me the ... ,rsc.RadioServiceCodeId,rsc.RadioService END See Question&Answers more detail:os...

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

0 votes

232 views

1 answer

sql server - How can I alter a primary key constraint using SQL syntax?

I have a table that is missing a column in its primary key constraint. Instead of editing it through SQL ... and recreate the key constraint? See Question&Answers more detail:os...

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

0 votes

271 views

1 answer

sql - Flattening of a 1 row table into a key-value pair table

What's the best way to get a key-value pair result set that represents column-value in a row? Given the ... + ' FROM TableA' EXEC(@sql) See Question&Answers more detail:os...

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

0 votes

230 views

1 answer

sql server - Data Auditing in NHibernate and SqlServer

I'm using NHibernate on a project and I need to do data auditing. I found this article on codeproject which ... what's dicussed in the article? See Question&Answers more detail:os...

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

0 votes

269 views

1 answer

sql server - Find sql records containing similar strings

I have the following table with 2 columns: ID and Title containing over 500.000 records. For example: ID ... Thanks for any idea or suggestion See Question&Answers more detail:os...

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

0 votes

249 views

1 answer

sql - INET_ATON() and INET_NTOA() in PHP?

I want to store IP addresses in my database, but I also need to use them throughout my application. I read ... address in a database? Thanks. See Question&Answers more detail:os...

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

0 votes

495 views

1 answer

sql - Get previous and next row from rows selected with (WHERE) conditions

For example I have this statement: my name is Joseph and my father's name is Brian This statement is splitted ... How could I get this result? See Question&Answers more detail:os...

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

0 votes

239 views

1 answer

sql - MySQL: Insert datetime into other datetime field

I have a table with a DATETIME column. I would like to SELECT this datetime value and INSERT it into ... is indeed the intended behaviour. See Question&Answers more detail:os...

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

0 votes

479 views

1 answer

sql - Can MySQL convert a stored UTC time to local timezone?

Can MySQL convert a stored UTC time to local time-zoned time directly in a normal select statement? Let's say ... this function, use with care. See Question&Answers more detail:os...

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

0 votes

212 views

1 answer

sql - Get all characters before space in MySQL

I would like to get all the characters in a field before a space For example, if field1 is "chara ters ... this select statement look like? See Question&Answers more detail:os...

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

0 votes

256 views

1 answer

sql - How do I format date and time on ssrs report?

on SSRS report I need to show todays date and current time i tried this =FormatDateTime(Now,"MM/dd/yyyy hh:mm tt") ... like 4/12/2013 12:05 PM See Question&Answers more detail:os...

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

0 votes

373 views

1 answer

sql - Sorting tree with a materialized path?

I have a tree structure in a table and it uses materialized paths to allow me to find children quickly. However, I also ... 5 * id 9 * id 7 See Question&Answers more detail:os...

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

0 votes

410 views

1 answer

sql server - Unique identifier (guid) as primary key in database design

Our data resides in a SQL Server 2008 database, there will be a lot queries and joinings between tables. We have ... a GUID as a primary key? See Question&Answers more detail:os...

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

0 votes

392 views

1 answer

sql server - What is Multi Dimension OLAP CUBE and give example cube with more than 3 dimensions

As I am new to SSAS, have been reading an article on Multi-Dimension OLAP Cube and struggling to ... but also expecting some explanation. See Question&Answers more detail:os...

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

0 votes

181 views

1 answer

sql - How important are lookup tables?

A lot of the applications I write make use of lookup tables, since that was just the way I was taught ( ... queried off of that? Thanks. See Question&Answers more detail:os...

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

0 votes

196 views

1 answer

sql - Generate script for both schema and data

I have a SQL Server database for which I want to generate script of data as well as schema both. I tried ... something that can be used easily See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags