|
|
|
|
|
|
|
|
|
|
-
MrsConnieOI learned 7 Months ago through Blogs
Updating string data in-place - while there are lots of options, SQL Server always has something new. The .WRITE clause in the UPDATE statement provides partial data update, and promises to be a great alternative to REPLACE and STUFF depending upon the ...
|
-
MrsConnieOI Liked 7 Months ago through Blogs
Updating string data in-place - while there are lots of options, SQL Server always has something new. The .WRITE clause in the UPDATE statement provides partial data update, and promises to be a great alternative to REPLACE and STUFF depending upon the ...
|
-
MrsConnieOI Learned 7 Months ago through Just Learned
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 ...
|
-
MrsConnieOI Liked 7 Months ago through Just Learned
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 ...
|
|
|
-
MrsConnieOI Commented 8 Months ago through Blogs
My first thought was that I agreed with Manoj --why do this when you can just use some of the XML available in TSQL?
When I thought about it, though, I realized that this is a way to avoid having to type all of the tags, if the column names in the t...
|