SQL Server 2008 introduced DATENAME function that return name of datepart of the specified date. Syntax DATENAME ( datepart , date ) Example [crayon-6515f2e65e62e460493761/] 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
Today I will explain regarding storing and retrieving images, videos and other document files from SQL server using the FILESTREAM feature. If you are new to FILESTREAM then
SQL Server uses a process called parameter sniffing when it executes a stored procedure that has parameters. When the procedure is compiled or recompiled, the value passed in
In this blog, we will look into accessing a newly-added column to a table. We can add a new column to an existing table. using ALTER statement using: ALTER TABLE table_name ADD column_name datatype; Similarly,
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
