 |
|
|
Functions
Latest Tip
SQL Server DateDiff Example
At the moment I have a project where I have to retrieve SQL Server data based on the difference between two dates. I read the tip on the DATEADD function and wanted to know about other functions available for date/time manipulation. Can you point me in the right direction? Check out this tip to learn more about the SQL Server DateAdd function.
T-SQL
Latest Tip
SQL Server stored procedure to generate random passwords
SQL Server is used to support many applications and one such feature of most applications is the storage of passwords. Sometimes there is a need to reset a password using a temporary password or generate a random password for a new user. In this tip I cover a simple stored procedure to generate random passwords that can be incorporated into your applications.
JOIN Tables
Latest Tip
SQL Server Join Example
I am new to SQL Server and want to learn about the JOIN options. What are all of the JOIN options in SQL Server? What is the significance of each of the options? I am a little confused on the differences and syntax, can you provide some examples and explanations? Are JOINs only for SELECT statements? Check out this tip to learn about SQL Server Joins.
Scripts
Latest Tip
Script to Find and Drop All Orphaned Users in All SQL Server Databases
In this tip we look at a script that identifies all orphaned users for all databases on a SQL Server instance. The script can both identify and drop the orphaned users.
Common Language Runtime CLR
Latest Tip
Introduction to SQL Server CLR table valued functions
Table Value Functions (TVF) are great if you need to return multiple rows and/or multiple columns, because table valued user defined functions return their result as a table. Since result set acts like a table, you can just return the data or you can join the results to other tables. TVFs can be created using TSQL or the Common Language Runtime (CLR) and in this tip we walk through a simple examp
|
|
privacy | disclaimer | copyright | advertise | about authors | contribute | feedback | giveaways | user groups Some names and products listed are the registered trademarks of their respective owners. Edgewood Solutions LLC | MSSharePointTips.com | MSSQLTips.com |