Declare @evalue varchar(?) SELECT @evalue = master..xp_repl_encrypt @number1 output INSERT tblpassword (column name 1, column 2) values ('IT', @evalue) **** I know it is optional, but I always list the columns to be inserted. This should work.
2005-02-21
Unless you have a few 100s of millions of rows you don't need to do that. If your queries need to run faster I suggest moving the first part of the clustered index to year (date) + month (date) + current key. This will give you even better results than what you are trying to […]
2005-01-24
hmmm. It seems we have made the original question a little broader by introducing the related issues of reliability and atomicity. Dare I suggest we might consider a transaction wrapping the actual insert/update statements? If we introduce transactions then I suspect the overhead of begin/commit/rollback may well make the original question moot.Next question: how is "update […]
2005-01-24
Just in case anyone still cares about this problem, it turned out to be a conflict with the SCSI cards and the scanners (believe it or not). Once a certain volume of data had passed through the SCSI card it just seemed to close itself down until the PC was reset...We had the latest SCSI […]
2005-01-04
I have a related issue that hopefully I can get some help with. On a sql 7 server my query uses a clustered index seek and the same database on sql 2K uses a clustered index scan. The query is listed below. procperiod is part of the index. I've tried updating statistics and recreating the clustered […]
2004-12-15
This may be a better solution since you only want to convert those records that aren't already UPPER case. I am assuming the first character may be UPPER case, but the second character is not... WHERE ASCII( SUBSTRING( LONG_PROJECT_TITLE, 2, 1)) <> ASCII( SUBSTRING( UPPER( LONG_PROJECT_TITLE), 2, 1)) (Sorry, I should have checked this more […]
2004-12-13
If you're writing a Web App, Paul's ASP.NET solution looks good; I reformatted it for readability:Function OutputDocumentImage '' Clear out the existing HTTP header information Response.Expires = 0 Response.Buffer = TRUE Response.Clear SQLString = "SELECT WordDocument FROM Translations WHERE TranslationID = " & TransID RS.Open SQLString, DB, 3 IF […]
2004-12-07
JR,I've already tried what you suggested by saving and replacing the "SQL Server Enterprise Manager" file in MMC folder. In my new profile it still opens my new console content where I recently registered just two servers.Thanks
2004-11-30
2004-11-28
1 reads
Thanks for your quick responses. Yes, the regular log backups truncate the log, but don't shrink its size on disk. Our database has a data file of about 11 gigabytes with the log at 8 gigabytes in spite of the regular log backups. When I took the steps mentioned, the log file went from 8GB to […]
2004-11-05
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers