Windows 10: SQL How to empty all tables in a database

You might need to purge all the data in all the tables in a particular database. For this we can use the following script.

USE <database name>
DECLARE @TableName AS VARCHAR(MAX)
DECLARE table_cursor CURSOR
FOR
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND TABLE_NAME LIKE '%_Partition%'
OPEN table_cursor
FETCH NEXT FROM table_cursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE @SQLText AS NVARCHAR(4000)
SET @SQLText = 'TRUNCATE TABLE ' + @TableName
EXEC sp_executeSQL @SQLText
FETCH NEXT FROM table_cursor INTO @TableName
END
CLOSE table_cursor
DEALLOCATE table_cursor

(0)

read more...

 

SQL Express 2016 - Adventureworks Database

What is the best Adventureworks Database to install on SQL Server Express 2016? I see there are several different 2016 AW databases. I am a beginner - just installed SQL Express on my computer. I need
to use Adventureworks to learn to build tables and write T-SQL queries

 

Always Encrypted now generally available in Azure SQL Database

Source: Always Encrypted now generally available in Azure SQL Database | Blog | Microsoft Azure

 

Visual Basic, Can't open SQL ADODB database

I have Windows10 and Visual Studio 2015 free version. I am having an SQL problem. I have created an SQL database

with tables with server 2016 but am unable to get VB to open an ADODB database using any connection string.

The server name is MSSQLLocalDB and the database is connected . The same database is working with visual basic 2008 and sql server 2005 Express. I'm thinking that I need the Express version of any other server instead of the LocalDB version.

I mostly get this message: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.