questions/database
Try some sort of COALESCE trick: SELECT COALESCE( ...READ MORE
.NET DataProvider -- Standard Connection with username ...READ MORE
An expression to be tested for each ...READ MORE
Use ROW_NUMBER(if you want a single) or DENSE_RANK(for all ...READ MORE
Connect to the instance of SQL Server, ...READ MORE
There is no LIKE & IN combination ...READ MORE
In SQL Server 2012 and up you ...READ MORE
Try to check for existence: IF NOT EXISTS ...READ MORE
Use this: SELECT *FROM ...READ MORE
Dialect is defined as "a language's variety." ...READ MORE
SELECT * from games WHERE (lower(title) LIKE ...READ MORE
Standard SQL-92 is represented by >; its ...READ MORE
I'm ruining this query on w3school even ...READ MORE
Just populate the field directly, using ordering ...READ MORE
It matters whether you place the filter ...READ MORE
Unfortunately, you have to utilize sysobjects/syscolumns to ...READ MORE
In the stacktrace, there is a line ...READ MORE
To display the query string: print_r($this->db->last_query()); ...READ MORE
Try either multi-table update syntax: UPDATE config t1 ...READ MORE
SELECT name, email, COUNT(*) FROM ...READ MORE
Use the sp_columns stored procedure: exec sp_columns MyTable I hope this ...READ MORE
Test Data DECLARE @Table1 TABLE(ID INT, Value INT) INSERT ...READ MORE
In addition to the advice already given, ...READ MORE
If you need to delete based on ...READ MORE
Use an IN clause. Example: SELECT status, CASE ...READ MORE
You don't need EXEC clause. Simply use: proc_name ...READ MORE
Try this Cast('7/7/2011' as datetime) And Convert(DATETIME, '7/7/2011', 101) See CAST and ...READ MORE
Try this: SELECT p.pid, p.cid, p.pname, c1.name1, c2.name2 FROM ...READ MORE
They are not the same thing. Consider these ...READ MORE
See TRY...CATCH (Transact-SQL) CREATE PROCEDURE [dbo].[PL_GEN_PROVN_NO1] ...READ MORE
First off, if you're starting a new ...READ MORE
Yes, even though I like using JOINs, ...READ MORE
Following extensive performance testing and analysis, the ...READ MORE
The snippet from the Official documentation for PostgreSQL is ...READ MORE
Your inquiry is quite near. The following ...READ MORE
Try this: SELECT s.studentname , ...READ MORE
You're trying to write more data than ...READ MORE
The majority of the responses to this ...READ MORE
The LIMIT clause is not included in ...READ MORE
To obtain the year from the given ...READ MORE
The BIT datatype can be used to ...READ MORE
You can use OPENROWSET to import an Excel file ...READ MORE
Use a subquery for this like: select * from ...READ MORE
The lack of an underscore between "chartered" ...READ MORE
Just normalize your model properly: create table user_rank ( ...READ MORE
The default port of SQL server is 1433. READ MORE
Instead of receiving a result set as ...READ MORE
Try replacing the string literal for date ...READ MORE
One of the services has not begun ...READ MORE
This helped me get to my answer. There ...READ MORE
OR
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.