Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts
Wednesday, July 22, 2020

[MS SQL] Select all tables for a given schema

›
While we are working with SQL Server, it is often required to see the tables under the different schemas.  You can still do that via SQL Ser...
Saturday, June 13, 2020

[Resolved] MS SQL Error - String or binary data would be truncated sql

›
A Systematic Approach for Resolution Problem While executing insert statement in MS SQL, you may see the following error, Msg 8152, Level 16...
Monday, September 03, 2018

How to find Database Schema Created Date in MySQL

›
While working with developer testing and related stuff, it is often required to update the database schema, use old versions or r...
Tuesday, July 31, 2018

MySQL : Assign Query Results to User Defined Variables for Reuse

›
In SQL Scripting, it is often required to reuse the queried values, while executing queries in sequence. User defined variables are ...
1 comment:

MySQL INSERT IGNORE : Insert a Record Only If it does not Exist

›
INSERT IGNORE  option by MySQL is a very convenient keyword to gracefully handle an INSERT of a record with an existing Key. The r...
Tuesday, July 17, 2018

SQL IN Operator : Filter from multiple values or a list

›
In Operator allows to specify multiple values in where clause SELECT * FROM books WHERE ISBN IN (123456, 456789, ...); It also s...
Friday, June 22, 2018

MySQL : View Executed Queries on MySQL Server Log

›
It is often required to investigate the queries executed on MySQL Server Log for many reasons when debugging. Specially it allows to...
Wednesday, June 20, 2018

MySQL : Execute Queries with User Defined Variables

›
Define the variable and set it in the server, SET @country = 'Sri Lanka'; SET @section = 'Science Fiction '; Now...
Wednesday, January 24, 2018

[RESOLVED] CASSANDRA : line 0:-1 no viable alternative at input ''

›
Cassandra Query Issue When querying for data in Cassandra , The following error was thrown in DataStax Studio , SELECT * FROM XXXXX ...
1 comment:
Thursday, October 05, 2017

Data is not persisted in database using Spring Data Repository

›
In a Spring Data project, if the data seems not being persisted in database using Spring Data Repositories, that is strange but it ha...
Wednesday, October 04, 2017

PostgreSQL : Drop all tables in a schema

›
PostgreSQL : Drop all tables in a schema Drop & Create The schema DROP SCHEMA <schema_name> CASCADE; CREATE SC...