Tagged: T-SQL

SQL Cache Dependency with SqlDataSource

To enable a cache dependency on a particular database, run this command in from a command-line prompt: This creates a new table, AspNet_SqlCacheTablesForChangeNotification, in the designated database. Next, several AspNet_SqlCacheXxxx stored procs are created...

T-SQL Cursor Usage

Cursor allows us to perform line-by-line operations within the returned values in SQL Server. We make this structure, which we use frequently in programming languages, thanks to the cursor in the database. We can...