Trending questions in Database

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 • 1,254 views
0 votes
0 answers

How to use index in select statement?

Let's imagine I established an index (idx ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
 • 38,000 points • 1,211 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 • 1,551 views
0 votes
0 answers

Solutions for INSERT OR UPDATE on SQL Server

Consider the MyTable table structure. I frequently ...READ MORE

Aug 27, 2022 in Database by Kithuzzz
 • 38,000 points • 1,321 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 • 1,465 views
0 votes
0 answers

Auto increment primary key in SQL Server Management Studio 2012

How can I make a SQL Server ...READ MORE

Sep 2, 2022 in Database by Kithuzzz
 • 38,000 points • 1,105 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,906 views
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 • 1,455 views
0 votes
0 answers

Real life example, when to use OUTER / CROSS APPLY in SQL

With a colleague, I've been researching CROSS/OUTER ...READ MORE

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

Create SQLite database in android

In my project, I want to construct ...READ MORE

Sep 4, 2022 in Database by Kithuzzz
 • 38,000 points • 1,000 views
0 votes
0 answers

No backupset selected to be restored SQL Server 2012

I have a filestream-enabled SQL Server 2012 ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
 • 38,000 points • 1,291 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
 • 86,360 points
edited Mar 5, 2025 • 1,285 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 • 2,069 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 • 1,312 views
0 votes
0 answers

Windows could not start the SQL Server (MSSQLSERVER) on Local Computer... (error code 3417)

I moved the MSSQL11.MSSQLSERVERMSSQL folder from Program ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
 • 38,000 points • 1,241 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 • 1,128 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 • 7,920 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 • 1,152 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 • 1,067 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 • 1,061 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 • 907 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 • 942 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 • 1,287 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 • 1,402 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 • 1,420 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 • 1,134 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 • 1,418 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,712 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,401 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 • 1,068 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 • 1,310 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,759 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 • 1,038 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 • 1,444 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,578 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,557 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 • 1,073 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 • 1,224 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 • 1,036 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 • 1,337 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 • 988 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,580 points • 7,185 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,580 points • 7,035 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 • 9,472 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 • 891 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 • 868 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 • 1,117 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 • 1,209 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 • 1,011 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 • 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.