where @TotalCount is the number of rows in a table. We need to generate the above statement dynamically, so we use INFORMATION_SCHEMA.Columns view to do so. I use FOR XML PATH('') approach to concatenate information into one variable I use sp_executeSQ...
Concatenate distinct values to variable concatenate numbers (not add them) CONCATENATE ROW_NUMBER WITH LEADING ZERO FOR MAXIMUM OF 15 CHARACTERS Concatenate two columns using a trigger Concatenated Stored Procedure parameter value concatenating in the string and passing parameters with sp_executesql Concate...
where @TotalCount is the number of rows in a table. We need to generate the above statement dynamically, so we use INFORMATION_SCHEMA.Columns view to do so. I use FOR XML PATH('') approach to concatenate information into one variable I use sp_execute...
Concatenate a string to use after the AS statement Concatenate distinct values to variable concatenate numbers (not add them) CONCATENATE ROW_NUMBER WITH LEADING ZERO FOR MAXIMUM OF 15 CHARACTERS Concatenate two columns using a trigger Concatenated Stored Procedure parameter value concatenating in the st...
Basic - select with fixed values - invert columns to rows Basic CTE query, get full path of something recursive BCP Error - Copy direction must be either 'in', 'out' or 'format'. BCP Export to csv using UTF-8 or UTF-16 BCP Issue when using a format file and excluding columns. BCP...
Basic - select with fixed values - invert columns to rows Basic CTE query, get full path of something recursive BCP Error - Copy direction must be either 'in', 'out' or 'format'. BCP Export to csv using UTF-8 or UTF-16 BCP Issue when using a format file and excluding columns. BCP...