In previous versions of SQL Server, it has not been possible to pass a table variable, as a parameter, to a stored procedure. Microsoft introduces table-valued parameters, along with other features, in SQL Server 2008. This article illustrates the function and usage of table-valued parameters.
The second editorial from Steve Jones comparing software to other types of jobs continues with a look at the legal profession.
The second editorial from Steve Jones comparing software to other types of jobs continues with a look at the legal profession.
A look back at the news from the week including Windows 7 and taking an unwired vacation.
A look back at the news from the week including Windows 7 and taking an unwired vacation.
Is building software like building a house? Steve Jones digs into the comparison at the start of an editorial series looking at other professions.
Is building software like building a house? Steve Jones digs into the comparison at the start of an editorial series looking at other professions.
Is building software like building a house? Steve Jones digs into the comparison at the start of an editorial series looking at other professions.
A look back at the news from the week including Windows 7 and taking an unwired vacation.
In SQL Server 2005 there is the concept of alias data types, which are similar to user-defined data types in SQL Server 2000. Yakov Shlafman brings us the first part of a series looking at these structures in SQL Server 2000.
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
By Steve Jones
Recently I had someone internally ask about whether SQL Source Control supports Git Hooks....
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
I'm running a group MSA for the database engine and SQL Agent in a...
All, My query is as follows: SET DATEFORMAT dmy SELECT p.query_id, DATEADD(MICROSECOND,-rs.max_duration,rs.first_execution_time) AS starttime,...
Comments posted to this topic are about the item Encoding Strings
I have this code in SQL Server 2025. What is the result?
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(@message); SELECT @encoded AS EncodedResult;See possible answers