Granting a user access to a database involves three steps. First, you create a login. The login lets the user connect to the SQL Server Database Engine. Then
This article introduces four ways for SQL Server users to enable Mixed Mode Authentication from installation to use. Way 1: Enable Mixed Mode Authentication during SQL Server Installation Way 2:
In this article, I will explain how to detect the current Cumulative Update / Service Pack installed on your SQL Server. Detect the Current Cumulative Update / Service
Get Basic Information The first step is get basic information, judgment branch does not support stack query: [crayon-647b1f6338719276083004/] To determine whether the station library separation: [crayon-647b1f633871f136410260/] See if
SQL Server 2008 introduced DATENAME function that return name of datepart of the specified date. Syntax DATENAME ( datepart , date ) Example [crayon-647b1f6338d6e678265088/] Output In this
On this article, I am going to tell you about Check Object Definition in different way. sp_helptext is wide used for checking object definition in SQL Server. sp_helptext
In this blog, I have explained the process of securing password using Encryption and Decryption in SQL Stored Procedure. STEP 1 Open SQL Server and create database and table
In some cases we need to select and modify the record based on specific conditions. So instead of using cursor or looping, we can use case CASE expression.