|
|
-
|
|
Yesterday night, I was reading Inside Microsoft Sql server 2008: Programming - Itzik Ben-Gen. On Cursors section Page number 291, he has tried to explain the scenario for calculating multiplication on row wise manner. He has explained through cursor. Be...
|
|
-
13
Liked
| 13
Learned
| 16
Comments
|
|
Hi,
Just now i Wrote one query to remove special characters from a string..
Hope this is useful.
DECLARE @I VARCHAR(100)
SELECT @I ='abhi *s d ^.l'
WHILE PATINDEX('%[^A-Za-z0-9 ]%' , @I ) <> 0
BEGIN
SELECT @I= STUFF(@I,PATIN...
|
|
-
|
|
Microsoft Newly introduced **Snippets** and Surround With in **SQL Server 2012**
How to use these options and create new snippets we can see in the below blog post.
...
|
|
-
|
|
Recently I came across a code written by a developer. He was trying to solve a problem to find max and min value among multiple column for each row. Through Below dummy code I am trying to explain -
--Use tempdb
USE tempdb
--Create a d...
|
|
-
|
|
I just learned that Active Directory Helper Service is discontinued in SQL Server 2012....
|
|
-
|
|
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 IIF f...
|
|
-
|
|
Do you know ANSI-92 versions of T-SQL therefore early 6.5 version was so programmatically influenced. This was tha old-style LEFT OUTER JOIN syntax.
SELECT TableX.ID, TableY.ID
FROM TableX, TableY
WHERE TableX.ID *= TableY.ID
The ...
|
|
-
|
|
The ACID rules of transaction in any database assure the reliability of data in all transactions in the database.
Atomicity (“all or nothing” rule) - this rule states that either the complete transaction takes place, or none. Even if a part of a transa...
|
|
-
17
Liked
| 16
Learned
| 8
Comments
|
|
In SQL Server 2008, We have a feature to select multiple lines with specific characters.
In SQL Server 2012, we can append the same text to multiple lines.
Below images will give the clear picture to understand this feature.
Some times we need to add s...
|
|
-
|
|
I was Mckinsey's Big Data report 2011 when I learned that " during a single cross-country flight, a Boeing 737 generates 240 terabytes of data " ...
|
|