Dynamic SQL

External Article

Execute Dynamic SQL commands in SQL Server

  • Article

In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. Because of this sometimes there is a need to dynamically create a SQL statement on the fly and then run that command. This can be done quite simply from the application perspective where the statement is built on the fly whether you are using ASP.NET, ColdFusion or any other programming language. But how do you do this from within a SQL Server stored procedure?

2016-05-03

5,701 reads

Blogs

Friday Flyway Tips–Comparison Options

By

Recently a customer asked how they could get index changes to be captured in...

A New Word: Guiltwrights

By

giltwrights  – n. the imaginary committee of elders that keeps a running log of...

Becoming Kristyna Ferris <3

By

Hey folks, fun personal post today. A few weeks ago, I got married! My...

Read the latest Blogs

Forums

Relationship between dimension and measures

By ElviraD

There is a Fact Table (.....,MenuID, MOption, CallTime) There is also a Dimension "Menu"...

Exam Ref DP-300 Administering Microsoft Azure SQL Solutions

By Site Owners

Comments posted to this topic are about the item Exam Ref DP-300 Administering Microsoft...

Love

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Love

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers