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: 47)


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: 41)

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
Tagged Pages: introduction to sql server 2000 ppt, what is the mean of thi sql server is a client server based relational database management system, introduction to sqlserver 2000 and relational databases pdf, introduction to sql server ppt, contact backoffice me com loc es, introduction of sql doc file, scalar function in sql ppt,
Popular Searches: what is ontological relational discovery, advantages disadvantages client server computing pdf, 5gpp 2 umb cdma 2000, sql server seminar topics, translating sql queries into relational algebra ppt, sql server basics pdf ppt, sql server 2000 blob,

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,628 22-03-2014, 05:27 PM
Last Post: navasfiroz
  SQL INJECTION A SEMINAR REPORT Computer Science Clay 9 9,411 18-03-2014, 04:28 AM
Last Post: MichaelKa
  Introduction to Multimedia Systems seminar projects maker 0 481 28-09-2013, 01:15 PM
Last Post: seminar projects maker
  AN INTRODUCTION TO TCP/IP REPORT seminar projects maker 0 426 26-09-2013, 04:31 PM
Last Post: seminar projects maker
  Introduction to Functions PPT seminar projects maker 0 365 25-09-2013, 12:45 PM
Last Post: seminar projects maker
  Open Core Protocol ( OCP ) An Introduction to Interface Specification seminar projects maker 0 522 24-09-2013, 12:29 PM
Last Post: seminar projects maker
  Tutorial On Introduction to 8085 Architecture and Programming seminar projects maker 0 372 20-09-2013, 03:52 PM
Last Post: seminar projects maker
  Introduction to Image Processing PPT seminar projects maker 0 495 13-09-2013, 04:56 PM
Last Post: seminar projects maker
  Introduction to Expert Systems PPT project girl 1 657 12-09-2013, 04:01 PM
Last Post: seminar projects maker
  INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS seminar paper 3 1,513 12-09-2013, 09:39 AM
Last Post: seminar projects maker