Trending questions in Database

0 votes
0 answers

How can I select the first day of a month in SQL?

I only need to choose the given ...READ MORE

Aug 14, 2022 in Database by Kithuzzz
 • 38,000 points • 665 views
0 votes
0 answers

Where can I find the Northwind database for Microsoft SQL Server 2008

To hone my Linq-fu , I'm looking ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
 • 38,000 points • 615 views
0 votes
0 answers

Login to Microsoft SQL Server Error: 18456

When I try to connect to the SQL ...READ MORE

Aug 14, 2022 in Database by Kithuzzz
 • 38,000 points • 659 views
0 votes
0 answers

Creating a new database and new connection in Oracle SQL Developer

I've introduced SQL Developer to my framework. ...READ MORE

Aug 12, 2022 in Database by Kithuzzz
 • 38,000 points • 737 views
0 votes
0 answers

What is the difference between drop table and delete table in SQL Server?

What is the distinction between the following ...READ MORE

Aug 9, 2022 in Database by Kithuzzz
 • 38,000 points • 860 views
0 votes
0 answers

DateTime2 vs DateTime in SQL Server

Which one: datetime datetime2 is the recommended way to store date and ...READ MORE

Aug 14, 2022 in Database by Kithuzzz
 • 38,000 points • 639 views
0 votes
0 answers

Remove Identity from a column in a table

When we try to remove the identity ...READ MORE

Aug 18, 2022 in Database by Kithuzzz
 • 38,000 points • 463 views
0 votes
0 answers

Find the number of columns in a table

If a table's number of rows and ...READ MORE

Aug 20, 2022 in Database by Kithuzzz
 • 38,000 points • 362 views
0 votes
0 answers

Why is SQL Server Agent not starting?

On top of Windows Server 2012, I ...READ MORE

Aug 9, 2022 in Database by Kithuzzz
 • 38,000 points • 780 views
0 votes
0 answers

Update Query with INNER JOIN between tables in 2 different databases on 1 server

Both databases are on the same server. db1 ...READ MORE

Aug 12, 2022 in Database by Kithuzzz
 • 38,000 points • 648 views
0 votes
0 answers

Simple DateTime sql query

How do I query the DateTime database ...READ MORE

Aug 12, 2022 in Database by Kithuzzz
 • 38,000 points • 627 views
0 votes
0 answers

Import .bak file to a database in SQL server

I have a file with .bak extension. How ...READ MORE

Aug 14, 2022 in Database by Kithuzzz
 • 38,000 points • 521 views
0 votes
0 answers

SQL use CASE statement in WHERE IN clause

Can you use a case statement in ...READ MORE

Aug 9, 2022 in Database by Kithuzzz
 • 38,000 points • 739 views
0 votes
0 answers

How to export and import a .sql file from command line with options?

I need to commodity and import a ...READ MORE

Aug 13, 2022 in Database by Kithuzzz
 • 38,000 points • 558 views
0 votes
0 answers

Scott account locked in SQL Plus

Scott is my username and tiger is ...READ MORE

Aug 9, 2022 in Database by Kithuzzz
 • 38,000 points • 698 views
0 votes
0 answers

SQL Injection Exploiting Login form

I was pondering while at the same ...READ MORE

Aug 12, 2022 in Database by Kithuzzz
 • 38,000 points • 561 views
0 votes
0 answers

Adding an identity to an existing column

There are currently several rows in the ...READ MORE

Aug 14, 2022 in Database by Kithuzzz
 • 38,000 points • 475 views
0 votes
0 answers

What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?

What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL ...READ MORE

Aug 13, 2022 in Database by Kithuzzz
 • 38,000 points • 507 views
0 votes
1 answer

Disable Sorting in excel

You may discover that adding a filter, ...READ MORE

Apr 5, 2022 in Database by gaurav
 • 23,260 points • 6,043 views
0 votes
0 answers

Find stored procedure by name

Is there a way to search for ...READ MORE

Aug 13, 2022 in Database by Kithuzzz
 • 38,000 points • 486 views
0 votes
0 answers

How to run SQL script in MySQL?

I want to use MySQL to run ...READ MORE

Aug 11, 2022 in Database by Kithuzzz
 • 38,000 points • 564 views
0 votes
0 answers

Creating tables in sqlite database on android

@Override ...READ MORE

Aug 11, 2022 in Database by Kithuzzz
 • 38,000 points • 538 views
0 votes
0 answers

Query to check index on a table

I want a query to see if ...READ MORE

Aug 11, 2022 in Database by Kithuzzz
 • 38,000 points • 525 views
0 votes
0 answers

What's the difference between TRUNCATE and DELETE in SQL

What distinguishes SQL's TRUNCATE and DELETE operations? Please ...READ MORE

Aug 11, 2022 in Database by Kithuzzz
 • 38,000 points • 521 views
0 votes
0 answers

Removing leading zeroes from a field in a SQL statement

I'm dealing with a SQL question that ...READ MORE

Aug 12, 2022 in Database by Kithuzzz
 • 38,000 points • 425 views
0 votes
0 answers

How do I list all the columns in a table?

