How to get identity, computed properties of a column in a table

Problem: How to get identity, computed properties of a column in a table? Solution: COLUMNPROPERTY, starting from SQL server 2008 or higher. Syntax: COLUMNPROPERTY (id , column , property )   (Needs input) ID – OBJECT_ID of a table or a procedure. Column – Column name or parameter name (Needs Input) Property – Type of information...

Read More

How to implement SOUNDEX

Problem: How to compare two words and get the difference of the string text? Solution:  SOUNDEX This is a string function which gives out a four-character output based on the input string. Based on the sounding of a name, address, or an object this will assign a value and similar pronunciations get the same result. The first character...

Read More

Sent Status and mail log of the database mail.

Problem: How to know the status, content and log of the database mail? Solution:  In the last post as we were able to send emails for a SQL Server Agent job history, and for alerting when a job fails. As there is lot of activity...

Read More

Sending an email from Database engine using database mail profile.

Problem: How to send an email from Database Mail.? Solution: sp_send_dbmail If we need to send alerts, notifications, Job status of a SQL Server agent from SQL Server Database. You may have to configure Database Mail to send e-mail message...

Read More