<div>
Why not have something like...<br />
<br />

<pre><code id="code-20-42075827-1">select 'Alter database ' + DB_NAME(database_id)
from  sys.dm_database_encryption_keys 
where 1 = 1
  and Encryption_state = 2 
  and complete_percentage = 0</code></pre>
</div>


Why not have something like...



select 'Alter database ' + DB_NAME(database_id)
from  sys.dm_database_encryption_keys 
where 1 = 1
  and Encryption_state = 2 
  and complete_percentage = 0

<div>
Please let us know your ultimate requirement. That way if possible and appropriate a better solution can be provided.
</div>


Please let us know your ultimate requirement. That way if possible and appropriate a better solution can be provided.

<div>
<div class="content wysiwyg-content">
I have a SP in which i need to add one condition to check multiple databases by using sys.dm_database_encryption<wbr />_keys table. <br />
<br />
when encryption_state is 2 and percentage_completed is 0 in the results it should print. Below is my query<br />
<br />
<br />
<br />
DECLARE @Test varchar(10)<br />
SELECT @Test = Database_ID from <br />
                             sys.dm_database_encryptio<wbr />n_keys  <br />
WHERE Encryption_state = 2 and complete_percentage = 0<br />
If (@test not NULL)<br />
Begin<br />
PRINT(&quot;ALTER DB NAme&quot;)<br />
<br />
If i have multiple DB's which meets the about. It should PRINT multiple ALTER statements with DB Names
</div>
</div>


I have a SP in which i need to add one condition to check multiple databases by using sys.dm_database_encryption_keys table. 

when encryption_state is 2 and percentage_completed is 0 in the results it should print. Below is my query



DECLARE @Test varchar(10)
SELECT @Test = Database_ID from 
                             sys.dm_database_encryption_keys  
WHERE Encryption_state = 2 and complete_percentage = 0
If (@test not NULL)
Begin
PRINT("ALTER DB NAme")

If i have multiple DB's which meets the about. It should PRINT multiple ALTER statements with DB Names

SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

MongoDB (from humongous) is a free and open-source cross-platform document-oriented database program. Classified as a NoSQL database program, MongoDB uses JSON-like documents with schemas. MongoDB is developed by MongoDB Inc. and is free and open-source, published under a combination of the GNU Affero General Public License and the Apache License.