Viewing 15 posts - 8,236 through 8,250 (of 13,876 total)
maddukuru.rambabu (7/22/2015)
below link is my suggestion. But here data migration only happened.
http://www.sqlservercentral.com/Forums/Topic1704137-364-1.aspx
But I am also looking for If records are new it should be inserted or if...
July 22, 2015 at 1:52 am
maddukuru.rambabu (7/22/2015)
Hi,As per Vipin requirement, we need to create 500 packages for 500 tables.
I think this is complicate solution for vipin requirement.
You are, of course, welcome to your opinion.
But if...
July 22, 2015 at 1:10 am
You're going to have to learn how to add attachments so that you can add the query plans (good and bad).
When you are creating a post, look at the bottom...
July 22, 2015 at 1:02 am
happy55 (7/21/2015)
If I am using package deployment model, then I would need my connection string to be dynamic...
July 22, 2015 at 12:54 am
happy55 (7/21/2015)
shall I use?
I goggled and found ADO.NET is preferred for scripts .Then I...
July 21, 2015 at 5:37 am
You cannot pass T-SQL to be executed like this.
You will have to either resort to using something like sp_executesql, or change your proc around a bit to avoid this somewhat...
July 21, 2015 at 5:02 am
maddukuru.rambabu (7/20/2015)
Actually this is for data migration from one DB to another DB
Splendid.
July 20, 2015 at 1:42 am
maddukuru.rambabu (7/20/2015)
I am using transfer SQL Server object task. By using this task we can perform below tasks.
1) copying the schema
2) copying the data
3) truncate data from...
July 20, 2015 at 12:57 am
Chelski_blue (7/17/2015)
July 17, 2015 at 9:09 am
nidhi.naina (7/17/2015)
So you think there can be some other options? As i have quite a few checks in where clauses for different tables and columns.
Or should i go with...
July 17, 2015 at 6:22 am
mohammed.mazahr (7/17/2015)
Thanks any pointers on how to split by multiple space delimiters
Give me some examples please.
July 17, 2015 at 5:17 am
Simplified version.
select *
from
where try_parse(Capacity as int) < 0;
July 17, 2015 at 5:15 am
nidhi.naina (7/17/2015)
July 17, 2015 at 5:11 am
Srikanth vathsala (7/17/2015)
Try this,
Declare @k char(10)
Declare @l as Char(10)
Set @k ='-88'
set @L = '88'
Select IIF( ISNUMERIC(@k) = 1,
Case
When Cast(@k as integer) > 0 then 'Positive'
When Cast(@k as integer)...
July 17, 2015 at 5:10 am
Viewing 15 posts - 8,236 through 8,250 (of 13,876 total)