SQL Server Questions & Answers

How do I fix no suitable driver found for the JDBC SQL server?

I'm getting this exception”No suitable driver found for jdbc” when I try to run this program. It is the Microsoft examples. I've added the…

SQL Server

1 Answer · 3.1K Views · Answered ✓

D Asked by: Diya tomar · 5 years ago

Remove all spaces from a string in SQL Server

What is the best way to remove all spaces from a string in SQL Server 2008?LTRIM(RTRIM(' a b ')) would remove all spaces at the right and left of the…

SQL Server

2 Answers · 4.0K Views · Answered ✓

B Asked by: Bhaanumati shukla · 5 years ago

What is the equivalent of 'describe table' in SQL Server?

I have a SQL Server database and I want to know what columns and types it has using SQL code. Is there a way to do this?

SQL Server

1 Answer · 1.4K Views · Answered ✓

H Asked by: Harry ADAMS · 5 years ago

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

SQL Server

1 Answer · 775 Views · Answered ✓

C Asked by: Christian Parsons · 5 years ago

mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in

I want to check if Facebook User_id already exists in my database (if it does not it should then accept the user as a new one and else simply load…

SQL Server

1 Answer · 1.3K Views · Answered ✓

E Asked by: Elizabeth Jordan · 5 years ago

How do I make a query in SQL where the date is greater than a certain date in SQL Server?

I am trying this code:SELECT * FROM dbo.March2010 A WHERE A.Date >= 2010-04-01; A.Date looks like: 2010-03-04 00:00:00.000But, this is getting the…

SQL Server

1 Answer · 1.2K Views · Answered ✓

N Asked by: Natalie Downing · 5 years ago

What is the difference between view and table in SQL? Is there any advantage of using views instead of tables.

SQL Server

1 Answer · 571 Views · Answered ✓

R Asked by: Ranjana Admin · 5 years ago

SQL Query Where Field DOES NOT Contain $x

SQL Server

1 Answer · 498 Views · Answered ✓

A Asked by: Alan Taylor · 5 years ago

Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine, how to fix it?

I have an SQLite (v3) table with this column definition: \"timestamp\" DATETIME DEFAULT CURRENT_TIMESTAMP The server that this database lives on is…

SQL Server

1 Answer · 1.2K Views · Answered ✓

A Asked by: Aryan Khan · 5 years ago

How can I calculate the percentage with an SQL statement ?

I have a SQL Server table that contains users & their grades and looking for one SQL statement that will find the percentages in SQL.For example, If…

SQL Server

1 Answer · 693 Views · Answered ✓

A Asked by: Anil Jha · 5 years ago

SQL CREATE TABLE IF NOT EXISTS works on MySQL but fails with SQL Server 2008 R2. What is the equivalent syntax?

Possible Duplicate:SQL Server: Check if table existsCREATE TABLE IF NOT EXISTS works on MySQL but fails with SQL Server 2008 R2. What is the…

SQL Server

1 Answer · 1.3K Views · Answered ✓

J Asked by: Jyoti Sharma · 5 years ago

Which SQL keyword is used to sort the result-set?

a. ORDERb. SORT BYc. ORDER BYd. SORT

SQL Server

1 Answer · 1.2K Views · Answered ✓

B Asked by: Buffy Heaton · 5 years ago