|
|
-
Adam Tokarski knew 4 Months ago through Just Learned
While update,Delete,Insert, if need to send modified/deleted records information back to caller(asp.net or any other client for that matter), use OUTPUT clause in query as follows.
DELETE dbo.TableName
OUTPUT DELETED.*;
...
|
-
Adam Tokarski Liked 4 Months ago through Just Learned
While update,Delete,Insert, if need to send modified/deleted records information back to caller(asp.net or any other client for that matter), use OUTPUT clause in query as follows.
DELETE dbo.TableName
OUTPUT DELETED.*;
...
|
-
Adam Tokarski Learned 10 Months ago through Just Learned
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,PA...
|
-
Adam Tokarski Liked 10 Months ago through Just Learned
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,PA...
|
-
Adam Tokarski Learned 10 Months ago through Just Learned
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,PA...
|
-
Adam Tokarski Liked 10 Months ago through Just Learned
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,PA...
|
-
Adam Tokarski Learned 10 Months ago through Just Learned
One can view & print excel files on computers that do not have excel installed. search for "excel viewer" .
Business scenario: when it does not make sense to buy a license when all you need is view & print excel files. ...
|
-
Adam Tokarski Liked 10 Months ago through Just Learned
One can view & print excel files on computers that do not have excel installed. search for "excel viewer" .
Business scenario: when it does not make sense to buy a license when all you need is view & print excel files. ...
|
-
Adam Tokarski Learned 10 Months ago through Just Learned
One can view & print excel files on computers that do not have excel installed. search for "excel viewer" .
Business scenario: when it does not make sense to buy a license when all you need is view & print excel files. ...
|
-
Adam Tokarski Liked 10 Months ago through Just Learned
One can view & print excel files on computers that do not have excel installed. search for "excel viewer" .
Business scenario: when it does not make sense to buy a license when all you need is view & print excel files. ...
|