SQL Server Questions & Answers

PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused

SQL Server

1 Answer · 911 Views · Answered ✓

R Asked by: Ranjana Admin · 5 years ago

Best way to do sql nested case statement logic in SQL Server,2005

SQL Server

1 Answer · 1.1K Views · Answered ✓

M Asked by: Matt Dyer · 5 years ago

Failed to locate the winutils binary in the hadoop binary path

SQL Server

1 Answer · 755 Views · Answered ✓

R Asked by: Ranjana Admin · 5 years ago

How can I update two tables using one statement in SQL Server 2005?

SQL Server

1 Answer · 1.2K Views · Answered ✓

J Asked by: Jason Sharp · 5 years ago

How to make the search for a text from database search stored procedures in SQL?

SQL Server

1 Answer · 436 Views · Answered ✓

A Asked by: Aashna Saito · 5 years ago

SQL replace null with 0

SQL Server

1 Answer · 764 Views · Answered ✓

R Asked by: Ranjana Admin · 5 years ago

I've been using this for some time: SUBSTRING(str_col, PATINDEX('%[^0]%', str_col), LEN(str_col))

SQL Server

1 Answer · 1.2K Views · Answered ✓

M Asked by: Melany Doi · 5 years ago

I don't want to type all tables' name to drop all of them. Is it possible with one query?

SQL Server

1 Answer · 1.1K Views · Answered ✓

M Asked by: Megan Hudson · 5 years ago

Explicit vs implicit SQL joins

Is there any efficiency difference in an explicit vs implicit inner join? For example:SELECT * FROMtable a INNER JOIN table bON a.id = b.id;vs.SELECT…

SQL Server

1 Answer · 730 Views · Answered ✓

R Asked by: Rama shanker · 5 years ago

call to undefined function sqlsrv_connect()

SQL Server

1 Answer · 1.3K Views · Answered ✓

I Asked by: Ishii Watanabe · 5 years ago

Sql Server equivalent of a COUNTIF aggregate function I'm building a query with a GROUP BY clause

SQL Server

1 Answer · 1.3K Views · Answered ✓

I Asked by: indhumathi Jhadav · 5 years ago

DB2 SQL error sqlcode=-104 sqlstate=42601 I am relatively new to DB2 but not to SQL.

SQL Server

1 Answer · 1.5K Views · Answered ✓

A Asked by: Aalap prabhakaran · 5 years ago