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 • 999 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 • 749 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 • 778 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 • 973 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 • 678 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,103 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 • 882 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 • 668 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 • 702 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 • 989 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 • 535 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,613 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,361 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 • 772 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 • 555 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,055 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 • 751 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 • 675 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 • 761 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 • 996 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 • 833 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 • 668 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,289 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 • 944 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 • 702 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 • 717 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,969 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 • 863 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 • 675 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,144 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 • 666 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 • 862 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 • 497 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 • 502 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 • 939 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 • 548 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 • 584 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,075 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 • 504 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 • 689 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,312 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 • 603 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 • 540 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 • 731 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 • 796 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 • 787 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,130 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 • 645 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 • 958 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,017 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.