Forum Replies Created
Viewing 15 posts - 721 through 735 (of 824 total)
-
RE: Convert varchar(50) to money or decimal
That won't work because instead of -2345.00 it should be -23.45 at least according to what the OP said. Of course, having just said that I realize that as long...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Audit Trail in SProc
That's a good point, I was basically assuming that all the other restriction clauses used in generating the SP's result set would be included in the INSERT, but I didn't...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Is it possible to send the log file to a NUL device?
Since you are doing DELETEs the Bulk-logged model will not help. The only operations that benefit from that recovery model are BCP and BULK INSERTs.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Is it possible to send the log file to a NUL device?
Setting the recovery mode to Simple will have no effect on performance since the DELETEs are still fully logged.
No, you can't place the log file on a NULL device SQL...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Moving DTS packages from box to box
The simplest method of moving DTS packages from one server to another is to open the package in designer and under the "Package" menu select "Save As" you will be able...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: DO NOT USE PROCS FOR DATA ACCESS?
I have to say that after reading some of the comments posted at those weblogs I feel dummer for having read them
Those.../*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Convert varchar(50) to money or decimal
Well it's ugly but it works assuming that the right two digits are always supposed to represent cents.
declare @vchar varchar(10),
@Dollars varchar(10),
@Cents varchar(10),
@Amt varchar(11),
@Money money
set @vchar = '-0001234'
set @dollars = (left(@vchar,...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: consitens problem with bakcup
Is your new instance running at the same release level (SP and Hotfixes) as the original?
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Profiler and security
For SQL Server 2000 you must be sysadmin to run Profiler. There are several reasons for this, Profiler can show a great deal of information about the data and the...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: How to export structure of view
I usually use Query Analyzer's Object Browser, find the view (or any other object) right click on it and select one of the scripting options available there. You can also...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Audit Trail in SProc
It doesn't make much sense to me, but I'm not familiar with your system and its requirements... Based on what you told me I would just throw in a simple...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Audit Trail in SProc
Actually that might make it real simple. But before I can tell I need to ask a few more questions:
Do you want the audit records to be written only when...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Audit Trail in SProc
Do you want to write the record only if a record CC_Type = 50 appears in the result of the stored procedure or do you want the record written if...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Is it possible to have a SQL Server Trigger that calls a Stored Proc in Oracle?
Sure you can. You need to have the appropriate Oracle ODBC driver installed on your server, configure your Linked Server and make sure that RPC is checked on the Server...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Not Going to use IDENTITY columns!!!
...just to expand on rockmoose's comment. IDENTITY columns in and of themselves are not meant to ensure uniquness, but by not reseeding the value and using a unique constraint (or...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
Viewing 15 posts - 721 through 735 (of 824 total)