Database

ALTER TABLE dbo.mytable
ADD CONSTRAINT DF_mytable_VendorLevelId DEFAULT (0) FOR VendorLevelId;

UPDATE dbo.mytable
SET VendorLevelId = 0
WHERE VendorLevelId Is Null;

ALTER TABLE dbo.mytable
ALTER COLUMN VendorLevelId int NOT NULL;

CREATE TABLE dbo.doc_exy (column_a INT )  ;
GO

INSERT INTO dbo.doc_exy (column_a) VALUES (10) ;
GO

SELECT * FROM  dbo.doc_exy 

10

ALTER TABLE dbo.doc_exy ALTER COLUMN column_a DECIMAL (5, 2);
GO

SELECT * FROM dbo.doc_exy

10.00

DROP TABLE dbo.doc_exy ;
GO

string connStr = "server=127.0.0.1;uid=DogzBolx;pwd=password;database=imagecatalog;";
MySqlConnection conn = new MySqlConnection(connStr);
conn.Open();
string sql = "select * from data order by count desc;";
MySqlDataAdapter da = new MySqlDataAdapter(sql, conn);
DataTable data = new DataTable();
da.Fill(data);
foreach(DataRow row in data.Rows)
{
    string md5 = Convert.ToString(row[0]);
    int count = Convert.ToInt32(row[1]);
    Console.WriteLine(md5 + " " + count);
}
conn.Close();

SET CONCAT_NULL_YIELDS_NULL ON;
GO

CREATE FUNCTION Function_StripHTML(@Text NVARCHAR(MAX), @BreakLine BIT)
RETURNS VARCHAR(MAX)
AS
BEGIN
	DECLARE @XML AS XML
	
	IF @BreakLine = 1
	BEGIN
		SET @Text= REPLACE(REPLACE(REPLACE(@Text,'<br>', CHAR(13)), '<br/>',CHAR(13)), '<br />',CHAR(13))
	END
	ELSE
	BEGIN
		SET @Text= REPLACE(REPLACE(@Text, '<br/>','<br>'), '<br />','<br>')
	END
	
	SET @XML = CAST(('<x>' + REPLACE(REPLACE(dbo.Function_RemoveInvalidCharacters(@Text), '&', '&'), '<', '</x><x>')+'</x>') AS XML)
	
	SELECT
		@Text=
		(
			SELECT
				CASE WHEN LEFT(N.value('.', 'VARCHAR(MAX)'), 3) = 'br>' THEN
					'<' + N.value('.', 'VARCHAR(MAX)')
				ELSE
					STUFF
					(
						N.value('.', 'VARCHAR(MAX)')
						, 1
						, CHARINDEX('>', N.value('.', 'VARCHAR(MAX)'))
						, ''
					)
				END
			FROM
				@XML.nodes('x') AS T(N)
			  FOR XML PATH('')
			, TYPE
		).value('.', 'VARCHAR(MAX)')
	
	RETURN LTRIM(RTRIM(@Text))
END
GO

Member 2458467 wrote:

in the form of DBO.*

MSDN[^]:

For example, if user Andrew is a member of the sysadmin fixed server role and creates a table T1, T1 belongs to dbo and is qualified as dbo.T1, not as Andrew.T1. Conversely, if Andrew is not a member of the sysadmin fixed server role but is a member only of the db_owner fixed database role and creates a table T1, T1 belongs to Andrew and is qualified as Andrew.T1. The table belongs to Andrew because he did not qualify the table as dbo.T1.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Member 10392875 wrote:

Please provide me the answer as soon as possible.

Select IsNull(C.CompanyName, P.PersonName) Contact
From LinkTable L
Left Join ComapanyTable C on C.CompanyID = L.CompanyID
Left Join PersonTable P on P.RealPersonID = L.RealPersonID