Introduction to SQL Server 2000 & Relational Databases
#1

Presented by:
k.gopal

[attachment=5712]


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.

[attachment=5713]
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
Popular Searches: microsoft sql server 2012, wifi for seminar project in 2000 word, iscode456 2000 in pdf, project 2000 windows 7, sprename in sql server, is456 2000 2016 pdf download, learn sql server 2008,

[-]
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
  Implementation of RSA Algorithm Using Client-Server full report seminar topics 6 27,721 10-05-2016, 12:21 PM
Last Post: dhanabhagya
  SQL INJECTION A SEMINAR REPORT Computer Science Clay 10 12,242 18-10-2014, 09:50 PM
Last Post: jaseela123d
  INTRODUCTION astru 0 941 27-09-2014, 05:50 PM
Last Post: astru
  INTRODUCTION OF INTRANET CHATTING computer girl 1 3,190 24-02-2014, 01:48 AM
Last Post: Guest
  SLEEP SERVER & ITS ENTERPRISE APPLICATION seminar surveyer 5 2,959 03-12-2012, 11:25 PM
Last Post: Guest
  SQL INJECTION AND PREVENTION seminar class 3 2,124 24-10-2012, 01:09 PM
Last Post: seminar details
  A Quick Introduction to Voice over Internet Protocol (VoIP) computer girl 0 1,363 09-06-2012, 05:50 PM
Last Post: computer girl
  INTRODUCTION OF IP SPOOFING computer girl 0 1,052 08-06-2012, 12:01 PM
Last Post: computer girl
  Introduction of Mobile Agents computer girl 0 865 05-06-2012, 12:48 PM
Last Post: computer girl
  SQL Memory Management in Oracle9i seminar class 1 1,611 05-03-2012, 09:20 AM
Last Post: seminar paper

Forum Jump: