How to Save Mysql Query Result on a File
https://www.czetsuyatech.com/2021/07/mysql-save-sql-result-in-file.html
See sql script below: SELECT code, name, continent, region FROM country INTO OUTFILE 'c:/temp/countries.csv' FIELDS TERMINATED...
How to Dump and Restore a Postgresql Database
https://www.czetsuyatech.com/2021/07/postgresql-dump-and-restore-a-database.html
To create a postgresql dump in linux, execute the following commands: Login as root user >su - postgres >pg_dump -U username -W -...
How to Restore an Oracle Dump Using Imp Command
https://www.czetsuyatech.com/2021/07/oracle-restore-dump-using-imp.html
The following steps will guide us in the restoration of an oracle dump file. connect as system and enter your password sqplus system@xe ...
How to Import and Export a Database Dump in Oracle
https://www.czetsuyatech.com/2021/07/oracle-export-import-database-dump.html
The following instruction will help us in importing and exporting our oracle database. Create and restore dump file (http://www.datab...
How to Setup Toad Oracle Freeware
https://www.czetsuyatech.com/2021/07/oracle-setup-toad.html
The following article will help us in configuring our Toad Oracle Freeware with Oracle XE database. For development purposes I normally use ...
How to Alter the Sequence Value in Postgresql
https://www.czetsuyatech.com/2021/07/postgresql-alter-sequence-value.html
This script will change the value of the sequence value, for example we have a table EMPLOYEE and sequence EMPLOYEE_SEQ: DROP SEQUENCE EMPL...
How to Install Hstore in Postgresql
https://www.czetsuyatech.com/2021/07/postgresql-install-hstore.html
Recently, we've use hstore data type in our database because of its key, value pair functionality and here's how I install hstore in...
How to Change Postgresql's Postgres Password
https://www.czetsuyatech.com/2021/07/postgresql-change-postgres-password.html
This is how you would change your PostgreSQL user postgres password, in case you forgot it. This is done in ubuntu 12.04. 1.) Logon to you...
How to Select All the Triggers in an Mssql Table
https://www.czetsuyatech.com/2021/07/mssql-select-all-triggers.html
I've found this script somewhere on the internet, just for reference: SELECT [Table] = OBJECT_NAME(o.parent_obj), [Trigger] = o.[nam...
How to Execute Select Count and Group Query in Entity Framework
https://www.czetsuyatech.com/2012/03/sql-select-count-and-group-query-on-ef.html
As the title implies we will try to convert a native sql that group and counts the number of row. We will assume that you have a column qua...
How to Execute a Group by and Sum Query in Entity Framework
https://www.czetsuyatech.com/2012/03/sql-group-sum-on-ef.html
The following code is the native sql with the converted code in entity framework. It queries the sum of quantity group by branch, model, yea...
How to Select All the Triggers in an Mssql Table
https://www.czetsuyatech.com/2021/07/mssql-select-all-triggers_02029201135.html
Aside from using the SQL Designer, you can alter a bit and date column's default value. ALTER TABLE TableName ADD CONSTRAINT TableName...
How to Insert an Md5 Password in Mssql
https://www.czetsuyatech.com/2021/07/mssql-insert-md5-password.html
To md5 a string in mssql we execute this query: select HASHBYTES('MD5', 'password') //But this has a problem because it re...
How to Get the Date from Datetime in Mssql
https://www.czetsuyatech.com/2021/07/mssql-extract-date-from-datetime.html
This is how you will get the Date object from DateTime SELECT CONVERT(nvarchar(20), GETDATE(), 23) AS DateOnly For more MSSQL Convert Co...
How to Fix This Database Does Not Have a Valid Owner in Mssql
https://www.czetsuyatech.com/2021/07/mssql-this-database-does-not-have-a-valid-owner.html
I encountered the error below when creating a diagram in the Management Studio. "Database diagram support objects cannot be installed...
How to Update a Column Base on a Row Number in Mssql
https://www.czetsuyatech.com/2021/07/mssql-update-column-base-on-row-number.html
Just recently I was asked to normalized or divide a table into 2 tables. Unfortunately, the only column that linked them (email) allows mult...
How to Change the Default Http and Ftp Port in Oracle Xe Universe
https://www.czetsuyatech.com/2021/07/oracle-change-default-http-and-ftp-port.html
We assume that you have successfully download and installed the OracleXEUniv.exe. How to change the default http and ftp port in oracle xe...
How to Export Sql to Create a Database Schema in Mssql
https://www.czetsuyatech.com/2021/07/mssql-export-create-schema-sql.html
I want to duplicate my database schema, but I do not want to copy the data contents. There are 3rd party tools which I can use to achieve th...
Learn About Mssql Database Table Compatibility
https://www.czetsuyatech.com/2021/07/mssql-database-table-compatibility.html
Recently I was developing a c# application that uses sqlserver2005 database (express edition) setup on my laptop which has win7 os. The pr...
How to Create Mssql Aspnet Database
https://www.czetsuyatech.com/2021/07/mssql-create-aspnet-database.html
I always forget how to create an aspnet database so I'm noting it here: Just execute: c:\Windows\Microsoft.NET\Framework\v2.0.50727\a...
Join the Community
