Title: SQL Server-SQL Command Mode and Table Valued Parameters
Duration: 15 minutes
Summary: In this video, we continue our discussion of SQL Server concepts. The main concepts we are discussing here are: SQL Command Mode, and Table Valued Parameters. We start with SQL Command Mode. We see how we can turn that option on from the Query menu. We also see how we can embed commands within our SQL statements. In this case we inserted the command !!dir within two select statements. Then we discuss table-valued parameters. We see how we can create a new type as a table, then we create a stored procedure and pass the new type as a parameter into the stored procedure. This parameter has to be passed as a readonly parameter.
Methodology of the development of example: Good coding standard and simplified design to illustrate the key points.
Technology Used: SQL Server 2008
Keywords: select, readonly, table, top, SQl Cmd, !!dir.