0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
Diff between sql server 2000 and sql server 2005?
Hi Everybody, I am Vijay.According 2 me the differences are: 1. In SQL Server 2000 the Query Analyzer and Enterprise Manager are seperate,whereas in SQL Server 2005 both were combined as Management Studio. 2. In Sql 2005,the new datatype XML is used,whereas in Sql 2000 there is no such datatype 3. In Sql server2000 we can create 65,535 databases,whereas in Sql server2005 2(pow(20))-1 databases can be created.
Basic structure of SQL?
SQL: Basic structure
What is procedure to create a table in sql?
We can create a table in sql using CREATE TABLE command.CREATE TABLE is having a complex syntax. Few examples on how to create a table are listed below CREATE TABLE tablename ( Fieldname1 datatype, Fieldname2 datatype, . . . FieldnameN datatype ); Example: create table faculty ( fname varchar(30), addr varchar(30), phone char(12), email varchar(50), doj datetime, sal money, expr varchar(20) ) If you want to make a field as key field,you can do by specifying as primary key. CREATE TABLE tablename ( Fieldname1 datatype primary key, Fieldname2 datatype, ); Example: create table skillset (skid int primary key, skname varchar(15) ) For more help on datatypes check out http://msdn.microsoft.com/en-us/library/ms187752(SQL.90).aspx For more help on creating table in sql checkout http://msdn.microsoft.com/en-us/library/ms174979(SQL.90).aspx anandmca08@gmail.com
How much SQL DBA earn?
The national normal SQL Server Database Administrator pay is ₹6,00,000. Channel by area to see SQL Server Database Administrator pay rates in your general vicinity. Compensation gauges depend on 86 pay rates submitted namelessly to Glassdoor by SQL Server Database Administrator representatives.
What are some basic SQL queries?
Some basic SQL (structured query language) queries are regarding how to be more efficient and productive as you have to have a detailed knowledge of how to use the structure of the database for it to be useful. Queries generally involve basic formatting of the system and how to use it.
What are the differences between sql and mysql?
SQL is short for Structured Query Language, and MySQL is a database management system, like SQL Server 2005, Oracle.An example would be other programming languages like BASIC and QBASIC where BASIC is the generic term for the BASIC programming language and QBASIC is Microsoft's version (quick BASIC) and TURBO BASIC was Borlands version.oracle supports the user defined datatypes,where as mysql not support all these types of datatypes, like user defined , and cursors like these stuff;;
How do you run multiple sql queries in visual basic 2008 express edition?
you dont
Are there pre-requisites to take a SQL class?
There are many pre-requisites to taking a SQL class. You have to have server skills, a basic programing language, most people who take this class are IT professionals.
Where can I get free SQL training?
Most of the SQL training programs offered online are for pay or only cover the basics. Some of the best free training can be found on Youtube or individual blogs.
How do you connect vb with sql server?
search for this line below there is a video you can watch" VB.NET Database Tutorial - Connecting To Microsoft SQL Server (PART 1) (Visual Basic .NET) Thank you Dariush from Wickenburgnet.com
What are the parts of a basic SQL query?
The basic parts of a SQL Select query are: SELECT column names FROM table name WHERE conditions ORDER BY column names The basic parts of an insert query would be: INSERT INTO table name (VALUES) The basic parts of a delete query would be DELETE FROM table name WHERE conditions The basic parts of an update query would be UPDATE TABLE table name SET column name = value WHERE conditions
What is collection in oracle 11g?
Collection is a composite datatype in oracle and it can also be called as pl/sql table which is used to store collection of similar datas as like an array of C.There are three types in collections 1.Associative array 2.Nested Table 3.Varray
