Introduction to SQL Server 2000 & Relational Databases
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
seminar surveyer
Active In SP

Posts: 3,541
Joined: Sep 2010
12-10-2010, 02:05 PM

Presented by:

.ppt   SQL2.ppt (Size: 332.5 KB / Downloads: 49)


SQL Server is a client/server based relational database management system
Runs on Windows 2000 Professional, Server, Advanced Server, NT 4, Windows 9x/ME or Windows CE
Included in BackOffice product family
Include in .Net Servers family

SQL Functions

SQL Aggregate Functions
• AVG() - Returns the average value
• COUNT() - Returns the number of rows
• FIRST() - Returns the first value
• LAST() - Returns the last value
• MAX() - Returns the largest value
• MIN() - Returns the smallest value
• SUM() - Returns the sum
SQL Scalar functions
• UCASE() - Converts a field to upper case
• LCASE() - Converts a field to lower case
• MID() - Extract characters from a text field
• LEN() - Returns the length of a text field
• ROUND() - Rounds a numeric field to the number of decimals specified
• NOW() - Returns the current system date and time
• FORMAT() - Formats how a field is to be displayed
The AVG() Function
The AVG() function returns the average value of a numeric column.

.doc   SQL Functions.doc (Size: 134.5 KB / Downloads: 43)

Important Note..!

If you are not satisfied with above reply ,..Please


So that we will collect data for you and will made reply to the request....OR try below "QUICK REPLY" box to add a reply to this page

Quick Reply
Type your reply to this message here.

Image Verification
Please enter the text contained within the image into the text box below it. This process is used to prevent automated spam bots.
Image Verification
(case insensitive)

Possibly Related Threads...
Thread Author Replies Views Last Post
  Introduction to Cloud Computing project uploader 4 4,675 22-03-2014, 05:27 PM
Last Post: navasfiroz
  SQL INJECTION A SEMINAR REPORT Computer Science Clay 9 9,454 18-03-2014, 04:28 AM
Last Post: MichaelKa
  Introduction to Multimedia Systems seminar projects maker 0 501 28-09-2013, 01:15 PM
Last Post: seminar projects maker
  AN INTRODUCTION TO TCP/IP REPORT seminar projects maker 0 451 26-09-2013, 04:31 PM
Last Post: seminar projects maker
  Introduction to Functions PPT seminar projects maker 0 380 25-09-2013, 12:45 PM
Last Post: seminar projects maker
  Open Core Protocol ( OCP ) An Introduction to Interface Specification seminar projects maker 0 536 24-09-2013, 12:29 PM
Last Post: seminar projects maker
  Tutorial On Introduction to 8085 Architecture and Programming seminar projects maker 0 390 20-09-2013, 03:52 PM
Last Post: seminar projects maker
  Introduction to Image Processing PPT seminar projects maker 0 512 13-09-2013, 04:56 PM
Last Post: seminar projects maker
  Introduction to Expert Systems PPT project girl 1 677 12-09-2013, 04:01 PM
Last Post: seminar projects maker
  INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS seminar paper 3 1,558 12-09-2013, 09:39 AM
Last Post: seminar projects maker