Most voted questions in Database

0 votes
0 answers

"CASE" statement within "WHERE" clause in SQL Server 2008

The query I'm working with has a ...READ MORE

Sep 3, 2022 in Database by Kithuzzz
 • 38,010 points • 214 views
0 votes
0 answers

java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0)

After the selection in the select combo ...READ MORE

Sep 3, 2022 in Database by Kithuzzz
 • 38,010 points • 1,790 views
0 votes
0 answers

SQL server invalid object name - but tables are listed in SSMS tables list

I'm trying to develop a stored procedure ...READ MORE

Sep 3, 2022 in Database by Kithuzzz
 • 38,010 points • 660 views
0 votes
0 answers

PDOException SQLSTATE[HY000] [2002] No such file or directory

My (very basic) site appears to have ...READ MORE

Sep 3, 2022 in Database by Kithuzzz
 • 38,010 points • 1,581 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,010 points • 145 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,010 points • 188 views
0 votes
0 answers

Select data from date range between two dates

I have a database called Product Sales ...READ MORE

Sep 2, 2022 in Database by Kithuzzz
 • 38,010 points • 486 views
0 votes
0 answers

I want to use CASE statement to update some records in sql server 2005

UPDATE dbo.TestStudents SET LASTNAME = ( ...READ MORE

Sep 2, 2022 in Database by Kithuzzz
 • 38,010 points • 621 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,010 points • 130 views
0 votes
0 answers

Check if table exists and if it doesn't exist, create it in SQL Server 2008

I'm using SQL Server 2008 to create ...READ MORE

Sep 2, 2022 in Database by Kithuzzz
 • 38,010 points • 369 views
0 votes
0 answers

Vendor code 17002 to connect to SQLDeveloper

When using SQLDeveloper to connect to a ...READ MORE

Sep 2, 2022 in Database by Kithuzzz
 • 38,010 points • 563 views
0 votes
0 answers

How to DROP multiple columns with a single ALTER TABLE statement in SQL Server?

In one ALTER TABLE statement, I would ...READ MORE

Sep 2, 2022 in Database by Kithuzzz
 • 38,010 points • 265 views
0 votes
0 answers

How to create a table from select query result in SQL Server 2008

I tried to build a table from ...READ MORE

Sep 2, 2022 in Database by Kithuzzz
 • 38,010 points • 324 views
0 votes
0 answers

Android Studio, how to retrieve data from Sqlite database and display it into textview?

I built a SQLite Database and added ...READ MORE

Sep 2, 2022 in Database by Kithuzzz
 • 38,010 points • 891 views
0 votes
0 answers

How to get current datetime in SQL?

In order to add the current date ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
 • 38,010 points • 261 views
0 votes
0 answers

SQL-Server: The backup set holds a backup of a database other than the existing

My attempt to restore a SQL Server ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
 • 38,010 points • 339 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,010 points • 119 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,010 points • 170 views
0 votes
0 answers

Nested select statement in SQL Server

Why does the following not function? SELECT name ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
 • 38,010 points • 165 views
0 votes
0 answers

Equivalent of Oracle's RowID in SQL Server

What does SQL Server's RowID resemble in ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
 • 38,010 points • 297 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,010 points • 158 views
0 votes
0 answers

What is the difference between varchar and nvarchar?

Is it only that multibyte characters are ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
 • 38,010 points • 239 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,010 points • 140 views
0 votes
0 answers

SQLSTATE[HY000] [1045] Access denied for user 'username'@'localhost' using CakePHP

I'm new to CakePHP and PHP. While ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
 • 38,010 points • 2,439 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,010 points • 139 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,010 points • 133 views
0 votes
0 answers

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

Can someone provide examples and a description ...READ MORE

Aug 29, 2022 in Database by Kithuzzz
 • 38,010 points • 132 views
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,010 points • 164 views
0 votes
0 answers

SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102

I'm getting the SQLSTATE[HY093] error: Line 102 ...READ MORE

Aug 29, 2022 in Database by Kithuzzz
 • 38,010 points • 1,130 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,010 points • 207 views
0 votes
0 answers

How do I query for all dates greater than a certain date in SQL Server?

I tried this: SELECT * FROM dbo.March2010 A WHERE ...READ MORE

Aug 29, 2022 in Database by Kithuzzz
 • 38,010 points • 367 views
0 votes
0 answers

SQL query to insert datetime in SQL Server

Using the SQL query below, I want ...READ MORE

Aug 29, 2022 in Database by Kithuzzz
 • 38,010 points • 1,279 views
0 votes
0 answers

Convert timestamp to date in Oracle SQL

How can we convert timestamp to date? READ MORE

Aug 29, 2022 in Database by Kithuzzz
 • 38,010 points • 139 views
0 votes
0 answers

SUBSTR and INSTR SQL Oracle

I've begun utilising SUBSTR and INSTR in ...READ MORE

Aug 29, 2022 in Database by Kithuzzz
 • 38,010 points • 814 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,010 points • 161 views
0 votes
0 answers

SQL Server 2008 - IF NOT EXISTS INSERT ELSE UPDATE

I'm trying to create a time clock ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
 • 38,010 points • 2,266 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,010 points • 365 views
0 votes
0 answers

UPDATE and REPLACE part of a string

A table I have has two columns: ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
 • 38,010 points • 521 views
0 votes
0 answers

Loop in stored procedure in SQL server

Writing a stored procedure that calls another ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
 • 38,010 points • 847 views
0 votes
0 answers

How to make a query with group_concat in sql server ?

I am aware that the Group Concat ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
 • 38,010 points • 330 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,010 points • 124 views
0 votes
0 answers

SQL Differences between stored procedure and triggers

I'm having problems comprehending how a stored ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
 • 38,010 points • 276 views
0 votes
0 answers

What is the purpose of using WHERE 1=1 in SQL statements?

Possible Duplicates: Why would a sql query have ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
 • 38,010 points • 843 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,010 points • 153 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,010 points • 189 views
0 votes
0 answers

Search text in stored procedure in SQL Server

I want to search all of my ...READ MORE

Aug 27, 2022 in Database by Kithuzzz
 • 38,010 points • 1,277 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,010 points • 343 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,010 points • 147 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,010 points • 126 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,010 points • 152 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.