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
#1
12-10-2010, 02:05 PM


Presented by:
k.gopal


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


Introduction

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: 42)
Reply

Important Note..!

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

ASK HERE

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