|
|
-
hellosuresh Posted 3 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.*;
...
|
-
hellosuresh Liked 1 Years ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
-
hellosuresh Commented 1 Years ago through Blogs
Hi Madhavan,
Nice Post. I have one question. I have text file where all row data in one line separated by line feed(\n). We have another XML(Schema) file which helps to pick up fields based on positions.
For Ex my flat file is like below
"Ste...
|
-
hellosuresh Commented 1 Years ago through Blogs
Hi Madhavan,
Nice Post. I have one question. I have text file where all row data in one line separated by line feed(\n). We have another XML(Schema) file which helps to pick up fields based on positions.
For Ex my flat file is like below
"Ste...
|
-
hellosuresh Posted 2 Years ago through Just Learned
The following script helps to find columns which have special characters other than alphanumeric, in a given database. If some special character for example under score "_" as part of column name and want to ignore, include special character with escape...
|
-
hellosuresh Posted 2 Years ago through Just Learned
The following script helps to find columns which have special characters other than alphanumeric, in a given database. If some special character for example under score "_" as part of column name and want to ignore, include special character with escape...
|
-
hellosuresh Posted 2 Years ago through Just Learned
The following script helps to find columns which have special characters other than alphanumeric, in a given database. If some special character for example under score "_" as part of column name and want to ignore, include special character with escape ch
|
-
hellosuresh Learned 2 Years ago through Just Learned
The following script helps to find columns which have special characters other than alphanumeric, in a given database. If some special character for example under score "_" as part of column name and want to ignore, include special character with escape...
|
-
hellosuresh Learned 2 Years ago through Just Learned
The following script helps to find columns which have special characters other than alphanumeric, in a given database. If some special character for example under score "_" as part of column name and want to ignore, include special character with escape...
|
-
hellosuresh Commented 2 Years ago through Ask
I got the answer. Do you want to me to paste my code how am I handling. So that it will be helpful for some one who watches this question....
|