2004-02-24
3,025 reads
2004-02-24
3,025 reads
In this article by Robert Marda, he shows you how to use derived tables to solve some of SQL's problems.
2004-02-06
17,701 reads
In this article by Robert Marda, he shows you how to setup a simple auditing system through triggers.
2004-01-16
16,677 reads
Regular columnist Robert Marda had some extra time so we got him to take a look at the latest upgrade to SQL Compare - for those of you aren't familiar with it, it is a tool that will let you compare two databases to see the differences, then optionally sync one to the other.
2004-01-15
10,176 reads
Regular columnist Robert Marda discusses a few ideas on stored procedure documentation. How much documentation do you need and is "documentation" different than code comments?
2003-10-20
18,426 reads
This month Robert covers the process he uses for developing stored procedures. In many ways it reflects how software is developed, but it does have it's minor differences. This is a high level process discussion, not a line by line example of the entire process - by design of course.
2003-09-03
10,979 reads
Return values from stored procedures (not output params, true return values) probably aren't used as often as they should be. Robert gives you some good examples of how to use them.
2003-08-05
9,870 reads
Should your stored procedure continue when it hits an error? Or keep executing? What errors will cause a stored procedure to quit executing auotmatically? Regular columnist Robert Marda has at least some of the answers, we think you'll find this interesting.
2003-06-26
7,365 reads
Robert is back this week with a look at the text data type. Not the easiest thing to work with, but sometimes a varchar just doesn't give you the range you need.
2003-05-07
27,297 reads
Can you block a DBA from performing certain actions on a server if he has sysadmin rights? The real answer is no, but this article shows you how to block an unknowledgable DBA from performing certain actions.
2003-01-28
6,863 reads
I need to migrate from a single server to a flex server. Instead of...
By Steve Jones
An interesting AI experiment here with Copilot from GitHub in handling some code I...
SQL is essential for modern businesses and applications that rely on data. It's a...
Comments posted to this topic are about the item The Vast Expansions of Hardware
Comments posted to this topic are about the item Code Blocks
Hi we built a gateway from sql server to netsuite using an oracle competitor's...
What happens with this code:
DECLARE @Iteration INT = 0; WHILE @Iteration < 10 SELECT CustomerName, CustomerStatus FROM dbo.Customer WHERE CustomerID > 3; SET @Iteration += 1;See possible answers