Trending questions in Database

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,020 points
334 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
547 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,020 points
579 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
403 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
787 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
520 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
565 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
595 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
566 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
686 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
504 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
538 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
448 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
658 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
479 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
634 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
403 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
416 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
488 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
488 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
485 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
459 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
517 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
380 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,871 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,125 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,650 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,094 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,511 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,667 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,473 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,241 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,767 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,348 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,840 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,689 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,651 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,566 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,896 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
5,934 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,417 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,859 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,593 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,576 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,560 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,478 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,192 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,553 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,138 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,613 views