Tags » T-SQL

Feed the results of a table select to a stored procedure

DECLARE @id uniqueidentifier

DECLARE cur CURSOR FOR SELECT Id FROM .
OPEN cur

FETCH NEXT FROM cur INTO @id

WHILE @@FETCH_STATUS = 0 
BEGIN
    EXEC . 17 more words
T-SQL

Updateable CTEs

CTEs are cool things. You can essentially create one or more in-line view(s) within your query. One thing that isn’t overly well known is that you can actually update the data within the CTE. 361 more words

SQLServerPedia Syndication

Monitoring SQL Server database status changes using T-SQL and PowerShell scripts

Monitoring a SQL Server database is a critical component of database administration. Ninety percent of the organizations expect the number of databases to increase over the next twelve months. 189 more words

SQL

Permissions required for developing with Temporal Tables

Temporal tables are one of those new (2016+) cool features that recently came across my desk. Basically, a temporal table is a combination of auditing columns (createdate) and a history table. 473 more words

SQLServerPedia Syndication

How to randomise the link to a pick-list

How do I randomise the link to a pick-list, so that the lookup goes to a different value with each run? Find out here.

SQL Server

SQL Server 2017 Temporal Enhancements

One of the most popular features in my talks about SQL Server 2016 has been the temporal tables feature. If you aren’t familiar with this feature you can read more… 172 more words

SQL