sqlserver

Question

can any one explain with a realtime scenario what is dynamic sql and y we use ? where we use? Let me know please.............thanks in advance

Jignesh Trivedi · Answer

hi Please refer https://www.mssqltips.com/sqlservertip/1160/execute-dynamic-sql-commands-in-sql-server/ http://www.techrepublic.com/blog/the-enterprise-cloud/generate-dynamic-sql-statements-in-sql-server/

Munesh Sharma · Answer

http://searchoracle.techtarget.com/definition/dynamic-SQL

Upendra Pratap Shahi · Answer

Hello Go through below link- http://www.codeproject.com/Articles/20815/Building-Dynamic-SQL-In-a-Stored-Procedure http://www.benkotips.com/pages/DynamicSQL.aspx This helped you if read carefully.

jayachandra b · Answer

dont explain with theory........please........