Databases – Page 2 – www.myw0.com

How to Change Schema of Mssql Tables, Stored Procedures, and Views All at the Same Time

09/20/2020

Sometimes changing database users changes who the database owner is for a table from dbo.tablename to badschema.tablename. This will also affect any stored procedures created under the tables with the incorect schema. If you need to change the schema for these tables back to the default dbo schema follow the steps below. Open Microsoft SQL Server Management Studio and log in. Click the New Query button. Paste the following script into the New Query box changing oldschema to the name of the current schema:…

How to Optimize iPhone, iPad and iPod Performance

09/17/2019

| No Comments

| SQL

1. Close Apps Running in the Background On an iOS 10/9/8 device, when you tap the home button to leave an app, you do not “close” that app. In fact, all apps continue to run in the background, and certain apps (social media, apps with “push” notifications, streaming music apps) take up a good chunk of battery when they are running. If you close them when they’re not in use, you could save more battery and RAM to make…

Update consecutive numbering with UPDATE statement – MSSQL

08/28/2018

| No Comments

| Microsoft SQL, SQL, Visual Studio

I want to update a table with consecutive numbering starting at 1. The update has a where clause so only results that meet the clause will be renumbered. Can I accomplish this efficiently without using a temp table?

What is – DML, DDL, DCL and TCL – Introduction

08/18/2017

| No Comments

| SQL

DML DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database. Examples: SELECT, UPDATE, INSERT statements DDL DDL is abbreviation of Data Definition Language. It is used to create and modify the structure of database objects in database. Examples: CREATE, ALTER, DROP statements DCL DCL is abbreviation of Data Control Language. It is used to create roles, permissions, and referential integrity as well it is used to control access to database…

Oracle – Create Table by Select Statement

08/14/2017

| No Comments

| Oracle, PL/SQL

–WITH data –without data — For example, create a table named EMPLOYEE3 that includes all — of the column definitions from EMPLOYEE where the DEPTNO = D11.

Find Duplicate Values with SQL Script

07/28/2017

| No Comments

| Microsoft SQL, SQL, T-SQL Code

Let’s assume that data has been entered in a table and now you want to find if a table column have duplicated values. Here is an SQL script to join data from one table for comparison purpose. The table must have a primary key column (unique column) and the second column for comparison. Here is a sample script: Details: – DWDOCID is the primary key column – AIXFlag, is just a fixed value (optional) – SAMPLEEN is the table…

List all triggers in SQL Server database with table name and schema

07/27/2017

| No Comments

| Microsoft SQL, SQL

Sample query: Here is and another version where you can the code of the trigger:

FORMAT Function for Transact-SQL – T-SQL

03/16/2017

| No Comments

| Microsoft SQL, T-SQL Code

Returns a value formatted with the specified format and optional culture in SQL Server 2016. Use the FORMAT function for locale-aware formatting of date/time and number values as strings. FORMAT ( value, format ) Return Types: nvarchar or null The length of the return value is determined by the format. Remarks: FORMAT returns NULL for errors other than a culture that is not valid. For example, NULL is returned if the value specified in format is not…

MySQL Store Procedure to Loop with Table Cursor and Update with UUID()

02/21/2017

| No Comments

| MySQL

This is a sample MySQL store procedure where I loop in all rows in a table and then I update each row with a UUID().

Category: Databases

How to Change Schema of Mssql Tables, Stored Procedures, and Views All at the Same Time

How to Optimize iPhone, iPad and iPod Performance

Update consecutive numbering with UPDATE statement – MSSQL

What is – DML, DDL, DCL and TCL – Introduction

Oracle – Create Table by Select Statement

Find Duplicate Values with SQL Script

List all triggers in SQL Server database with table name and schema

FORMAT Function for Transact-SQL – T-SQL

MySQL Store Procedure to Loop with Table Cursor and Update with UUID()

Oracle PL/SQL – Finding number of rows in each table by a single query

Menu

Contact Info

–