|
some times we hv to give Sum(COST) COST (we hv to give spae instead of 'as')
self confidence+hard work=SUCCESS
|
|
|
|
|
hi guys ,,,
actually i am very much new to oracle, i just want to
ask that cam we use sql joins in oracle
if not than how can we get data from different tables
based on a particular chriteria,,,
thanks in advance
hello
|
|
|
|
|
Yes.
for fetching data from more than one table, Joins can be used in Oracle.
Regards
KP
|
|
|
|
|
Hi All,
I need a URL from where I can download sample stored procedures, with which I can learn different techniques to write stored procedures. We have 101 Sample C# codes available to download in MSDN site, I am looking for similar kind of with respect to stored procedures.
Can any body help me….
Thanks in advance
Regards,
Krishnaraj
|
|
|
|
|
|
hello krishna, can u tell how to get that 101 sample c# codes from MSDN site, can u give me the link?
self confidence+hard work=SUCCESS
|
|
|
|
|
Please make me clear that
will INT(4) and VARCHAR(4) will consume same storage space in SQL Server 2000 ?
|
|
|
|
|
Navaneeth. wrote: will INT(4) and VARCHAR(4) will consume same storage space in SQL Server 2000 ?
No.
For More Details Here[^]
Regards,
Satips.
|
|
|
|
|
How to Customized SQL Report Viewer Control ? e.g The Export Combo Should only convert the Report to PDF and User Cannot Convert it to another Format
Plz Help me!
Ali
|
|
|
|
|
Hi there,
anyone using Pervasive SQL 8.0??
I have an issue with transactions using C# on Pervasive SQL 8.0. The transaction does not wait when there is a lock (another transaction operating) on the table.
It just throws an exception.
Thanks for helping
|
|
|
|
|
What Exception it throws?
Regards,
Satips.
|
|
|
|
|
A btrieve error 85 is thrown, which means the file is locked. Right now, my solution to this problem conbsists of looping through a try-catch block and keep trying until the file is unlocked. I was just wondering whether there is a more elegant solution to that..
bool bSuccess = false;
int nCount = 0;
while (!bSuccess && nCount < 30)
{
try
{
da.Update(dsControl, "Control"); // this throws the exception if
// there is a lock on Control
bSuccess = true;
}
catch (Exception ex)
{
nCount++;
}
}
I suspect something wrong with Pervasive SQL 8.0.. :$
|
|
|
|
|
Hi.
I have a SSIS package named TESTPACKAGE on the 2005 SQL Server.
How I can exeucte it from VB.NET?
I found some articels that refer to Microsoft.SQLServer assembly but I use older .NET Framework version (1.1) and this assembly is not availabe for me in Visual Studio (2003).
I read something about DTEXEC command. Can I use it in the Stored Procedure to run SSIS. I used this code in the Stored Procedure to run DTS package on the previsous/older SQL Server version.
<br />
CREATE PROCEDURE dbo.exportData AS<br />
Exec master..xp_cmdshell <br />
'DTSRUN /SMYSERVER /NTESTDTS /Umyaccess /Pmypassword'<br />
GO
Thank you,
|
|
|
|
|
Hope this will Help you.
DECLARE @cmd VARCHAR(255)
DECLARE @Wait INT
DECLARE @result INT, @OLEResult INT
DECLARE @ShellID INT
SET @Wait = 0
SET @cmd = 'DTEXEC /sq "TestSSPSPackageName" /ser /Set \Package.Variables[User::varTargetName].Properties[Value];"c:\dtsxTest\Test2.txt"'
-- create instance of OLE object
EXECUTE @OLEResult = sp_OACreate 'WScript.Shell', @ShellID OUT
IF @OLEResult <> 0 SELECT @result = @OLEResult
IF @OLEResult <> 0 RAISERROR ('CreateObject %0X', 14, 1, @OLEResult)
-- run package
EXECUTE @OLEResult = sp_OAMethod @ShellID, 'Run', NULL, @cmd, 0, @Wait
IF @OLEResult <> 0 SELECT @result = @OLEResult
IF @OLEResult <> 0 RAISERROR ('Run %0X', 14, 1, @OLEResult)
If @OLEResult <> 0 EXEC sp_OAGetErrorInfo @ShellID, @OLEResult
-- drop object
EXECUTE @OLEResult = sp_OADestroy @ShellID
-- I think this will run an an asynchronous process.
Regards,
Satips.
|
|
|
|
|
I am probabely be called an idiot rom now on but I can't figure this out, tried everything. Here I have to trasfer in SQL a very disfunctionnal FMP database. This is the function that verifies the dates. The problem I have is this:
It works perfectly when the original date (formatted 01/01/1800) is correct but the last part should overwrite any malformed date (anyways that was the intention....) but none get overwritten. I always get the malformed date back. It is as if @DateTest never gets put to False. Help!!
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[GetBirthDate]
(
@BirthDate nvarchar(10)
)
RETURNS nvarchar(10)
AS
BEGIN
DECLARE @ReturnValue nvarchar(10)
DECLARE @DateTest bit
SET @DateTest = 'True'
IF (@BirthDate = '00/00/00' OR @BirthDate = '' OR @BirthDate = '?' OR @BirthDate IS NULL)
SET @ReturnValue = '1800-01-01'
ELSE
BEGIN
IF LEN(@BirthDate) = 10
SET @ReturnValue = SUBSTRING(@BirthDate, 7, 4) + '-' + SUBSTRING(@BirthDate, 4, 2) + '-' + LEFT(@BirthDate, 2)
ELSE
SET @ReturnValue = '19' + SUBSTRING(@BirthDate, 7, 2) + '-' + SUBSTRING(@BirthDate, 4, 2) + '-' + LEFT(@BirthDate, 2)
END
IF (SUBSTRING(@ReturnValue, 1, 2) <> '19' AND SUBSTRING(@ReturnValue, 1, 2) <> '20') SET @DateTest = 'False'
IF (SUBSTRING(@ReturnValue, 3, 1) < '0' OR SUBSTRING(@ReturnValue, 3, 2) > '9') SET @DateTest = 'False'
IF (SUBSTRING(@ReturnValue, 4, 1) < '0' OR SUBSTRING(@ReturnValue, 4, 2) > '9') SET @DateTest = 'False'
IF (SUBSTRING(@ReturnValue, 6, 1) < '0' OR SUBSTRING(@ReturnValue, 6, 2) > '1') SET @DateTest = 'False'
IF (SUBSTRING(@ReturnValue, 7, 1) < '0' OR SUBSTRING(@ReturnValue, 7, 2) > '9') SET @DateTest = 'False'
IF (SUBSTRING(@ReturnValue, 9, 1) < '0' OR SUBSTRING(@ReturnValue, 9, 2) > '3') SET @DateTest = 'False'
IF (SUBSTRING(@ReturnValue, 10, 1) < '0' OR SUBSTRING(@ReturnValue, 10, 2) > '9') SET @DateTest = 'False'
IF (SUBSTRING(@ReturnValue, 5, 1) <> '-') SET @DateTest = 'False'
IF (SUBSTRING(@ReturnValue, 8, 1) <> '-') SET @DateTest = 'False'
IF @DateTest = 'False' SET @ReturnValue = '1800-01-01'
RETURN @ReturnValue
END
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
|
|
|
|
|
I had to answer to this one myself, this is too funny. My stored procedure was calling another function I wrote that had a similar name
It was a pleasure wasting everybody's time ! ;P
|
|
|
|
|
Hi,
I am using Enterprise Library April 2007, and wanted to know what DbType is a uniqueidentifier data type?? Like when I have for example:
db.AddInParameter(command, "@FirstName", DbType.String, info.FirstName); // Required
How would I do it for a uniqueidentifier data type?
Please can someone help me?
Regards
ma se
|
|
|
|
|
|
Hi,
You should use DbType.Guid
db.AddInParameter(command, "@FirstName", DbType.Guid, info.FirstName);
|
|
|
|
|
am writting a database application, i have an Error
<br />
SqlDataAdapter1.Fill(DsValRoll1)<br />
Am using Visual Studio 2003,and Sql 2000, after installing Visual Studio, i had a message that says, you must Download and install SQlDesktop Engine, i have lost the i need the Address where i can Download the SQlDesktop Engine for Visual Studio 2003 ans SQl 2000
Thanks
-- modified at 10:37 Monday 11th June, 2007
Vuyiswa
|
|
|
|
|
|
|
I have oracle DBF files and I would like to know if there is any way to export data from them?
I`m MSSQL user and I don`t know much about oracle .. I have just few DBF files and one ORA file and I don`t know how to export data from them.
Any help appreciated.
Thanks,
Ivan
|
|
|
|
|
Hi Ivan
You would need to install Oracle (you may be able to get away with the Express edition), then attach the DBF files. Once you have an Oracle database up-and-running then you can use DTS or SSIS to transfer the data to your SQL-Server instance.
If you have access to an Oracle DBA then you will save yourself a bunch of time.
Otherwise you may find that one of the Oracle-specific forums will be able to provide more detailed advice on attaching Oracle databases - just don't tell them that you intend to rip the data in SQL-Server cos that will seriously hurt their feelings
Regards
Andy
|
|
|
|
|
Andy thank you for instructions !
I have had same thinking as you ... so I have started downloading oracle 10g express and SQL developer. Any forums you would recommend ?
Thanks allot!
|
|
|
|
|