|
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!
|
|
|
|
|
I've never used any Oracle forums - but if I did then Ask Tom[^] would be the first place I would look.
Good luck.
|
|
|
|
|
This is old, but I couldn't resist.
Instead of getting his technical input from forums or even from Tom Kyte, he should be doing what Tom himself would say--RTFM!
Kind regards,
Russ
|
|
|
|
|
Dear Team,
We face the issue of Process Blocking in SQL2000 very often which leads to the show stopper of the application for which we will have to kill the Process manually , is there any was to find why the Process blocking in SQL coz of the application or is there any other work around to fix this issue.
Thanks & Regards,
Jayaraman B
Jayaraman B
|
|
|
|
|
Do you mean that SQL sessions are blocking on other user's sessions because of locking?
This can be detected using the "sp_who2" stored procedure. The normal ways of reducing lock contention are:- Keep your transactions short.
- Check your "isolation level". Some frameworks use the "serializable" isolation - which severely impacts concurrency.
- For reports, consider using "read uncommitted" isolation.
- If your transactions access multiple tables then try to update tables in the same sequence.
Hope that helps. This artical[^] may help.
Regards
Andy
|
|
|
|
|
|
ma se wrote: AND tblProduct.Status = 1
should be changed to
WHERE tblProduct.Status = 1
SG
|
|
|
|
|
Hi
ma se wrote: AND tblProduct.Status = 1
Remove it and add it in where clause.
Harini
|
|
|
|
|