Category - SQL Server
Results 1 - 5 of 131
0 Comments   531 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass Table name as Parameter (Variable) to sp_executesql command in SQL Server.
The sp_executesql command supports accepting Table name as Parameter (Variable) in the following SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012, 2014 or higher.
Here Mudassar Ahmed Khan has explained with an example, how to use the SQL Server sp_executesql command and how to pass parameters to sp_executesql command in SQL Server.
Dynamic SQL Query can be executed with parameters using the sp_executesql command in SQL Server.
The sp_executesql command is supported in SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012, 2014 or higher.
Here Mudassar Ahmed Khan has explained with an example, how to write and execute dynamic SQL Query in SQL Server.
Dynamic SQL Query can be executed using EXEC and sp_executesql commands in SQL Server.
Execution of dynamic SQL is supported in SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012, 2014 or higher.
Here Mudassar Ahmed Khan has explained with an example, how to execute (run) Stored Procedure in SQL Server Management Studio.
The Stored Procedure can be easily called (executed) using the EXEC command in SQL Server Management Studio.
This method works for all versions for SQL Server Management Studio editions i.e. 2000, 2005, 2008, 2008R2, 2012, 2014 or higher including SQL Server Management Studio Express editions.
0 Comments   854 Views
Here Mudassar Ahmed Khan has explained with an example, how to insert (save) to SQL Server Table in C# and VB.Net using the SQL Server User Defined Table Type.
Results 1 - 5 of 131