Trending questions in Database

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,020 points
559 views
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,020 points
559 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,020 points
372 views
0 votes
0 answers

How to Alter Constraint

My Constraint: CONSTRAINT ACTIVEPROG_FKEY1 FOREIGN KEY(ActiveProgCode) REFERENCES PROGRAM(ActiveProgCode), I ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
• 38,020 points
494 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,020 points
749 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,020 points
532 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,020 points
484 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,020 points
576 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,020 points
548 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,020 points
532 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,020 points
651 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,020 points
644 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,020 points
467 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,020 points
462 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,020 points
411 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,020 points
589 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,020 points
370 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,020 points
476 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,020 points
475 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,020 points
381 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,020 points
453 views
0 votes
0 answers

Creating tables in sqlite database on android

@Override ...READ MORE

Aug 11, 2022 in Database by Kithuzzz
• 38,020 points
423 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,020 points
490 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,020 points
351 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
5,815 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,060 points
8,091 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,582 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,010 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,434 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,599 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,400 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,193 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,727 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,792 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,638 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,257 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,555 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,060 points
6,514 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
3,850 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,060 points
5,901 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,354 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,836 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,553 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,540 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,515 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,428 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,161 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,521 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,070 views
0 votes
0 answers

Access denied for user 'root@localhost' (using password:NO)

I wanted to run WordPress and it ...READ MORE

May 8, 2022 in Database by Kichu
• 19,050 points
1,556 views