Be aware when you read XML data from Microsoft SQL Server by using the **SqlDataReader** object or **ExecuteScalar** method of SqlCommand class, the XML in the first column of the first row is truncated at 2,033 characters. To resolve this problem, use ...

Yes, You can overload methods in a webservice using Message Attribute...

Hello friends, one interviewer asked that suppose you have two tables `Employee_Details`, `Employee_Details_History` now I want to delete original table `Employee_details` and maintain it’s history to other table. How can it’s possible with only ...

Hello friends, one interviewer asked that suppose you have two tables `Employee_Details`, `Employee_Details_History` now I want to delete original table `Employee_details` and maintain it’s history to other table. How can it’s possible with only ...

Using WITH statement you can create a series of data and use them in your queries. Sample 1. Integer-Series

WITH T(ID) AS
(
	SELECT 1 ID
	UNION ALL SELECT ID + 1
	FROM T
	WHERE ID < 1000
)
SELECT * FROM T
OPTION (MAXRECURSION 1000)

Sa...

Using WITH statement you can create a series of data and use them in your queries. Sample 1. Integer-Series

WITH T(ID) AS
(
	SELECT 1 ID
	UNION ALL SELECT ID + 1
	FROM T
	WHERE ID < 1000
)
SELECT * FROM T
OPTION (MAXRECURSION 1000)

Sa...

Start > Programs > high-lite any item on the Menu and right click > Sort by ...

"SQL Authority" Pinal Sir published a tip about $rowguid, which can be used to fetch uniqueidentifier column from a table. It was awesome. You can find the link below. Initially thought it's like a cheat code. But its about mastering the basics. In ...

"SQL Authority" Pinal Sir published a tip about $rowguid, which can be used to fetch uniqueidentifier column from a table. It was awesome. You can find the link below. Initially thought it's like a cheat code. But its about mastering the basics. In ...

T-SQL supports the IIF function: IIF ( boolean_expression, true_value, false_value ) which is equivalent to the simple CASE statement: CASE WHEN boolean_expression THEN true_value ELSE false_value END The compiler actually rewrites the II...