http://www.sqlservercentral.com/Content tagged Stored Procedures, Programming posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)The third article in a four part series, this week Andy shows how to use the command object to work with stored procedure parameters. http://www.sqlservercentral.com/articles/Stored+Procedures/introductiontoadothecommandobject/535/2007/02/09http://www.sqlservercentral.com/articles/Stored+Procedures/introductiontoadothecommandobject/535/SQL Server does a great job of handling concurrency & ensuring that users can make changes in multi-user systems without conflict. However there are times a strict calling order is needed. http://www.sqlservercentral.com/articles/Miscellaneous/2649/2006/10/17http://www.sqlservercentral.com/articles/Miscellaneous/2649/Part 1 of a 4 part series about ADO, this is a beginner level article designed to get you started using the ADO connection object. If you haven't used ADO so far, why not see what it's all about? http://www.sqlservercentral.com/articles/Miscellaneous/introductiontotheadoconnectionobject/510/2006/05/26http://www.sqlservercentral.com/articles/Miscellaneous/introductiontotheadoconnectionobject/510/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! http://www.sqlservercentral.com/articles/Miscellaneous/howtobuilddynamicstoredprocedures/968/2005/12/16http://www.sqlservercentral.com/articles/Miscellaneous/howtobuilddynamicstoredprocedures/968/Do you know the difference between a login and a user? What's the best way to add them; Enterprise Manager, T-SQL, or SQL-DMO? In this beginner level article Andy demonstrates how to use all three methods to add logins and users and offers his view of which is the best technique. http://www.sqlservercentral.com/articles/Administering/loginsusersandrolesgettingstarted/514/2005/09/30http://www.sqlservercentral.com/articles/Administering/loginsusersandrolesgettingstarted/514/We've had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can't. http://www.sqlservercentral.com/articles/Performance+Tuning/dynamicsqlorstoredprocedure/969/2005/08/26http://www.sqlservercentral.com/articles/Performance+Tuning/dynamicsqlorstoredprocedure/969/Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary! http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/2005/02/04http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/This article shows you how to identify SQL Server performance problems and explains how the SERIALIZABLE transaction isolation level effected the performance of an OLTP application.http://www.sqlservercentral.com/redirect/articles/931/2003/05/22http://www.sqlservercentral.com/redirect/articles/931/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. http://www.sqlservercentral.com/articles/Miscellaneous/handlingthetextdatatype/985/2003/05/07http://www.sqlservercentral.com/articles/Miscellaneous/handlingthetextdatatype/985/This article by Simon Galbraith (from Red Gate software, maker of SQL Compare) discusses migrating changes from development to staging, QA, and on to production. If you've never seen the need for a schema compare tool (Steve Jones!), this is worth reading.http://www.sqlservercentral.com/redirect/articles/982/2003/05/06http://www.sqlservercentral.com/redirect/articles/982/Ryan demonstrates how he arrived at a solution that allows you to create scripts from a stored procedure using SQL-DMO. If you get interested in DMO, we've got quite a bit of additional content here on the site to help you get going! Ryan is a new author here on the site, please take a minute to read his article, add a comment, maybe just say hello. http://www.sqlservercentral.com/articles/Miscellaneous/creatingascriptfromastoredprocedure/973/2003/05/02http://www.sqlservercentral.com/articles/Miscellaneous/creatingascriptfromastoredprocedure/973/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! http://www.sqlservercentral.com/articles/Miscellaneous/howtobuilddynamicstoredprocedures/968/2005/12/16http://www.sqlservercentral.com/articles/Miscellaneous/howtobuilddynamicstoredprocedures/968/We've had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can't. http://www.sqlservercentral.com/articles/Performance+Tuning/dynamicsqlorstoredprocedure/969/2005/08/26http://www.sqlservercentral.com/articles/Performance+Tuning/dynamicsqlorstoredprocedure/969/Do you know the difference between a login and a user? What's the best way to add them; Enterprise Manager, T-SQL, or SQL-DMO? In this beginner level article Andy demonstrates how to use all three methods to add logins and users and offers his view of which is the best technique. http://www.sqlservercentral.com/articles/Administering/loginsusersandrolesgettingstarted/514/2005/09/30http://www.sqlservercentral.com/articles/Administering/loginsusersandrolesgettingstarted/514/This one is pretty interesting, Andy discusses a few things he sees in comments that not only fail to add value, they end up costing extra time. There's room for discussion here, but definitely a discussion worth having - comments can make you or break you, here's a chance to think about what you think is important in commenting and pass that on to your development team. http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticebadcomments/893/2003/01/23http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticebadcomments/893/Are you using default values for your parameters? Using named parameters when you call the proc or passing the values by ordinal? Should you be? Andy thinks 6 out of 10 of our readers will agree with his point of view, we'll be a little more conservative and guess that 5 of out 10 will be closer. http://www.sqlservercentral.com/articles/Miscellaneous/defaultvaluesandnamedparametersforstoredprocs/882/2003/01/08http://www.sqlservercentral.com/articles/Miscellaneous/defaultvaluesandnamedparametersforstoredprocs/882/Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary! http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/2005/02/04http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/The third article in a four part series, this week Andy shows how to use the command object to work with stored procedure parameters. http://www.sqlservercentral.com/articles/Stored+Procedures/introductiontoadothecommandobject/535/2007/02/09http://www.sqlservercentral.com/articles/Stored+Procedures/introductiontoadothecommandobject/535/In three previous articles Andy has done a very basic introduction to the ADO connection, command, and recordset objects. In this wrap up article he talks about how to use the power of ADO client side filtering and disconnected recordsets, then adds some code which shows how to combine all the objects. ADO is not simple, but Andy has done a good job in limiting his dicussion to the things you REALLY need to know about ADO to get started. http://www.sqlservercentral.com/articles/Performance+Tuning/introductiontoadopart4combiningitall/537/2001/12/07http://www.sqlservercentral.com/articles/Performance+Tuning/introductiontoadopart4combiningitall/537/Part 1 of a 4 part series about ADO, this is a beginner level article designed to get you started using the ADO connection object. If you haven't used ADO so far, why not see what it's all about? http://www.sqlservercentral.com/articles/Miscellaneous/introductiontotheadoconnectionobject/510/2006/05/26http://www.sqlservercentral.com/articles/Miscellaneous/introductiontotheadoconnectionobject/510/My ASP file doesn’t access my database." "I can’t connect to my database from my code." "I’m having problems calling and debugging stored procedures." These are some of the problems I hear every day as a Microsoft® developer support engineer. http://www.sqlservercentral.com/redirect/articles/249/2001/07/20http://www.sqlservercentral.com/redirect/articles/249/If you’re running database-intensive code from Visual Basic or ASP, stored procedures can give you a great speed boost. With ADO 2.1, one of the components that makes up MDAC, this technique is easier to implement than ever. http://www.sqlservercentral.com/redirect/articles/248/2001/06/29http://www.sqlservercentral.com/redirect/articles/248/This article by David Rabb from the June 2001 issue of VBPJ shows you how to build a tool that will build a select, insert, update, and delete stored procedure for each table in a database. It's a great example of how to use DMO and a great tool as well! http://www.sqlservercentral.com/redirect/articles/256/2001/06/25http://www.sqlservercentral.com/redirect/articles/256/Ever have a large batch of scripts you need to run? It takes a while if you have to open each one in Query Analyzer and execute it. One of our readers proposed an alternative - take a look the small app Andy Warren wrote to make doing this task a breeze. http://www.sqlservercentral.com/articles/Administering/scriptrunner/292/2001/06/14http://www.sqlservercentral.com/articles/Administering/scriptrunner/292/