Expect an Attack
Most companies in a recent survey expect to get hacked this year. Steve Jones wishes that the technological leaders would help everyone develop more secure code by publishing more information.
2009-06-24
153 reads
hackers
Expect an Attack
Most companies in a recent survey expect to get hacked this year. Steve Jones wishes that the technological leaders would help everyone develop more secure code by publishing more information.
2009-06-23
683 reads
Expect an Attack
Most companies in a recent survey expect to get hacked this year. Steve Jones wishes that the technological leaders would help everyone develop more secure code by publishing more information.
2009-06-23
734 reads
Expect an Attack
Most companies in a recent survey expect to get hacked this year. Steve Jones wishes that the technological leaders would help everyone develop more secure code by publishing more information.
2009-06-23
927 reads
Intruding into Dummy Websites
Phil Factor muses on security, bayonets, and databases, and somehow manages to pull it all together in this editorial.
2009-06-02
187 reads
RE: identity column
BEGIN TRAN DBCC CHECKIDENT('Table1',RESEED,1) DBCC CHECKIDENT('Table1',RESEED) COMMIT TRAN This will reset to the next non-duplicate value. The RESEED option will only reset the next-in-sequence upward, so set to 1, then let the RESEED do it's work. -Dan
2003-06-19
RE: Stored Procedure ?
You didn't copy my code quite right. You left out the quotes, which indicate that the @sql variable is a string: ... SET @sql = 'SELECT * FROM tblEmployee WHERE EmpID LIKE ''' + @EmpID + '''' EXEC sp_executesql @sql ... Without the quotes, it won't work.
2003-06-19
2003-06-19
RE: Stored Procedure ?
Hello jPipes Your suggestion worked, however, from access I still have to specify the exact EmpID I'm working with. Exec UpdateInfo @EmpId = '1234' I have tried the other suggestions, but still unable to substitute a variable for '1234' and make it work. Thank you all for your help. I am determined to figure this […]
2003-06-19
RE: Stored Procedure ?
quote: Set @EmpID = '1%' Select * from tblEmployee where EmpID = @EmpID This will return all Employee ID's that begin with a 1, but I'm only looking for the EmpID of the record I'm working with. Actually, you'll need to use the LIKE operator to make this work, and you will have to use […]
2003-06-19
Blogs
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...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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