Viewing 15 posts - 7,006 through 7,020 (of 15,381 total)
Naveen PK (8/27/2013)
August 27, 2013 at 2:44 pm
Patrick Womack (8/27/2013)
I have this sample data.
ItemNo DueDate Cham
121117 2013-09-05
121098...
August 27, 2013 at 2:42 pm
Jeff Moden (8/27/2013)
Jason.Reeves (8/27/2013)
Could also use the ISNUMERIC function to check that the data is an integer value.
Be careful, now. Please see the following article for why ISNUMERIC should never...
August 27, 2013 at 1:19 pm
OK. I created data for the last of your sample data.
INsert into @OrderDetail Values ( 10, 500)
INsert into @OrderDetail Values ( 20, 500)
INsert into @OrderDetail Values ( 30, 500)
Now to...
August 27, 2013 at 1:13 pm
Coriolan (8/27/2013)
declare @Orderdetail table
(OrderID int,
ProductID int)
INsert into @OrderDetail Values (...
August 27, 2013 at 12:25 pm
raj.prabhu001 (8/27/2013)
srry i cant use red gate its restricted at our organisation. plz suggest ant other method
As Steve suggested you can use sql_expression_dependencies (http://technet.microsoft.com/en-us/library/bb677315.aspx)
August 27, 2013 at 9:54 am
rocky_498 (8/27/2013)
I google but couldn't any find help. Here is the issue.
From SSMS if I want to save any sql to .sql from File==>Save SqlQuery.Sql==>ask destination where...
August 27, 2013 at 9:08 am
sqlnaive (8/27/2013)
"DELETE is a logged operation while TRUNCATE is not" as the truncate just deallocates the data pages from the table and that is...
August 27, 2013 at 8:50 am
That helps clarify. I wouldn't use MERGE for this. I converted your sample ddl into temp tables so it is easier to work with in a test database.
create table #SourceTable
(number...
August 27, 2013 at 8:18 am
sqlnaive (8/27/2013)
"DELETE can be ROLLED BACK...
August 27, 2013 at 7:57 am
Hi and welcome to SSC. I would love to help you but you haven't provided enough information for me to help. In order to help we will need a few...
August 27, 2013 at 7:54 am
ningaraju.ne 46825 (8/27/2013)
August 27, 2013 at 7:51 am
ningaraju.ne 46825 (8/27/2013)
I have an hierarchy table as below which stores the key data.And the value for this key will be stored in another table.And the Value can be...
August 27, 2013 at 7:47 am
vignesh.ms (8/26/2013)
I have 2 table say source and destination.
I'm trying to insert data from source table to destination table ,which are not available in the destination table.
this is...
August 27, 2013 at 7:34 am
Jason.Reeves (8/27/2013)
Have you looked at the possibility of using CDC for some of this ?
Guessing you missed it in the OP.
I implemented change data capture, but I found interpreting...
August 27, 2013 at 7:32 am
Viewing 15 posts - 7,006 through 7,020 (of 15,381 total)