Trending questions in Database

0 votes
0 answers

Bulk Record Update with SQL

In a SQL Server 2008 environment, I ...READ MORE

Aug 23, 2022 in Database by Kithuzzz
 • 38,000 points • 986 views
0 votes
0 answers

Find all tables containing column with specified name - MS SQL Server

Is it feasible to run a search ...READ MORE

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

Create table (structure) from existing table

How to create a new table in ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
 • 38,000 points • 769 views
0 votes
0 answers

How can I delete using INNER JOIN with SQL Server?

In SQL Server 2008, I want to ...READ MORE

Aug 23, 2022 in Database by Kithuzzz
 • 38,000 points • 964 views
0 votes
0 answers

What is "Advanced" SQL?

Examining job postings where "advanced SQL" is ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
 • 38,000 points • 670 views
0 votes
0 answers

How to group by month from Date field using sql

How can I only group by month ...READ MORE

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

How do I get list of all tables in a database using TSQL?

How can I find out the names ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
 • 38,000 points • 654 views
0 votes
0 answers

Cannot Connect to Server - A network-related or instance-specific error

I am getting this error when trying to ...READ MORE

Aug 29, 2022 in Database by Kithuzzz
 • 38,000 points • 692 views
0 votes
0 answers

ORA-01476: "divisor is equal to zero" for SQL query (Oracle 10g)

I'm creating a SQL query with Oracle ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
 • 38,000 points • 859 views
0 votes
0 answers

How can I get column names from a table in SQL Server?

I want to search for every column's ...READ MORE

Sep 3, 2022 in Database by Kithuzzz
 • 38,000 points • 525 views
0 votes
0 answers

Trouble Connecting to sql server Login failed. "The login is from an untrusted domain and cannot be used with Windows authentication"

I want to host a SQL server ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
 • 38,000 points • 977 views
0 votes
0 answers

How to update Identity Column in SQL Server?

With 200 records currently, I want to ...READ MORE

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

What is the advantage of using "Set NOCOUNT ON" in stored procedure's which are used in ssis packages?

While studying SQL Server's performance tuning concepts, ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
 • 38,000 points • 764 views
0 votes
0 answers

Get week day name from a given month, day and year individually in SQL Server

I'm attempting to get a day name ...READ MORE

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

How to install SQL Server Management Studio 2012 (SSMS) Express?

I just set up SQL Server 2012 ...READ MORE

Sep 2, 2022 in Database by Kithuzzz
 • 38,000 points • 544 views
0 votes
0 answers

How to import large sql file in phpmyadmin

I want to import a roughly 12-megabyte ...READ MORE

Aug 21, 2022 in Database by Kithuzzz
 • 38,000 points • 1,044 views
0 votes
0 answers

Backup a single table with its data from a database in sql server 2008

I want to use a script to ...READ MORE

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

Difference of two date time in sql server

Just a note of caution with DateDiff: ...READ MORE

Aug 27, 2022 in Database by narikkadan
 • 63,600 points
edited Mar 5 • 734 views
0 votes
0 answers

How to remove foreign key constraint in sql server?

In order to enter values of my ...READ MORE

Aug 21, 2022 in Database by Kithuzzz
 • 38,000 points • 990 views
0 votes
0 answers

Springframework.dao.InvalidDataAccessResourceUsageException hibernate.SQLGrammarException MySQLSyntaxErrorException

In an effort to figure out what's ...READ MORE

Aug 27, 2022 in Database by Kithuzzz
 • 38,000 points • 657 views
0 votes
0 answers

Altering column size in SQL Server

How to change the column size of ...READ MORE

Aug 23, 2022 in Database by Kithuzzz
 • 38,000 points • 818 views
0 votes
0 answers

Import CSV file into SQL Server

I have a few fundamental questions and ...READ MORE

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

Self Join to get employee manager name

Hello, the columns in my employee table ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
 • 38,000 points • 726 views
0 votes
0 answers

How to update two tables in one statement in SQL Server 2005?

In one operation, I want to update ...READ MORE

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

