CURSOR Performance and Alternatives - social.msdn.microsoft.com
May 21, 2008 · But there are exceptions to everything. There are situations where a cursor beats the corresponding set-based query with a wide margin. And there are situations when a WHILE loop is …
MySQL Select Query using Data from VFP Cursor
Aug 10, 2018 · No an SQL Server only has it's data. I guess the cursor you have already came from MySQL didn't it? If you want to refresh it the simplest way is repeating the same query, like a …
How to prevent uncommittable transaction when error occur?
Feb 21, 2014 · In my case, I have a table contain many of dynamic sql, and I use the cursor to get the dynamic sql from that table and execute the sql one by one, and I have used begin tran at start and …
stored procedure for rebuild indexes - social.msdn.microsoft.com
Oct 11, 2012 · DECLARE DBCursor CURSOR FOR SELECT name FROM master.dbo.sysdatabases where name <> 'tempdb' Thanks /Neil Moorthy - Senior SQL Server DBA/Developer (MCITP …
Delete All Data Collector objects in Database
Dec 16, 2014 · In my scenario the database is the collection database of team foundation server, so i need to delete all objects in the database from the data collector, i use the script but also i have …
SSMS 17.6 crashes and disappears when it starts
May 6, 2019 · My SSMS 17.6 in Windows 10 starts by showing the splash screen, then it shows just the login prompt without the UI of the app and then it disappears. The event log shows absolutely …
client-side/server side cursor - social.msdn.microsoft.com
Dec 10, 2008 · I'm using VS.NET 2005 (July CTP) to develop a windows application that connects to a SQL Server database. How can I set my connection to use server-side cursors instead of client-side?
Executing multiple dynamic sql statements - social.msdn.microsoft.com
Apr 19, 2013 · I haven't used SQL Server a lot, but I was thinking that a cursor might work for this problem. I would create a CURSOR as a SELECT from the temporary table that has the generated …
Delete all data and reset Identity - social.msdn.microsoft.com
Jun 6, 2013 · Need Delete all data in all the tables and reset Identity. (Looping) I designed a table tblOrderByRelationship which has a priority order to delete first the child then
SQL Azure + trigger + send email - social.msdn.microsoft.com
Sep 20, 2013 · Reference to database and/or server name in 'msdb.dbo.sp_send_dbmail' is not supported in this version of SQL Server.