Dynamic Data Filtering (Dynamic Where Condition in SQL):
youtu.be/koQ3AOx6vcc?si=flIq… via @YouTube
#sqltrick #sqlquery #dynamicsql #sqltips #sqlinterviewquestionsandanswers #interviewquestionsandanswers #sqlinterview #sql #techpointfundamentals #techpointfunda #techpoint #sqlserver
Dynamic Data Sorting | Sorting data based on parameterized column name :
youtu.be/3lLq6nSILI0?si=AL7V… via @YouTube
#sqltrick #sqlquery #dynamicsql #sqlinterview #sql #techpointfundamentals #techpointfunda #techpoint #sqlserver #sqldatabase #sqldeveloper #mssqlserver
Returning data from Dynamic Linked-Server in SQL:
youtube.com/watch?v=_iX9Csei…
Please subscribe to the channel for more videos like this:
youtube.com/c/TechPointFunda…
#sqltrick #dynamicsql #sqltips #sqlinterview #sql #techpointfundamentals #techpointfunda #techpoint
Fetching data from Dynamic Source Database in SQL:
youtube.com/watch?v=96v1OB-y…
#sqltrick #sqlquery #dynamicsql #sqltips #sqlinterviewquestionsandanswers #interviewquestionsandanswers #sqlinterview #sql #techpointfundamentals #techpointfunda #techpoint #sqlserver #sqldatabase
New(ish) post. Added 2 new problems yesterday. If this feature doesn't work for ❝dbo❞ and ppl use ❝EXECUTE AS 'dbo'❞ to fix broken ownership chaining in #DynamicSQL then will this feature work outside of a demo? #SQLServer #SQLServer2019 #SQLInjection
sqlquantumleap.com/2019/08/0…
select 'alter '||decode(OBJECT_TYPE,'PACKAGE BODY','PACKAGE',OBJECT_TYPE)||' '||OWNER||'.'||OBJECT_NAME||' compile'||decode(OBJECT_TYPE,'PACKAGE BODY',' body','')||';' from dba_objects where status!='VALID'; #QuickAndDirty #dynamicSQL
Why good use of #QUOTENAME can easily prevent injection and unexpected behaviour in #DynamicSQL rd.gt/2KXjvVw
Anyone out there good at #SQL? I need help changing a passed value from being hardcoded to a parameter. I am willing to pay for this help if you can teach! #100DaysOfCode #DynamicSQL #SQLServer #Tutor
"#DynamicSQL vs Stored Procedure"
Dynamic SQL and stored procedures are two of the most important components of #SQLServer. In this article, we will look at the advantages and disadvantages of each of them and when to use them.
#SQL #Database #Databases
codingsight.com/dynamic-sql-…
New in #ACMLearning: "#DynamicSQL: Apps, Performance, Security" by @EdwardPollack bit.ly/1Tsnpph #sql
