Lynda com SQL Server Triggers Stored Procedures and Functions | 23A105F6A8C5582A1C3469A0F30A7613CC5A67F7

Lynda com SQL Server Triggers Stored Procedures and Functions

Name	Lynda.com - SQL Server Triggers, Stored Procedures, and Functions	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	716.7 MB
Total Files	119
Hash	23A105F6A8C5582A1C3469A0F30A7613CC5A67F7

/06. Putting It All Together/
1. Exploring a Real-World INSERT Procedure.mp4	39.4 MB
3. Implementing Logging On Delete.mp4	30.4 MB
2. Exploring a Real-World UPDATE Procedure.mp4	20.4 MB
/07. Using CLR Assemblies/
3. Writing Stored Procedures with C# .NET.mp4	38.7 MB
5. Choosing Between T-SQL vs. CLR.mp4	32.0 MB
2. Using CLR with SQL Server 2012.mp4	25.1 MB
1. Understanding the Common Language Runtime (CLR) and the .NET Framework.mp4	6.9 MB
4. Writing Functions with .NET.mp4	5.6 MB
/03. Stored Procedures/
5. Using Input and Output Parameters.mp4	35.5 MB
6. Using Security and Permissions.mp4	35.1 MB
3. Returning Data Using Data Sets.mp4	27.7 MB
4. Returning Data Using Cursors.mp4	26.5 MB
7. Using Transactions.mp4	20.0 MB
2. Modifying A Stored Procedure.mp4	17.4 MB
1. Creating A Stored Procedure.mp4	14.5 MB
/04. User-Defined Functions/
2. Exploring Single-Value Functions.mp4	32.1 MB
1. Creating A User-Defined Function.mp4	30.2 MB
3. Exploring Table Value Functions.mp4	18.9 MB
/08. Exploring an ASP .NET Web Application/
3. Passing Parameters.mp4	30.5 MB
4. Getting Return Values.mp4	20.7 MB
1. Creating a Basic Web Form and Connecting to a Database.mp4	18.8 MB
2. Executing a Stored Procedure.mp4	17.2 MB
/02. Installing SQL Server/
1. Configuring Your Environment.mp4	29.0 MB
2. Downloading and Installing A Sample Database.mp4	9.7 MB
/05. Triggers/
1. Using _After_ Triggers.mp4	24.8 MB
2. Using _Instead Of_ Triggers.mp4	13.7 MB
4. Using Database-Level Triggers.mp4	12.5 MB
3. Using Nested Triggers.mp4	9.7 MB
/09. Conclusion/
1. Next Steps.mp4	20.2 MB
/01. Getting Started/
1. Comparing Triggers, Functions, and Procedures.mp4	16.4 MB
2. Why Use A Stored Procedure.mp4	13.3 MB
3. Why Use Functions.mp4	3.4 MB
4. Why Use Triggers.mp4	2.5 MB
/00. Introduction/
1. Welcome.mp4	10.0 MB
2. What You Should Know.mp4	2.3 MB
3. Using The Exercise Files.mp4	2.1 MB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch06/
Students.csv	2.9 MB
06_01_setup.txt	1.5 KB
06_02_setup.txt	1.1 KB
06_03_setup.txt	0.7 KB
06_03_function.txt	0.2 KB
06_01_query.txt	0.2 KB
06_03_table.txt	0.2 KB
06_02_query.txt	0.1 KB
06_03_query.txt	0.0 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/
CLRtest.suo	15.9 KB
CLRtest.sln	0.9 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/bin/Release/
helloworld.pdb	13.8 KB
helloworld.dll	4.6 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/obj/Release/
helloworld.pdb	13.8 KB
DesignTimeResolveAssemblyReferencesInput.cache	5.8 KB
helloworld.dll	4.6 KB
helloworld.csproj.FileListAbsolute.txt	0.8 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/
helloworld.suo	13.3 KB
helloworld.sln	0.9 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/bin/Release/
CLRtest.pdb	11.8 KB
CLRtest.dll	4.6 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/bin/Debug/
CLRtest.pdb	11.8 KB
CLRtest.dll	5.1 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/obj/Debug/
helloworld.pdb	11.8 KB
DesignTimeResolveAssemblyReferencesInput.cache	5.6 KB
helloworld.dll	5.1 KB
helloworld.csproj.FileListAbsolute.txt	0.3 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_04/CLRFunctions/CLRfunctions/CLRfunctions/bin/Release/
CLRfunctions.pdb	11.8 KB
CLRfunctions.dll	4.6 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_04/CLRFunctions/CLRfunctions/CLRfunctions/obj/Release/
CLRfunctions.pdb	11.8 KB
DesignTimeResolveAssemblyReferencesInput.cache	5.8 KB
CLRfunctions.dll	4.6 KB
CLRfunctions.csproj.FileListAbsolute.txt	0.5 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/bin/Debug/
helloworld.pdb	11.8 KB
helloworld.dll	5.1 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/obj/Debug/
CLRtest.pdb	11.8 KB
DesignTimeResolveAssemblyReferencesInput.cache	5.7 KB
CLRtest.dll	5.1 KB
CLRtest.csproj.FileListAbsolute.txt	0.5 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/obj/Release/
CLRtest.pdb	11.8 KB
DesignTimeResolveAssemblyReferencesInput.cache	5.7 KB
CLRtest.dll	4.6 KB
CLRtest.csproj.FileListAbsolute.txt	0.5 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_04/CLRFunctions/CLRfunctions/
CLRfunctions.suo	9.2 KB
CLRfunctions.sln	0.9 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_04/CLRFunctions/CLRfunctions/CLRfunctions/obj/Debug/
DesignTimeResolveAssemblyReferencesInput.cache	5.7 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch02/
02_create_database.txt	2.6 KB
02_create_table.txt	0.7 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/
helloworld.csproj	2.4 KB
q.cs	0.7 KB
HelloWorldProc.cs	0.3 KB
helloworld.csproj.user	0.1 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/
CLRtest.csproj	2.3 KB
mySprocs.cs	1.0 KB
Class1.cs	0.2 KB
CLRtest.csproj.user	0.1 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_04/CLRFunctions/CLRfunctions/CLRfunctions/
CLRfunctions.csproj	2.3 KB
Class1.cs	0.5 KB
CLRfunctions.csproj.user	0.1 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch05/
05_setup.txt	1.5 KB
05_01.txt	0.3 KB
05_02.txt	0.2 KB
05_04.txt	0.2 KB
05_03.txt	0.1 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_04/CLRFunctions/CLRfunctions/CLRfunctions/Properties/
AssemblyInfo.cs	1.5 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/Properties/
AssemblyInfo.cs	1.5 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/Properties/
AssemblyInfo.cs	1.4 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch08/
08_03.txt	1.4 KB
08_01.txt	1.1 KB
08_04.txt	0.4 KB
08_02.txt	0.1 KB
/
README.nfo	1.3 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch04/
04_02.txt	1.3 KB
04_03.txt	0.5 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_04/
class.txt	0.5 KB
function.txt	0.1 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch03/
03_07.txt	0.4 KB
03_04.txt	0.4 KB
03_06a.txt	0.2 KB
03_06b.txt	0.1 KB
03_05.txt	0.1 KB
03_03.txt	0.1 KB
/.../Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/
snippet.txt	0.4 KB
Total files 119