What is DATABASE & SQL Server...

Question

What Is SQL Server....
          Is this Programming Language? if Not what is This.
          Is this DATABASE Development Software/Developing Tool.
          I m Only Understand VB.NET Language , So Can i Use VB.NET Language For Make DATABASE?
          What is OUT Put Of DATA Base.

Am i ASK These Question In Valid Forum?

What is Benifite of Learn DATA BASE ANd in WHich field DATABASe is used.

Thanks You Very very very Much.

I need your Suggestion , Your Help , your Support

---

www.shariqdon.media.officelive.com

Answer 1

Hello

A database is basically a place where to store data (hopefully in a structured manner).  You store information in databases to temporary or permanent storage.  Databases are used everywhere, shops record their sales data over time and some analysis the data to see how they can increase their profits, banks have databases, councils use databases to track electricity and water usage, the list goes on.   Wikipedia says: Microsoft SQL Server is a relational model database server produced by Microsoft. Its primary query languages are T-SQL and ANSI SQL. 

SQL Server itself is not a programming langauge but it uses a programming language called TSQL.  The code below will update the title of every record in the People table when their gender is M (male).

UPDATE People SET [Title]='MR' WHERE [Gender]='M'

You can go to http://www.microsoft.com/express/sql/Default.aspx to download the free version of SQL Server.  SQL Server is not the only database platform available there are also others like Oracle and DB2.  Allot of people start learning about databases by using Microsoft Access.  Though it is not used in large environments/production Access is a good learning tool.

Hope this answers your questions


Rob

Answer 2

Hi,

Check this Link

http://w3schools.com/sql/default.asp

---

Rajesh Jonnalagadda http://www.ggktech.com

Answer 3

Supposly I want to Make DATA Base IN VB.NET , Which Tool I need to Use
Here Is  I m Use DATAGridview ...

Public Class Form1
    Dim DtaSet As New DataSet
    Dim WithEvents DGrid As New DataGridView
    Dim WithEvents button1 As New Button
    Dim Tbl As New DataTable
    Public PathName As String = "C:\Tst\"
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Me.Size = New Size(600, 700)
        Me.Location = New Point(10, 10)
        Me.StartPosition = FormStartPosition.Manual
        'A datagridview to see and edit the data
        DGrid.Width = 400
        DGrid.Height = 600
        Me.Controls.Add(DGrid)
        'Show the data in Tbl in the datagridview
        DGrid.DataSource = Tbl
        'A dataset to manage the data
        DtaSet.Tables.Add(Tbl)
        'A table to hold the data
        Tbl.Columns.Add("Items")
        Tbl.Columns.Add("Description")
        Tbl.Columns.Add("Value")
        Tbl.Columns.Add("Total")
        Tbl.Columns.Add("Extra1")
        Tbl.Columns.Add("Extra2")
        Tbl.Columns.Add("Extra3")
        ' A save data button
        button1.Location = New Point(440, 600)
        button1.Text = "Save Data"
        Me.Controls.Add(button1)
        If Not IO.Directory.Exists(PathName) Then  'If it don't exist
            IO.Directory.CreateDirectory(PathName) 'Create a new directory for the database 
        End If
        If IO.File.Exists(PathName & "Main.xml") Then
            Tbl.ReadXml(PathName & "Main.xml") 'Load existing data if exist 
        Else
            Tbl.WriteXml(PathName & "Main.xml") 'If dont exist, create it
        End If
   End Sub
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Tbl.WriteXml(PathName & "Main.xml") 'save the data entered in the DataGridView
    End Sub
End Class

Why Develpor Use XML file To save DATA...
Thanks

---

www.shariqdon.media.officelive.com

Answer 4

is this Right Forum For DATABASE Or SQL Server????????

---

www.shariqdon.media.officelive.com

Answer 5

This is a SQL Server forum.  You could probably get away with asking generalised questions about database but this forum is primarily used for SQL Server questions and discussions.