Results for "Varchar"
5 / 184 posts
XML Data – Complete Conceptual Guide (SQL Server Perspective)
How insert data on table from XML in SQL server, example: There are two method for insert data in table from XML. DECLARE @XMLInput VARCHAR(MAX); SET @XMLI…
Insert <br> tag in SQL text string
CREATE or ALTER FUNCTION dbo.Fn_InserBRtag(@inputString NVARCHAR(MAX)) RETURNS NVARCHAR(MAX) AS BEGIN DECLARE @resultString NVARCHAR(MAX) = ''; DECLARE @st…
SQL MERGE statement
CREATE DATABASE SqlShackMergeDemo GO USE SqlShackMergeDemo GO CREATE TABLE SourceProducts( ProductID INT, ProductName VARCHAR(50), Price DECIMAL(9,2) ) GO …
Understanding Default Size of VARCHAR in SQL Server
Introduction When working with SQL Server, developers often use the VARCHAR data type to store variable-length character data. However, many overlook a cri…
Dynamic CREATE TABLE Script in SQL Server
DECLARE @TableName NVARCHAR(100) = 'Employee'; DECLARE @SQL NVARCHAR(MAX) = ''; DECLARE @PKCols NVARCHAR(MAX) = ''; -- Get Primary Key Column(s) SELECT @PK…