Hey Friends just simply execute the below query within your database, it will show table name,column name and collation name.
SELECT [TABLE_NAME] = OBJECT_NAME([id]),
[COLUMN_NAME] = [name],
[COLLATION_NAME] = collation
WHERE collation <> ‘your_database_collation_type’
AND collation IS NOT NULL
AND OBJECTPROPERTY([id], N’IsUserTable’)=1
The Data which are Stored on Database can be Encrypted and Decrypted on server .This are the Following methods :
Password :- Using a password is the least secure option because you use the same pass-phrase to encrypt and decrypt the data. If the stored procedures and functions aren’t encrypted, the pass-phrase can be accessed through the metadata.
Certificate :- Using a certificate offers strong protection and good performance. You can also associate a certificate with a user. The certificate must be signed by the DMK [The database master key (DMK), which is stored at the user database level and which in turn protects certificates and asymmetric keys].
Symmetric key :- Using a symmetric key is strong enough for most data security requirements and offers good performance. It uses the same key to encrypt and decrypt data.
Asymmetric key :- Using an asymmetric key provides strong protection because you use a different key to encrypt and decrypt the data. However, it negatively affects performance. Microsoft recommends that it shouldn’t be used to encrypt large values. An asymmetric key can be signed by the DMK or created using a password.
NOTE : I am also having this much of information to share and will post this methods in my next posts.
DECLARE @t TABLE (EmpId INT, EmpName VARCHAR(100)) — Here @t is a static table with Columns EmpId & EmpName
INSERT @t VALUES
(1, ‘Bhavik’),(1, ‘Mayank’),(1, ‘Keyur’),(2, ‘Sudarshan’),(2, ‘Sohan’) –Values are inserted in the Table.
FROM @t t2
WHERE t2.EmpId = t1.EmpId
FOR XML PATH(”)
) Concatenated –Names with Same ID are Concatenated and Displayed in Single Cell.
FROM @t t1