29 How to write dynamic query in stored procedure

[@kgranite6595]

Thank you! This is the most practical lesson. I really appreciate it!

[@learnssis]

You are most welcome k granite.

[@mokshanimma4787]

Hi sir, could you please make video on finding long running queries and optimising or tuning complex queries. These will be helpful while attending interviews. Thanks in advance.

[@learnssis]

Okay, I will try to make videos on these topics.

[@shivarajkumar6270]

Performance tuning techniques in sql server?

[@learnssis]

Yeah its a pending topic and will try to make a video on it, recently I made 2 videos on performance tuning of SSIS packages, I would recommend you to take a look on them as well
th-cam.com/video/3pacxWeTce4/w-d-xo.html
th-cam.com/video/7sKEgm2uQEM/w-d-xo.html

[@MovieTime-tg2mn]

Hi Bro,
Could you please Help How to write a stored procedure for creating multiple new table with columns by passing input parameter in dynamic SQL, Thanks in Advance

[@learnssis]

This is the stored procedure
CREATE PROCEDURE CreateSingleTable
@TableName NVARCHAR(100),
@Column1Name NVARCHAR(100),
@Column1Type NVARCHAR(100),
@Column2Name NVARCHAR(100),
@Column2Type NVARCHAR(100)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @SQL NVARCHAR(MAX)
SET @SQL = 'CREATE TABLE ' + @TableName + ' (' +
@Column1Name + ' ' + @Column1Type + ',' +
@Column2Name + ' ' + @Column2Type + ');'
EXEC sp_executesql @SQL
END;
---------------
And this is how you can call it
EXEC CreateSingleTable
@TableName = 'MyTable',
@Column1Name = 'ID',
@Column1Type = 'INT',
@Column2Name = 'Name',
@Column2Type = 'VARCHAR(50)';

[@MovieTime-tg2mn]

Thanks Bro@@learnssis

[@doddapanenisatish6475]

how to run. Sql file through stored procedure and replace name with output file. log

[@learnssis]

I got your first question "how to run sql file through stored procedure" but did not get the second one "and replace name with output file log"

[@Knowledgegreenone]

Nice can u give more example on dynamic query

[@learnssis]

Sure I can give more examples of it.

[@sonyguptaagrawal6028]

please teach from start ,how to write dynamic sql query

[@learnssis]

Thanks Sony Gupta for your suggestion, I am trying to make videos on all topics on SQL Server, will cover this topic in detail.

[@learner_SSIS]

Thank you Aqil sir 😀

[@learnssis]

You are most welcome Naveen.