|
Displaying 1 - 50 of about 1630 Related Tutorials.
|
 What is a "constraint"?
What is a "constraint"? What is a "constraint
|
Drop Check constraint without constraint name in oracle
Drop Check constraint without constraint name in oracle I created check constraint for my table.I forgot its name.Now I want to drop that constraint without constraint name
|
What is an integrity constraint ?
What is an integrity constraint ? What is an integrity constraint ?
An integrity constraint allows the definition of certain restrictions, at the table level, on the data that is entered into a table
|
|
|
Drop constraint of table in oracle without specifying constraint name
Drop constraint of table in oracle without specifying constraint name I create my table in oracle with check constraint but I forgot constraint name.Now I want to drop constraint of my table without specifying constraint name
|
mysql alter table add unique constraint
mysql alter table add unique constraint How to add mysql alter table add unique constraint in mysql table.
Thanks
Hi
Following query query can be used:
ALTER TABLE mytable
ADD CONSTRAINT uc_key1 UNIQUE
|
|
|
sql
difference between sql and oracle what is the difference between sql and oracle
|
sql
sql how to get first row in sql with using where condition in sql?
how to get last row in sql with using where condition in sql
|
sql
sql I want interview sql questions
Please visit the following link:
SQL Tutorials
|
Sql
Sql how to find maximum of a101,a102,a103 from a table in sql
|
SQL
SQL hii
What is sql?
hello,
SQL, which stands for Structured Query Language, is a special-purpose language used to define, access, and manipulate data. SQL is non procedural, meaning that it describes
|
sql
sql returning value from a store procedure in sql with example
Please visit the following links:
http://www.roseindia.net/mysql/mysql5/stored-procedures-and-functions.shtml
http://www.roseindia.net/sql/create
|
SQL
SQL In my computer i have microsoft sql 2008.how can i set that in the cmd.i want to use that in cmd.what is the default username and password
|
SQL Alter Column Syntax
SQL Alter Column Syntax
SQL Alter Column Syntax modifies the existing table definition.
Understand with Example
The Tutorial illustrate an example from SQL Alter Column Syntax
|
SQL Alter Table Syntax
SQL Alter Table Syntax
SQL Alter Table Syntax modifies the existing table definition.
Understand with Example
The Tutorial illustrate an example from SQL
|
SQL
SQL 1)How to Store 1000 records in Oracle object.
2)Write a query for calculate highest, 3rd Highest & 10th highest salary from emp teble.
3)What is Sequence.
4)How to use rowid in Sql.
5)What is Views.
6)How
|
SQL
SQL how to get ( 15 march 2011) and (15/03/2011) output using SQL
Use the following queries to get the data from database in the given format.
For (15 march 2011) format:
SELECT DATE_FORMAT(dob, '%d %M %Y') FROM
|
SQL
SQL how to get ( 15 march 2011) and (15/03/2011) output using SQL
Use the following queries to get the data from database in the given format.
For (15 march 2011) format:
SELECT DATE_FORMAT(dob, '%d %M %Y') FROM
|
SQL
SQL Trigger query Why we use the Trigger and what it's uses?
A database trigger is procedural code that is automatically executed..., user events, and SQL statements to subscribing applications
10)Restrict DML
|
SQL
events, user events, and SQL statements to subscribing applications
10)Restrict DML
|
SQL
, user events, and SQL statements to subscribing applications
10)Restrict DML
|
SQL
events, and SQL statements to subscribing applications
10)Restrict DML
|
SQL
|
sql
|
SQL
|
sql
|
sql
|
sql
|
SQL
|
SQL
|
SQL
|
SQL
|
SQL
|
SQL
|
SQL
|
SQL
|
sql - SQL
order by SQL Query What is order by in SQL and when this query is used in SQL?Thanks! Hi,In case of mysql you can user following query.Select salary from salary_table order by salary desc limit 3,1Thanks
|
sql - SQL
want query?
4.what is the diffrence between sql and plsql? Hi Friend... HAVING n>1;
Difference between SQL and PL/SQL:
SQL is a structured query...(select,insert,update etc.), manipulate objects(DDL) and data(DML).
PL/SQL
|
sql - SQL
sql write a dyamic sql program to display the name of a employee whose salary is <5000 Hi Friend,
Use the following query... the following link:
http://www.roseindia.net/sql/
Thanks
|
SQL - SQL
SQL Jus c da case we hve certain images in some folder or some area in sql can we create trigger or procedure so dat in front like in asp page while clicking image it will be showed in page ...... ...I mean writing code for each
|
SQL - SQL
SQL How to combine 'LIKE' and 'IN' operators in sql query? select name from tab1 where name like 'R%' AND city in('bangalore','mumbai');
Table Name: tab1
FieldName
=====================
| name | city
|
Common SQL Commands
Common SQL Commands
SQL commands...). Here
are a list of SQL commands.
1. DML
COMMANDS
INSERTUPDATESELECTDELETE... datatype
[constraint], colname2 datatype [constraint]);
Example
|
sql - SQL
|
sql - SQL
|
SQL - SQL
|
sql server - SQL
sql server what is SQL server? & what is oracle? are they same
|
sql server - SQL
sql server How many no of tables can be joined in same sql server
|
SQL help - SQL
SQL help Hi Deepak,
Can u pls tell me what is the difference between PL/SQL and MYSQL?
Is there any difference in generating the code
|
SQL JOINS - SQL
SQL JOINS Hom many Joins In Sql?plz explian all those things? Hi Friend,
Please visit the following link:
http://www.roseindia.net/sql/sqljoin/index.shtml
Hope that it will be helpful for you.
Thanks
|
learn sql - SQL
learn sql how to learn sql......idont know anything about programming knowledge Hi Friend,
Please visit the following link:
http://www.roseindia.net/sql/
Thanks
|
sql 2000 - SQL
sql 2000 why binary data when inserted into the sql column of data type image or binary is stored in the form of hexadecimal nos. instead of the name of the file inserted?????
Thanx for ur response in advance
|
