Recent questions tagged sql-server-2005

0 votes
1 answer

Are there any Linear Regression Function in SQL Server?

Nov 7, 2022 in Others by Kithuzzz
 • 38,000 points • 1,528 views
0 votes
1 answer

SQL query to select dates between two dates

Nov 4, 2022 in Others by gaurav
 • 25,250 points • 4,139 views
0 votes
1 answer

What is the difference between a primary key and a surrogate key?

Sep 19, 2022 in Database by Kithuzzz
 • 38,000 points • 10,933 views
0 votes
1 answer

INSERT statement conflicted with the FOREIGN KEY constraint - SQL Server

Sep 18, 2022 in Database by Kithuzzz
 • 38,000 points • 13,090 views
0 votes
1 answer

Best way to do nested case statement logic in SQL Server

Sep 18, 2022 in Database by Kithuzzz
 • 38,000 points • 10,372 views
0 votes
1 answer

How to upsert (update or insert) in SQL Server 2005

Sep 17, 2022 in Database by Kithuzzz
 • 38,000 points • 1,939 views
0 votes
1 answer

SQL Server string to date conversion

Sep 14, 2022 in Database by Kithuzzz
 • 38,000 points • 3,799 views
0 votes
1 answer

SQL Server Error : String or binary data would be truncated

Sep 13, 2022 in Database by Kithuzzz
 • 38,000 points • 8,057 views
0 votes
1 answer

Add a column with a default value to an existing table in SQL Server

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

SQL update query using joins

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

Convert Month Number to Month Name Function in SQL

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

DECODE function in SQL server

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

Return date as ddmmyyyy in SQL Server

Aug 23, 2022 in Database by Kithuzzz
 • 38,000 points • 2,757 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 • 3,058 views
0 votes
0 answers

Check if table exists in SQL Server

Aug 21, 2022 in Database by Kithuzzz
 • 38,000 points • 44,374 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,888 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,276 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,725 views
0 votes
0 answers

How to get Time from DateTime format in SQL?

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

What represents a double in sql server?

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

Which datatype to use to store a mobile number?

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

Find stored procedure by name

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

Simple DateTime sql query

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

Querying for the second largest salary

Jun 16, 2022 in Others by nisha
 • 2,210 points • 1,735 views
0 votes
1 answer

SQL Server CASE .. WHEN .. IN statement

Jun 14, 2022 in Others by nisha
 • 2,210 points • 1,481 views
0 votes
0 answers

Selecting COUNT(*) with DISTINCT

Feb 14, 2022 in Database by Neha
 • 9,020 points • 1,595 views
0 votes
1 answer

SQL Server CASE .. WHEN .. IN statement

Feb 8, 2022 in Database by Neha
 • 9,020 points • 1,842 views

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.