---
title: "Discussion on \"#DynamicSQL: Create customized SQL queries from a query\" | Hashnode"
description: "Discussion on \"#DynamicSQL: Create customized SQL queries from a query\". /* using Dynamic SQL – generate multiple customized Select query using dynamic sql */\n\nselect ‘select top 2 * from ‘ + table_name from information_schema.tables\nwhere table_type = ‘base table’\norder by TABLE_NAME ASC\n\n/* using Dynamic SQL – generate ..."
url: "https://hashnode.com/posts/dynamicsql-create-customized-sql-queries-from-a-query/682c278cd4fcb7752bc861ca"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [#DynamicSQL: Create customized SQL queries from a query](https://sqlstation.hashnode.dev/dynamicsql-create-customized-sql-queries-from-a-query?utm_source=hashnode&utm_medium=feed)

/\* using Dynamic SQL – generate multiple customized Select query using dynamic sql \*/ select ‘select top 2 \* from ‘ + table\_name from information\_schema.tables where table\_type = ‘base table’ order by TABLE\_NAME ASC /\* using Dynamic SQL – generate ...

May 20, 2025 · 1 min read · sqlstation.hashnode.dev  
Read the article

-   [#dynamicsql](https://hashnode.com/tag/dynamicsql)

## Written by

[Pradeep Prakash](https://hashnode.com/@ipradeepprakash)

@ipradeepprakash

  
[View profile](https://hashnode.com/@ipradeepprakash)

DBA - SQL Server

SQL Server DBA | Powershell |TSQL | Azure

## Responses

Markdown supported · ⌘↵ to post

No responses yet.