download the application please visit www.mrbool.com/player
Title: SQL Server-SQL Command Mode and Table Valued Parameters
Duration: 15 minutes
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
of the development of example: Good coding standard and
simplified design to illustrate the key points.
Used: SQL Server 2008
select, readonly, table, top, SQl Cmd, !!dir.