SQLServerCentral.com Community Update for {date}

Problems displaying this newsletter? View online.

Featured Contents

SQL Server Unit Testing in Visual Studio

David Fundakowski from SQLServerCentral.com

Unit test stored procedures in Visual Studio using an existing database or new SQL scripts

SQL Server Best Practices for Data Quality

Additional Articles from MSSQLTips.com

Accurate data is imperative for an organization to conduct cost effective decision making. Like everything else, change is constant for your data. There is a need to cleanse and validate data when received and on a regular basis. Unfortunately, cleansing and validating data is difficult with the native SQL Server toolset. How do we leverage the SQL Server tool set to achieve these goals?

From the SQL Server Central Blogs - Checking SSIS Variable Values During Runtime

Tim Mitchell from Tim Mitchell

As anyone who reads my blog on a regular basis knows, I’m a big fan of using dynamic configurations, including SSIS parameters variables, to make my ETL architectures as...

From the SQL Server Central Blogs - SQLSaturday Orlando Notes – The Five Hats

Andy Warren from SQLAndy

I want to wrap up the notes on SQLSaturday by writing about my approach to managing events that I’ve evolved at SQLSaturday but definitely applies to most events and...

Question of the Day

Today's question (by Steve Jones - SSC Editor):
	Default Schemas
A developer is unsure of what schema a table will be created under if they execute this code: CREATE TABLE SalesDetail (SalesOrderID int not null, SalesNotes varchar(max) ); How can the developer check their default schema under T-SQL?
Think you know the answer? Click here, and find out if you are right.

Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Delaying the code

If I have this code, what is the amount of time that passes between two output times?

PRINT SYSDATETIME()
WAITFOR DELAY '00:02.5'
PRINT SYSDATETIME()

Answer: 2 minutes, 500 milliseconds

Explanation: This is essentially the same as the code:

PRINT SYSDATETIME()
WAITFOR DELAY '00:02:00.5'
PRINT SYSDATETIME()

Two minutes, and then half a second, or 500ms pass. Ref: Waitfor - https://docs.microsoft.com/en-us/sql/t-sql/language-elements/waitfor-transact-sql?view=sql-server-ver15

Discuss this question and answer on the forums

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2017 - Administration

+919878377317 Online Vashikaran Expert Astrologer Tantrik - `

Love Marriage and Vashikaran Specialist 9878377317 Love Spell Expert - `

+91-9878377317 Love Problem Solution Tantrik Baba Ji in Pathankot - `

+919878377317 Black magic / Vashikaran / Janamkundali specialist - `

Love Problem Solution tantrik By Vashikaran +919878377317 -

+91-9878377317 Husband Wife Problem Solution Specialist |Ahamdabad | -

Powerful Mantra 9878377317 Girl Vashikaran Mantra Specialist - `

+91-9878377317 Husband wife Problem solution Tantrik In Banglore (Karnataka) - `

9878377317 India's Best Love Problems solution Expert - `

9878377317 Marriage Or Relationship Or Love Problem Solution Tantrik - `

+919878377317 Love (Marriage) Vashikaran Specialist | Himachal pardesh - `

+91-9878377317 Divorce Problem Specialist Tantrik baba ji in Kuwait - `

+91-9878377317 Love Specialist Tantrik Ji | Lost love back? -

SQL Server 2016 - Development and T-SQL

Saving output as SQL file - If anyone is working today I have a problem I'm working on. I have a script which when run in SSMS, generates a SQL update script which is saved as an SQL file and run later. I am trying to automate this processes and generate a SQL file. Based on what I've found in google […]

Development - SQL Server 2014

Difference between where and INNER JOIN comparing a value - what is the difference between : Declare Phone varchar(50) UPDATE e Set e.[State]=2 FROM Events e INNER JOIN AccoutsAndPhones c on e.ClientID=c.ClientID And c.phone=@Phone WHERE e.Schedule>GETDATE() and Declare Phone varchar(50) UPDATE e Set e.[State]=2 FROM Events e INNER JOIN AccoutsAndPhones c on e.ClientID=c.ClientID WHERE e.Schedule>GETDATE() and c.phone=@Phone the c.phone=@Phone is in different places. is […]

This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.