For the various popular database systems, how ...READ MORE

Aug 9, 2022 in Database by Kithuzzz
 • 38,000 points • 556 views
0 votes
1 answer

ORACLE LIVE SQL IMPORT CSV DATA (live oracle sql)

Convert CSV to SQL http://www.convertcsv.com/csv-to-sql.htm This programme may be ...READ MORE

Feb 11, 2022 in Database by Neha
 • 9,020 points • 8,222 views
0 votes
1 answer

Excel sort function to "skip" 1st row

Select the column range you will sort ...READ MORE

Apr 11, 2022 in Database by gaurav
 • 23,260 points • 5,781 views
0 votes
1 answer

How to view the XML form of an Excel file?

Excel is a spreadsheet programme. Click File->Open in ...READ MORE

Mar 25, 2022 in Database by Edureka
 • 13,690 points • 6,307 views
0 votes
1 answer

Pandas cannot open an Excel (.xlsx) file

XLRDError: Excel xlsx file not supported by ...READ MORE

Apr 4, 2022 in Database by gaurav
 • 23,260 points • 5,732 views
0 votes
1 answer

How to Export Tally Data programmatically to CSV or Excel format

Tally Data in Excel or PDF: How ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 5,792 views
0 votes
1 answer

Generating username from first name and last name in excel

How to automatically merge first and last ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 5,621 views
0 votes
1 answer

Convert .xlsb to .xlsx - Multi-sheet Microsoft Excel File

xlsb can be read by newer versions ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 5,396 views
0 votes
1 answer

How to get the "Name Box" name of an Excel cell?

By typing in the Name Box, you ...READ MORE

Mar 15, 2022 in Database by gaurav
 • 23,260 points • 5,518 views
0 votes
1 answer

Is Excel Alt+Enter same as Newline character \n ?

According to the excel documentation, pressing alt+enter ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 4,864 views
0 votes
1 answer

Insert a value to a cell in excel using formula in another cell

Select the cell where the formula should ...READ MORE

Mar 25, 2022 in Database by gaurav
 • 23,260 points • 4,973 views
0 votes
0 answers

Laravel - Datatables export excel from filtered data

Hello i would like to export data ...READ MORE

Mar 28, 2022 in Database by Edureka
 • 13,690 points • 4,865 views
0 votes
1 answer

Pasting an Excel range into an email as a picture

Hold down the ALT + F11 keys ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 4,802 views
0 votes
1 answer

How to generate the statement CREATE TABLE for an existing table in postgreSQL?

Generate table creation statement for an existing ...READ MORE

Feb 9, 2022 in Database by Neha
 • 9,020 points • 6,684 views
0 votes
1 answer

Excel VBA run-time error 1004 : Application-defined or object-defined error

Maybe your code is on Sheet 1, ...READ MORE

Apr 11, 2022 in Database by gaurav
 • 23,260 points • 4,005 views
0 votes
0 answers

How Stuff and 'For Xml Path' work in SQL Server?

Table is: Id Firstname 4 abc 4 def 4 ghi 4 jkl 4 mno Required output: Id Name 4 abc,def,ghi,jkl,mno Query: SELECT ID, ...READ MORE

Feb 23, 2022 in Database by Neha
 • 9,020 points • 6,020 views
0 votes
1 answer

Converting Excel Date Serial Number to Date using Javascript

Please do try this : function ExcelDateToJSDate(serial) { ...READ MORE

Apr 11, 2022 in Database by gaurav
 • 23,260 points • 3,578 views
0 votes
1 answer

CountifS + multiple criteria + distinct count

Please enter this formula into a blank ...READ MORE

Apr 4, 2022 in Database by Edureka
 • 13,690 points • 3,693 views
0 votes
1 answer

Write formula to Excel with Python

Using python to add formulas to an ...READ MORE

Mar 31, 2022 in Database by gaurav
 • 23,260 points • 3,920 views
0 votes
1 answer

Save dynamically created table content in excel file using SheetJS

text inside tr instead of td in dynamic content. This results ...READ MORE

Apr 4, 2022 in Database by Edureka
 • 13,690 points • 3,680 views
0 votes
1 answer

What is the best library in python to deal with excel files?

XlsxWriter and Xlwings are the best, in ...READ MORE

Apr 4, 2022 in Database by Edureka
 • 13,690 points • 3,616 views
0 votes
1 answer

Reading Excel File using Python, how do I get the values of a specific column with indicated column name?

We can read excel more easily with ...READ MORE

Mar 14, 2022 in Database by gaurav
 • 23,260 points • 4,582 views
0 votes
1 answer

How to sort dates from Oldest to Newest in Excel?

Drag down the column to select the ...READ MORE

Feb 23, 2022 in Database by gaurav
 • 23,260 points • 5,274 views
0 votes
1 answer

Excel - Combine multiple columns into one column

In Excel, how can I concatenate (combine) ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 3,652 views
0 votes
1 answer

Returning outlook sender address from VBA in Excel

Returns a String that represents the sender ...READ MORE

Apr 4, 2022 in Database by gaurav
 • 23,260 points • 3,258 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.