SQL Cursor Archives - Page 2 of 5 - SQL Authority with Pinal Dave

SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database

November 20, 2008

SQL Cursor, SQL Scripts, SQL Stored Procedure

SQLAuthority Blog reader YordanGeorgiev has submitted very interesting SP, which uses cursor to generate text of all the Stored Procedure of current Database. This task can be done many ways, however, this is also interesting method. USE AdventureWorks GO DECLARE @procName VARCHAR(100) DECLARE @getprocName CURSOR SET @getprocName = CURSOR FOR SELECT s.name…

SQL SERVER – Guidelines and Coding Standards Complete List Download

September 25, 2008

Pinal Dave

SQL Tips and Tricks

Best Practices, Data Warehousing, Database, DBA, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL Data Storage, SQL Download, SQL Function, SQL Index, SQL Joins, SQL Scripts, SQL Server Security, SQL Stored Procedure, SQL Trigger, SQL Utility

Coding standards and guidelines are very important for any developer on the path to a successful career. A coding standard is a set of guidelines, rules and regulations on how to write code. Coding standards should be flexible enough or should take care of the situation where they should not prevent best practices for coding. They are basically the guidelines that one should follow for better understanding.

SQL SERVER – Interview Questions and Answers – Part 2

September 13, 2008

Pinal Dave

SQL Interview Questions and Answers

Data Warehousing, SQL Constraint and Keys, SQL Cursor, SQL Function, SQL Index, SQL Joins, SQL Scripts, SQL Server, SQL Stored Procedure

This is the second part of the blog post series Interview Questions and Answers.Click here to get free chapters (PDF) in the mailbox

SQL SERVER – Readers Contribution to Site – Simple Example of Cursor

July 16, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Cursor, SQL Scripts

eaders are very important to me. Without their active participation this site would not be the community helping web site. I encourage readers participation and request that you help other users with your knowledge. I recently come across very good communication between two of blog readers. I want to thank…

SQL SERVER – Is Cursor Database Object or Datatype?

April 19, 2008

Pinal Dave

SQL Interview Questions and Answers

SQL Cursor, SQL Server

Whenever we want to loop something we always look for logic like WHILE LOOP or FOR LOOP. Trust me on my word that both of them are cursor when it is about SQL Server.

SQL SERVER – Simple Example of Cursor – Sample Cursor Part 2

March 5, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Cursor, SQL Scripts

I have recently received email that I should update SQL SERVER – Simple Example of Cursor with example of AdventureWorks database. Simple Example of Cursor using AdventureWorks Database is listed here. USE AdventureWorks GO DECLARE @ProductID INT DECLARE @getProductID CURSOR SET @getProductID = CURSOR FOR SELECT ProductID FROM Production.Product OPEN @getProductID FETCH…

SQLAuthority News – Best Articles on SQLAuthority.com

November 4, 2007

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Performance, SQL Server, SQL Tips and Tricks

Data Warehousing, Database, DBA, Software Development, SQL Backup and Restore, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL DateTime, SQL Download, SQL Error Messages, SQL Function, SQL Humor, SQL Index, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure, SQL Trigger, SQL Utility

SQL SERVER – Cursor to Kill All Process in Database SQL SERVER – Find Stored Procedure Related to Table in Database – Search in All Stored procedure SQL SERVER – Shrinking Truncate Log File – Log Full SQL SERVER – Simple Example of Cursor SQL SERVER – UDF – Function…