Posted on December 14, 2008 by Raghunath Bhandari
SQL RAND Function
The SQL RAND() function is used to generate some random numbers at run time. Here is the syntax:
Syntax
RAND ( [ seed ] )
Repetitive calls of RAND() with the same seed value return the same results.
For one connection, if RAND() is called with a specified seed value, all subsequent calls of [...]
Filed under: SQL RAND Function | Tagged: Advance SQL tips and tricks, Database, Database Optimization Tips, dba, Introduction to SQL, Microsoft SQL server, MSSQL, MSSQL server, SQL, SQL Database Optimization Tricks, SQL help, SQL Optimization, SQL Optimization Tips, SQL Programming, SQL Query, SQL RAND Function, SQL Server, SQL server tips, SQL technology, SQL Tips, SQL Tips and Tricks, SQL tips for programmer, sqlhelp, T-SQL, what is SQL | Leave a Comment »
Posted on January 1, 2008 by Raghunath Bhandari
SQL is a standard language for accessing and manipulating databases.
What is SQL?
SQL stands for Structured Query Language
SQL lets you access and manipulate databases
SQL is an ANSI (American National Standards Institute) standard
What Can SQL do?
SQL can execute queries against a database
SQL can retrieve data from a database
SQL can insert records [...]
Filed under: Introduction to SQL | Tagged: Advance SQL tips and tricks, Author Raghunath Bhandari, Database, Database Optimization Tips, dba, Introduction to SQL, MCP, Microsoft Certified Professional, Microsoft SQL server, MSDN Help, MSDN SQL News, MSSQL, MSSQL server, SQL, SQL Database Optimization Tricks, SQL Database Settings Optimization Tips, SQL Documentation, SQL help, SQL Indexing Service, SQL Optimization, SQL Optimization Tips, SQL Programming, SQL Query, SQL Server, SQL server tips, SQL technology, SQL Tips, SQL Tips and Tricks, SQL tips for programmer, sqlhelp, sqlhelp news, sqlhelp WebSite Review, T-SQL, Technology News, what is SQL | 3 Comments »