Results 1 - 15 of about 2098 sawaal for "sql"
You may chose to use one of the PL/SQL integrated development environments such as TOAD, PL/SQL Developer or Oracles new Raptor . For a new developer we recommend using SQLPlus because it is simple and will keep you from confusing PL/SQL errors and the tool errors. You will find that the first thing a developer needs to do is understand the Oracle and PL/SQL error messages . Remember, a development tool can
Posted in
Computers & Technology by tanu priya at 7:04 PM on July 05, 2008
Why would you use MySQL over PostgreSQL? First, we need to consider the needs of the applications in terms of database requirements. If I want to create a Web application and performance is an issue, MySQL will be my choice because its fast and designed to work well with Web-based servers. However, if I want to create another application that demands transactions and foreign key references, PostgreSQL
Posted in
Computers & Technology by panu at 1:55 PM on July 11, 2008
hi thereThere are some softwares by which u can convert ms sql data to mysql data.some of that are as follows;MSSQL-to-MySQL is a program to migrate Microsoft SQL databases to MySQL server. Depending on your privileges on the target MySQL server you can export MS SQL data into new database or overwrite the contents of an existing MySQL database.u can download it from;http://www.download3k.c om/Sy stem
Posted in
Computers & Technology by baladutt at 5:20 PM on July 14, 2008
sql,oracle n pl/sql are different things. actually these are different only due to there execution style n behaviour. but these all are concerned with only one thing i.e database management system. I in oracle like ata retriving n updating . we use sql to execute commands in oracle. sql is nothing but only a language .there are two parts in database management---database administrator and second
Posted in
Computers & Technology by Nikhil Singh at 5:40 PM on July 12, 2008
SQL Server uses a dynamic link library DLL, called a Net Library, to communicate with a particular network protocol. A matching pair of Net Libraries must be active on both client and server computers to support the desired network protocol. For example, to enable a client application to communicate with a specific instance of SQL Server across TCP/IP, the client TCP/IP Sockets Net Library
Posted in
Computers & Technology by Mohd Farooq at 4:24 PM on June 25, 2008
Tags
shashi SQL Structured Query Language pronounced /skjul / officially, although the nonstandard pronunciation /sikwl/ is often used see below, is a database computer language designed for the retrieval and management of data in relational database management systems RDBMS, database schema creation and modification, and database object access control management.[1...][2...]SQL is a standard interactive
Posted in
Computers & Technology by shashi verma at 9:00 PM on May 03, 2008
- 2. You must also be installed and functionalNow follow instructions as below:1> Install mysql mysql-server: yum install mysql mysql-server2> Start MySQL server daemon mysqld: service mysqld start3> Login as root database admin to MySQL server: mysql -u root4> Change root database admin password: note: once this step is complete youll need to login with: mysql -u root -p :mysql> SET
Posted in
Computers & Technology by sona rane at 11:36 PM on May 01, 2008
1433 is assigned as a default TCP/IP socket for Sql server.This Net-Library allows SQL Server to communicate by using standard Windows Sockets as the IPC method across the TCP/IP protocol. By default, Windows 95/98 uses the TCP/IP Sockets Net-Library.If you set SQL Server to listen on TCP/IP, type the TCP/IP port number in the Port number box. This is the port that SQL Server listens on when accepting
Posted in
Computers & Technology by Mohd Farooq at 4:25 PM on June 25, 2008
.shareup.com/MySQLGUI-download- 47188.html, www.download3000.com/download10269 .html - 64k hope this inf helps u a lot !...well;MySQL GUI Tools Bundle for 5.0 is available under the MySQL AB "dual licensing" model. Under this model, users may choose to use MySQL products under the free software/opensource GNU General Public License commonly known as the "GPL" or under a commercial license.Support, training
Posted in
Computers & Technology by shashank at 9:04 PM on June 10, 2008
database named "scdatabase" in SQL-ServerStep 2: Create a table "Ledger" which contains 2 fields "Name" and "Parent"Step 3: Add few records to the "Ledger" tableStep 4: Write a SQL-query to fetch data from Ledger table of "scdatabase" as given below:-SQL-query<SQL.L IST><SQL> SELECT name AS name,parent FROM ledger </SQL></SQL
Posted in
Computers & Technology by MILIND at 7:53 PM on June 14, 2008
SQL is a declarative language that allows database programmers to write a SQL declaration and hand it to the database for execution. As such, SQL cannot be used to execute procedural code with conditional, iterative and sequential statements. To overcome this limitation, PL/SQL was created.PL/SQL is Oracles Procedural Language extension to SQL. PL/SQLs language syntax, structure and data types
Posted in
Computers & Technology by SUNIL . at 8:41 PM on October 07, 2008
SQL Server 2005 Enterprise Edition provides a complete set of enterprise data management and business intelligence features andbecause it is optimized to run on x64 and Itanium-based serversis the most scalable and available edition of SQL Server 2005.The installation instruction are given below-Note: You must have administrative rights on the computer to install SQL Server 2005 SP1. Step 1
Posted in
Computers & Technology by Kehar Singh at 5:58 PM on August 08, 2008
the ASP.NET SQL Server Setup wizard.You can enter Aspnetregsql /? at the command line to obtain a list of optional parameters for SQL Server or SQL Server Express that you can use to bypass the wizard. If you are using a local SQL Server database, for example, you can enter aspnetregsql -S local -E -A m, where -S local indicates that the server is local, -E indicates that the connection uses Windows
Posted in
Computers & Technology by Harshil at 7:22 PM on June 13, 2008
well bala it is Microsoft SQL Server is far from being the only database management system for Windows. Among SQL Servers contenders are commercial applications like Oracle and freebies like MySQL. In this tip, Ill examine in detail MySQL now in its 5.0.22 revision and compare its features to Microsoft SQL Server 2000 and 2005. Both are powerful DBMSs, widely used, with aspects that make them attractive
Posted in
Computers & Technology by bala at 10:14 PM on April 01, 2008
SQL Server 2005 Service Broker remote security includes operations that involve more than one instance of SQL Server when those operations use either dialog security or transport security. The following example demonstrates how to use certificates for SQL Server 2005 Service Broker remote security on two instances of SQL Server 2005.. You installed two instances of SQL Server 2005 on different
Posted in
Computers & Technology by hardik at 12:44 PM on May 21, 2008
