+Ryan Blais Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful. Dot Net & SQL Server training videos for web developers ruclips.net/user/kudvenkatplaylists?view=1&sort=dd You can order DVDs for offline viewing using the link below www.pragimtech.com/Order.aspx Code Samples & Slides are on my blog csharp-video-tutorials.blogspot.com Tips to effectively use our channel ruclips.net/video/y780MwhY70s/видео.html To receive email alerts, when new videos are uploaded, please subscribe to our channel ruclips.net/user/kudvenkat Please click that THUMBS UP button below the video, if you like the videos Thanks a million for sharing these resources with your friends Best Venkat
I like when you ask - "Is it possible?" And In my mind even that I don't know it yet, I say Absolutely! :D Thank you for all your work it has great impact on improving my coding skills and probably milions of other people as well.. I plan to do all of your videos this year, it was my new year wish to put me back on right path.
Venkat - You are a genius - Watched almost all of your 68 part videos on SQL…Would have loved to see more videos on SQL Security, High Availability and Performance….Thanks a bunch…
I'm sure you've found the answer long ago, but for anyone wondering the same thing, the syntax to do that is: RETURNS NVARCHAR(100) WITH SCHEMABINDING, ENCRYPTION
Great tutorial and thanks a lot for posting. I had a question, what if i have to use both the encryption and schema binding on an table together? . When i commented out the 'With Encryption' keeping the 'with schemabinding' part active it worked. - this result i cannot delete the table but if i do the other way around, i lost the schemabinding capability but gained the encryption capability. In short- How do i do the Schema binding and Schema Enryption together
+Shubham Mittal //I'm sure you've found the answer by now, but for anyone wondering the same thing, the syntax to do that is: RETURNS NVARCHAR(100) WITH SCHEMABINDING, ENCRYPTION
correction : if we use two RAND function in same scope one passing no value and second passing one value Eg RAND() and RAND(1) both the RAND get Deterministic and if we use only one RAND() with no value , it will be Non Deterministic , this is because , it treat both the RAND() function with Same Value kudvenkat
To Create a Script to Recreate Database and Data (before deleting): In SSMS Object Explorer Pane: 1. Right click on your DATABASE then "Tasks" -> "Generate Scripts..." 2. At "Introduction" step, Click "Next". 3. At "Choose Objects" step, Chose "Select specific database objects". 4. Expand Tables and/or choose the objects you want to Script, then click "Next". 5. At "Set Scription Options" step, click the "Advanced" button. 6. Page down to "Type of data to script", and choose "Schema and data" (or as desired) 7. Click "OK". 8. Choose Save to File, Clipboard, or New Query Window, and click "Next". 9. At "Summary" step, click "Next". 10. Click "Finish". 11. Save to execute later as desired.
*Before you DROP your practice table and data, preserve it in a script...* ------------------------------------------------------------------------------------------------ To Create a Script to Recreate Database and Data: ------------------------------------------------------------------------------------------------ In SSMS Object Explorer Pane: 1. Right click on your DATABASE then "Tasks" -> "Generate Scripts..." 2. At "Introduction" step, Click "Next". 3. At "Choose Objects" step, Chose "Select specific database objects". 4. Expand Tables and/or choose the objects you want to Script, then click "Next". 5. At "Set Scription Options" step, click the "Advanced" button. 6. Page down to "Type of data to script", and choose "Schema and data" (or as desired) 7. Click "OK". 8. Choose Save to File, Clipboard, or New Query Window, and click "Next". 9. At "Summary" step, click "Next". 10. Click "Finish". 11. Save to execute later as desired. .
I didn't think I could learn SQL until I watched these tutorials. Is it possible? Absolutely.
+Ryan Blais Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful.
Dot Net & SQL Server training videos for web developers
ruclips.net/user/kudvenkatplaylists?view=1&sort=dd
You can order DVDs for offline viewing using the link below
www.pragimtech.com/Order.aspx
Code Samples & Slides are on my blog
csharp-video-tutorials.blogspot.com
Tips to effectively use our channel
ruclips.net/video/y780MwhY70s/видео.html
To receive email alerts, when new videos are uploaded, please subscribe to our channel
ruclips.net/user/kudvenkat
Please click that THUMBS UP button below the video, if you like the videos
Thanks a million for sharing these resources with your friends
Best
Venkat
is this man awesome? absolutely!
I like when you ask - "Is it possible?" And In my mind even that I don't know it yet, I say Absolutely! :D Thank you for all your work it has great impact on improving my coding skills and probably milions of other people as well.. I plan to do all of your videos this year, it was my new year wish to put me back on right path.
Venkat - You are a genius - Watched almost all of your 68 part videos on SQL…Would have loved to see more videos on SQL Security, High Availability and Performance….Thanks a bunch…
You are too good Venkat in presentation and explanation....All the concepts have been explained in simple terms but the best way !
Great videos about deterministic and non deterministic function
Most informative and interesting session Vekat Sir, Many Thanks..
This is Free of cost but worth it to watch
Another important use of schema binding in scalar function which not affects the table will give you faster execution..
Heavy looking concepts, explained so beautifully as if it is a child's play.
What a voice bro , thanks
Thank you Sir for these video's Really helpful...God bless u
I'm sure you've found the answer long ago, but for anyone wondering the same thing, the syntax to do that is:
RETURNS NVARCHAR(100)
WITH SCHEMABINDING, ENCRYPTION
It's a good video and concept is clear.
Question
Can we use
WITH ENCRYPTION
WITH SCHEMABINDING
or how to use both?
Thanks
Great tutorial and thanks a lot for posting.
I had a question, what if i have to use both the encryption and schema binding on an table together? . When i commented out the 'With Encryption' keeping the 'with schemabinding' part active it worked. - this result i cannot delete the table but if i do the other way around, i lost the schemabinding capability but gained the encryption capability. In short- How do i do the Schema binding and Schema Enryption together
please tell me..
Is it possible to use both
with encryption
with schemabinding
while creating a function?
+Shubham Mittal //I'm sure you've found the answer by now, but for anyone wondering the same thing, the syntax to do that is:
RETURNS NVARCHAR(100)
WITH SCHEMABINDING, ENCRYPTION
+Naveen Karthick thank you :) .. i hv changed the table name into two-part format and the Command(s) completed successfully.
correction :
if we use two RAND function in same scope
one passing no value and second passing one value
Eg RAND() and RAND(1)
both the RAND get Deterministic
and if we use only one RAND() with no value , it will be Non Deterministic ,
this is because , it treat both the RAND() function with Same Value
kudvenkat
Can we schemabind the storedProcedure or not?
Thanks Sir.
Can we use schema binding with other objects like stored procedure??
he is very good
Can we use Schemabinding for Stored Procedures as well?
these are very important points related to functions
I wish you would have had me create a script for tblEmployees before I dropped it. I was able to recreate it but it was not easy or fast.
To Create a Script to Recreate Database and Data (before deleting):
In SSMS Object Explorer Pane:
1. Right click on your DATABASE then "Tasks" -> "Generate Scripts..."
2. At "Introduction" step, Click "Next".
3. At "Choose Objects" step, Chose "Select specific database objects".
4. Expand Tables and/or choose the objects you want to Script, then click "Next".
5. At "Set Scription Options" step, click the "Advanced" button.
6. Page down to "Type of data to script", and choose "Schema and data" (or as desired)
7. Click "OK".
8. Choose Save to File, Clipboard, or New Query Window, and click "Next".
9. At "Summary" step, click "Next".
10. Click "Finish".
11. Save to execute later as desired.
Hello is so romantic😂😂😂
can we decrypt the function
what is seed value? I dont get it properly
I want to Encrypt the function and also Schemabinding
Tank u
ａｅｓｔｈｅｔｉｃ
*Before you DROP your practice table and data, preserve it in a script...*
------------------------------------------------------------------------------------------------
To Create a Script to Recreate Database and Data:
------------------------------------------------------------------------------------------------
In SSMS Object Explorer Pane:
1. Right click on your DATABASE then "Tasks" -> "Generate Scripts..."
2. At "Introduction" step, Click "Next".
3. At "Choose Objects" step, Chose "Select specific database objects".
4. Expand Tables and/or choose the objects you want to Script, then click "Next".
5. At "Set Scription Options" step, click the "Advanced" button.
6. Page down to "Type of data to script", and choose "Schema and data" (or as desired)
7. Click "OK".
8. Choose Save to File, Clipboard, or New Query Window, and click "Next".
9. At "Summary" step, click "Next".
10. Click "Finish".
11. Save to execute later as desired.
.