How to fix Recovery Pending State in SQL Server Database?

How to fix Recovery Pending State in ...READ MORE

Aug 27, 2022 in Database by Kithuzzz
 • 38,000 points • 691 views
0 votes
0 answers

What is the syntax to drop a Stored Procedure in SQL Server 2000?

In SQL Server 2000, how do you ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
 • 38,000 points • 704 views
0 votes
0 answers

Reset identity seed after deleting records in SQL Server

A SQL Server database table has had ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
 • 38,000 points • 851 views
0 votes
0 answers

Replacing NULL with 0 in a SQL server query

I created a query, and the first ...READ MORE

Aug 27, 2022 in Database by Kithuzzz
 • 38,000 points • 663 views
0 votes
0 answers

SQL to find the number of distinct values in a column

In a column, I can choose each ...READ MORE

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

Excel 2010 CTRL+SHIFT+L. Not working

The Macro-containing workbook was always open in ...READ MORE

Apr 4, 2022 in Database by Edureka
 • 13,690 points • 6,939 views
0 votes
0 answers

SQL: IF clause within WHERE clause

In MS SQL, is it feasible to ...READ MORE

Aug 27, 2022 in Database by Kithuzzz
 • 38,000 points • 653 views
0 votes
0 answers

SQL Server Configuration Manager not found

I cannot locate the SQL Server Configuration ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
 • 38,000 points • 856 views
0 votes
0 answers

SQL multiple column ordering

How can I sort in several ways ...READ MORE

Aug 29, 2022 in Database by Kithuzzz
 • 38,000 points • 487 views
0 votes
0 answers

Describe table structure

Which SQL query returns the table structure ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
 • 38,000 points • 488 views
0 votes
0 answers

No process is on the other end of the pipe (SQL Server 2012)

I've got this error: A connection was successfully ...READ MORE

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

DECODE function in SQL server

How can I use DECODE() function in ...READ MORE

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

How to get Time from DateTime format in SQL?

I want to use a SQL query ...READ MORE

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

Why do you create a View in a database?

When and why does a database owner ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
 • 38,000 points • 569 views
0 votes
0 answers

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

Can someone provide examples and a description ...READ MORE

Aug 29, 2022 in Database by Kithuzzz
 • 38,000 points • 499 views
0 votes
0 answers

Get all table names of a particular database by SQL query?

I'm developing a program that can interact ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
 • 38,000 points • 673 views
0 votes
0 answers

Merge 2 tables in SQL and save into 1 new table

I have two tables with the same columns. Table ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
 • 38,000 points • 533 views
0 votes
0 answers

How to open .SQLite files

On Windows, I'm attempting to open an ...READ MORE

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

How to drop all tables from a database with one SQL query?

Use the INFORMATION_SCHEMA.TABLES view to get the ...READ MORE

Feb 4, 2022 in Database by Neha
 • 9,020 points • 9,272 views
0 votes
0 answers

What are Covering Indexes and Covered Queries in SQL Server?

Can you describe the ideas behind Covering ...READ MORE

Aug 21, 2022 in Database by Kithuzzz
 • 38,000 points • 720 views
0 votes
0 answers

What is the purpose of Order By 1 in SQL select statement?

I discovered numerous views with an order ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 38,000 points • 784 views
0 votes
0 answers

Execution sequence of Group By, Having and Where clause in SQL Server?

I'm just not sure how a SQL ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 38,000 points • 778 views
0 votes
0 answers

How to convert java.util.Date to java.sql.Date?

I need a java.sql since I'm trying ...READ MORE

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

Get size of all tables in database

A sizable SQL Server database has been ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
 • 38,000 points • 634 views
0 votes
0 answers

SQLException: No suitable Driver Found for jdbc:oracle:thin:@//localhost:1521/orcl

I'm attempting to create a Java EE ...READ MORE

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

Which datatype to use to store a mobile number?

Which datatype will I use to store ...READ MORE

Aug 13, 2022 in Database by Kithuzzz
 • 38,000 points • 1,009 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.