Recent questions tagged sql-server

0 votes
0 answers

SQL: IF clause within WHERE clause

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

Replacing NULL with 0 in a SQL server query

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

Reset AutoIncrement in SQL Server after Delete

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

SQL Server : Arithmetic overflow error converting expression to data type int

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

SqlServer: Login failed for user

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

Merge 2 tables in SQL and save into 1 new table

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

Difference of two date time in sql server

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

How to display two digits after decimal point in SQL Server?

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

Why do you create a View in a database?

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

SQL query to select data between two dates and times

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

How to fetch the nth highest salary from a table without using TOP and sub-query?

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

SQL Server Insert if not exists

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

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

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

Self Join to get employee manager name

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

Return date as ddmmyyyy in SQL Server

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

Bulk Record Update with SQL

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

How to select the last record of a table in SQL?

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

How can I delete using INNER JOIN with SQL Server?

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

Altering column size in SQL Server

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

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

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

Reset identity seed after deleting records in SQL Server

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

If else in stored procedure sql server

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

SQL Update from One Table to Another Based on a ID Match

Aug 22, 2022 in Database by Kithuzzz
 • 38,000 points • 2,516 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"

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

Get size of all tables in database

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

How do I fix the error 'Named Pipes Provider, error 40 - Could not open a connection to' SQL Server'?

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

SQL Server Configuration Manager not found

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

How to convert SQL Server's timestamp column to datetime format

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

How to remove foreign key constraint in sql server?

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

Select Rows with id having even number

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

Check if table exists in SQL Server

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

What are Covering Indexes and Covered Queries in SQL Server?

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

Get the last inserted row ID (with SQL statement)

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

SQL Server database restore error: specified cast is not valid. (SqlManagerUI)

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

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

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

How to get the connection String from a database

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

How to group by month from Date field using sql

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

How to find sum of multiple columns in a table in SQL Server 2005?

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

Unable to connect to SQL Express "Error: 26-Error Locating Server/Instance Specified)

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

SQL Server: Invalid Column Name

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

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

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

CROSS JOIN vs INNER JOIN in SQL

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

SQL Server Cannot perform an aggregate function on an expression containing an aggregate or a subquery

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

Convert date from dd-mm-yyyy to yyyy-mm-dd in SQL Server

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

Remove Identity from a column in a table

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

SQL Server FOR EACH Loop

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

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

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

Export SQL query data to Excel

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

How to Create a real one-to-one relationship in SQL Server?

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

Where can I find the Northwind database for Microsoft SQL Server 2008

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