Regular columnist Robert Marda writes about the basics of using output parameters. If you're not using output params we hope this article will get you started - they are a great way to return less data to the client, perfect if you need only a few values and not a recordset/resultset.
2007-10-26 (first published: 2003-11-25)
32,186 reads
Robert is our expert on dynamic sql. This week he offers some good hints for planning the contruction of a proc that will use dynamic sql. He also adds some suggestions on how to format the code so that when you return to it later, you can figure out what you were doing!
2007-10-02 (first published: 2003-04-25)
49,839 reads
We're pleased to announce that Robert will be writing for us each month - generally on stored procedures, but occasionally on a different topic. This article discusses how nesting stored procedures works and how to use @@NextLevel. Good reading! If there is a stored procedure topic you'd like to see covered, add a comment to the article or email us at articles@sqlservercentral.com
2007-10-02 (first published: 2003-05-23)
46,301 reads
Working with date and time data in SQL Server can be a bit cumersome using just T-SQL. With the separate datatypes being pulled from SQL Server 2005 for the time being, however, it is something that a DBA needs to get used to. Robert Marda brings us an instructional look at the different datetime data types and some things you should be aware of when developing with them.
2004-10-27
16,721 reads
Creating a system stored procedure isn't hard. You're always cautioned from making changes to the system, depending on the system for a particular functionality, etc., and you should be cautious. However adding system stored procedures to your servers can be beneficial and make your administration much more convenient. Read on the see how easy this can be to do.
2004-05-20
13,124 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,362 reads
In this article by Robert Marda, he shows you how to setup a simple auditing system through triggers.
2004-01-16
16,651 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,174 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
16,546 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,810 reads
By Steve Jones
I’ve written a lot of coping tips now. Over two years worth (Mon-Fri) since...
By DesertDBA
In case you don’t follow me on LinkedIn or Twitter, your humble host joined...
By James Serra
With Power BI continuing to get many great new features, including the latest in...
Hi, could someone answer the following questions please? I've googled of course but I'm...
OK so I have a customer with a hosted website with eCommerce options. Essentially...
Hi, I wonder what your opinion about Google Cloud SQL is! We are a...
Ask SSC