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...
“CS” / “CI” – Obviously, this one is just case sensitivity between upper and lower case. The default during SQL Server install as well as a database creation is “case insensitive”. With case-insensitive, your queries...
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...
Actually, this code has several purposes. It gives Identity information only when the table name is given. When ‘reseed‘ is added, if the table has a problem with identity, it helps to fix it,...