Divide the rows of a column in equals batches in grid format (Sat, 28 Aug 2021)I published an article Divide the rows in equals batches few days ago. One of my reader requested me to help him with a requirement to divide a column’s… The post Divide the rows of a column in equals batches in grid format appeared first on SQLServerCentral.>> Read moreDaily Coping 27 Aug 2021 (Fri, 27 Aug 2021)I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m… The post Daily Coping 27 Aug 2021 appeared first on SQLServerCentral.>> Read more
How to find the row in which the queried value exists? (Sat, 28 Aug 2021)>> Read moreNewbie – checking if a value exists in a table (Sat, 28 Aug 2021)>> Read more
Use SQL Conversion Functions to Work with Different Data Types (Sat, 14 Aug 2021)Use SQL conversion functions to work with different data types. SQL server uses data types to store a specific kind of value such as numbers, dates, or text in table columns and to use in functions, such as mathematical expressions. One issue with data types is that they don’t usually mix well. Conversion functions make […] The post Use SQL Conversion Functions to Work with Different Data Types appeared first on Essential SQL.>> Read moreHow to use C# with SQL (Mon, 09 Aug 2021)In this post we’ll look at how to use C# with SQL. In this tutorial, we will discuss the process for creating a very simple C# console application that connects to a SQL Server database. You will learn the most basic steps needed to use C# with SQL. You will see how we can gather […] The post How to use C# with SQL appeared first on Essential SQL.>> Read more
SRVCTL Commands in Oracle RAC (Thu, 26 Aug 2021)This article contains information about srvctl commands in oracle rac environments. SRVCTL is a service manager for controlling, adding, removing, relocating different crs services or components in database installed as RAC. I’ll add the commands we need the most here. SRVCTL Service Start Commands [crayon-612aabffeec8c734274190/] SRVCTL Service Stop Commands [crayon-612aabffeec95058112668/] SRVCTL Start Instance Command [crayon-612aabffeec98053357289/] … The post SRVCTL Commands in Oracle RAC appeared first on Database Tutorials.>> Read moreHow To Connect Azure Database From SQL Management Studio and from Azure Portal (Sat, 26 Jun 2021)We will learn how to connect azure database from sql management studio and from azure portal in this article. How to connect to azure sql database from azure portal How to connect azure database from sql management studio How To Connect to Azure SQL Database from Azure Portal Step1: Select Query Editor(preview) from the dmcdbpshell … The post How To Connect Azure Database From SQL Management Studio and from Azure Portal appeared first on Database Tutorials.>> Read more
