Binkod

Check SQL Server table latest logs like Last Updated, Last Access

There are situations when we need to check the last updated entry in a database table. So how do we check that last updated …

Tuesday, May 26, 2020

Sql Server Error | A connection was successfully established with the server, but then an error occurred during the login process.

Issue: While Initiating/opening a new connection, The following Error occurred! A connection was successfully establishe…

Thursday, May 17, 2018

SQL TRIM Functions - LTRIM and RTRIM

TRIM Functions in SQL Server TRIM function in SQL remove all specified trim char from beginning and ending of the string…

Tuesday, February 13, 2018

SQL Nested Queries | SQL Sub Queries

In nested queries, a query is written inside a sql query, also called sql subquery. A subquery is a query that is nest…

Thursday, October 26, 2017

Use of SELECT statement in SQL Server

SQL Server: SELECT Statement The SQL Server (Transact-SQL) SELECT statement is used to retrieve records from one or more …

Wednesday, December 28, 2016

SQL Server DBA Roles and Responsibilities

The SQL Server Database System from Microsoft Corporation has gained popularity over the years and it is believed to be o…

Tuesday, May 24, 2016

Use of Case Expression in SQL Server with Example

CASE  Expression     The SQL Server (Transact-SQL) CASE statement has the functionality of an IF-THEN-ELSE statement. You…

Saturday, August 22, 2015

Temporary Tables in SQL Server - Local & Global

SQL Server provides the concept of temporary table. These tables can be created at runtime and can do the all kinds of…

Tuesday, August 04, 2015

Using SQL Server Cursors - General concepts

General concepts: In this article, I want to tell you how to create and use server side cursors and how you can optimize …

Tuesday, August 04, 2015