MSSQL and TSQL Programming and TSQL Examples
Hello everyone, In this article I will try to give information about the types of Cursors in SQL Server and when they are used. There are 4 types of cursors in SQL Server: Forward-Only, Static, Dynamic and Keyset. Forward-Only Cursors A type of cursor that only allows the resulting result...
Hello everyone, In this article, I will talk about the use of cursor that disconnects the database before detach in SQL Server. Actually I wrote this Cursor on a question. Thinking it might be useful to someone. While detaching in SQL Server, you may encounter errors upon connection. These errors...