RE: INSERT INTO & LOGGING
no Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/ www.dkranch.net
2003-11-25
2 reads
Views
RE: Connecting to VPN Client
We have to use a VPN to connect to a remote system to download data, then upload it to a local server. The VPN client software closes all other ports while connected, so none of the local servers can be seen (except for the database on the VPN client computer). The client software also requires […]
2003-11-17
1 reads
2003-07-31
RE: QOD Cheats
"people will lose interest if they feel that other people are 'cheating'" Quite a silly statement. Should be: "people will lose interest if they feel that the questions are bogus and a waste of their time." This is not the case with QOD. Keep up the good work!
2003-07-25
RE: cannot Generate SSPI context
hi, try http://support.microsoft.com/default.aspx?scid=kb;en-us;811889 as a starting point Paul
2003-07-23
RE: Check contraint
This will work a little better: USE TEMPDB BEGIN TRAN GO CREATE TABLE MY_TABLE( THE_VALUE_A CHAR(1), THE_VALUE_B CHAR(1), CONSTRAINT CHK_A_AND_B CHECK (NOT(THE_VALUE_A IS NOT NULL AND THE_VALUE_B IS NULL))) GO /* insert ok */ INSERT INTO MY_TABLE VALUES('A','B'); GO /* insert not ok */ INSERT INTO MY_TABLE VALUES('A',NULL); GO /* insert ok */ INSERT INTO […]
2003-07-08
RE: need help -Stored Procedure -Incorrect syntax
no it only update one record not all !!! i the table [xsisi] i have 100 records and like this it update only one not the all 100 "FROM [xsisi]" ------------- declare @na varchar(500), @sisi int, @mmh char(10) set @sisi='1' set @mmh='uuu' select @na = [na] FROM [xsisi] UPDATE Sn SET [sisi] = @sisi, [mmh] […]
2003-07-03
RE: PetCo.com Vulnerable to SQL Injection
Hi all Funny enough we had a panic session with our apps re sql injection attacks along with cross scripting problems. Generally speaking here, its the tardyness of developers thats the issue. I come from an old school developer background where our C development lecturer (ex-military) would knock off assignment marks quicker that a rabbit […]
2003-07-01
1 reads
RE: Unspecified error from OLE DB Provider in DTS
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-30
RE: Copy Jobs between servers
If there's a lot of jobs to be scripted, right-click on JOBS in the EM tree and then 'All Tasks' then Generate SQL Scripts. You can manually edit out unwanted jobs from the script before executing it. Note: I also uncheck "Replace job if it exists" in most cases. This saves my hide if I […]
2003-06-24
1 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers