|
|
-
|
|
Within an INSERT/UPDATE trigger, we can use the UPDATE() function to determine where a specific column is part of the updated/inserted column list. For example:
IF UPDATE(CustomerName) BEGIN
PRINT 'Customer name is being updated'
--...
|
|
-
|
|
Microsoft SQL Server includes a popular command-prompt utility named BCP for moving data from one table to another, whether on a single server or between servers. The SqlBulkCopy class lets you write managed code solutions that provide similar functiona......
|
|
-
|
|
Go to server manager > configure IE ESC > Turn off "enhanced security configuration".
Note: only for demo machines.......
|
|
-
|
|
Run this code and see the pattern matching in the result
[code]select
987654321987654321987654321987654321*3.0,
987654321987654321987654321987654321*9.0
[/code]......
|
|
-
|
|
following words contain five vowels
Education
Facetious
abstemious......
|
|
-
|
|
I just came to know that "Hindi" is not india's national Language. Even according to constitution, there is no national language for India.
Article 343 of the constitution specifies that the official language of the India is Hindi in Devanagari scrip......
|
|
-
|
|
Just like you have learned it for MS Word at http://beyondrelational.com/justlearned/posts/161/generating-sample-text-in-word-document.aspx, you can use the same code to generate sample text in powerpoint also
[code]
=rand()
[/code]......
|
|
-
|
|
Recently I am surfing on net I found useful post for LINQ there is a Zip Operator is introduce in LINQ thread two list together
eg.
[code]
string[] codes = { "CAD","HRK","ILS", "JOD", "LTL"};
string[] states =
{
" Canadian Dollar",
"Cr......
|
|
-
|
|
Just Learned from Niladri Biswas blog that, ORACLE's CONCAT() function only takes 2 arguments, So, it means we can't concatenate 3 strings in a function
call. We should use Nested calls of CONCAT() function to achieve the same. Remember in SQL Server D......
|
|
-
|
|
Earlier on Beyondrelational I read a tip, for the same topic.
combination of keys Shift + Print screen, allows us to take screen shot of Remote Desktop.
But recently I faced problem using these keys. It allowed taking print screen only once. Every other...
|
|