Create a sequence called Store_seq with the following values: increment by 10, start with 500
Create a sequence called Store_seq with the following values: increment by 10, start with 500
Answer Question
| Jul 8 2008 6:34 AM GMT
| asked by
VB RD
SQL sequences, SQL queries
Looking for a database name query in SQL
Is there a query in SQL that could return me the name of a database, or whether it is connected to SQL Server or Oracle?
View Answer
| Jul 2 2008 5:49 PM GMT
| asked by
SQL Server Ask the Experts
SQL, Query, Database
xp_fileexist workd in Query window but doesnt in stored procedure
Hello,I am running on SQL server on my local PC . I am singed onto the PC using a network user.This probelm happens if the SQL server service runs as either Local system or network service.In the server management studio if I go to a query window and enterDeclare @result intexec xp_fileexist...
Answer Question
| Jun 26 2008 1:59 PM GMT
| asked by
Kendo
MS SQL, Stored procedures, SQL error messages
sql quries
i m a beginer in computer science.so how can i make grip on oracle sql plusis there any website or any electronic book that contains preset quries on sql which can help me in working in sqli want a guide book which has quries to start and work in sql plus and developer.
View Answer
| Jun 26 2008 1:21 AM GMT
| asked by
Yasir oracle
Oracle SQL, SQLPlus, Oracle
Using co-related queries in SQL
How do you use co-related queries in SQL and why would they be useful? Is there any effect on performance when executing a co-related query?
View Answer
| Jun 18 2008 3:46 PM GMT
| asked by
SQL Server Ask the Experts
SQL, Query, SQL queries
row_number in sql 2000
how to find out the row_number in sql 2000 like using row_number() function in sql 2005
View Answer
| May 8 2008 10:51 PM GMT
| asked by
Rl
ROW_NUMBER, SQL Query, SQL Server 2000
sql query
from this table i have to take those records that have common gridcode and then from these records i have to store the records having maximum area in another table...gridcode state area13013 rajasthan 5000013013 gujarat 4500013014 rajasthan 2500013014 gujarat 25000
View Answer
| Apr 30 2008 5:50 AM GMT
| asked by
Aanshi123
SQL, SQL queries
Difficult SQL query, is this possible?
Two tables,First Table--FN---LN----ReasonsJohn | Doe | 6 |Jane | Doe | 2 |-----------------That's the end of the first table.Second Table---Reason----Reason Detail----- 2 | Invalid SSN 4 | Invalid Date Of Birth--------------------------------------That's...
View Answer
| Apr 16 2008 11:37 PM GMT
| asked by
David Phillips
SQL, Query, Query tuning
Having problems converting SQL Server queries to stored procedures
I am using SQL Server queries as in-script and I have now decided to use the queries as stored procedures. However, I am facing some problems while converting the SQL Server queries into stored procedures. It’s a book search functionality based on book name and author name.My Old SQL query, which...
View Answer
| Mar 21 2008 8:38 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server, Stored procedures, SQL queries
How to make a single row in SQL
Dear all,Please help me I am not good in sql queries.I have a view like this.SNo Employee title Cdate IN TIME OUT...
View Answer
| Feb 20 2008 6:31 AM GMT
| asked by
Binu.emiliya
Query, SQL queries, SQL
