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

SQL SERVER – SET ROWCOUNT – Retrieving or Limiting the First N Records from a SQL Query

April 30, 2007

SQL Cursor, SQL Scripts, SQL Server, SQL Server Security

A SET ROWCOUNT statement simply limits the number of records returned to the client during a single connection. As soon as the number of rows specified is found, SQL Server stops processing the query. The syntax looks like this:

SQL SERVER – Random Number Generator Script – SQL Query

April 29, 2007

Pinal Dave

SQL Tips and Tricks

SQL Cursor, SQL Random, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Utility

Random Number Generator. There are many methods to generate random numbers in SQL Server.
Method 1: Generate Random Numbers (Int) between Rang

SQL SERVER – Good, Better and Best Programming Techniques

April 28, 2007

Pinal Dave

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

SQL Backup and Restore, SQL Constraint and Keys, SQL Cursor, SQL Download, SQL Function, SQL Index, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure, SQL Trigger

A week ago, I was invited to meeting of programmers. Subject of meeting was “Good, Better and Best Programming Techniques”. I had made small note before I went to meeting, so if I have to talk about or discuss SQL Server it can come handy. Well, I did not get…