Viewing 15 posts - 8,356 through 8,370 (of 8,697 total)
Next step, generate the create script for the table. Make certain to go first to tools->options and under SQL Object Explorer->Scripting select all the relative options.
Let us know what you...
May 3, 2014 at 1:00 am
Execute this statement (with the correct schema and table name)
EXEC sp_help 'schema.table'
Then look for the constraint and Foreign key reference sections. Resolve those!
😎
May 3, 2014 at 12:31 am
If it is not working then take a look at this: CTRL + R not working in SSMS 2012
😎
May 2, 2014 at 11:53 pm
First thing that comes to mind is to use the SQL Server Import and Export Wizard from SSMS. (right click on the target sql database->Tasks->Import data) Walk through the Wizard...
May 2, 2014 at 11:49 pm
For what it's worth, have a test system with 2005 and 2014 on it, not on the same drives though, 2005 is a default 1433 instance, 2014 a named instance,...
May 2, 2014 at 12:19 pm
Chio, you could compare the installation logs from the different instances to track down the difference. I'll try out your component on a vanilla system and let you know the...
May 2, 2014 at 10:18 am
Hard to say without further knowledge, normally I would consider this a good and normal practice.
😎
May 2, 2014 at 10:03 am
Eric M Russell (5/2/2014)
Eirikur Eiriksson (4/1/2014)
Has anyone tried out the new 3D joins in 2014?
I can confirm that 3 dimensional joins work quite well; it's the 12 or 20 dimensional...
May 2, 2014 at 8:56 am
Lowell (5/2/2014)
... looked for lower hanging forum posts 😎
Felt I could not leave this one hanging......:cool:
May 2, 2014 at 5:22 am
free_mascot (5/2/2014)
Great Eirikur, is it possible to send this OUTPUT to excel using this T-sql?
Use the output to insert the records into a table and export to excel/csv from there....
May 2, 2014 at 4:29 am
You can use the output clause with the delete
😎
DECLARE @TTABLE TABLE
(
TT_ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED NOT NULL
,TT_VAL INT NOT NULL
);
INSERT INTO @TTABLE(TT_VAL)
VALUES...
May 2, 2014 at 3:21 am
I would recommend a dynamic package or in other words, programmatically generated packages. This is fairly straightforward from a script task in a master package.
😎
May 2, 2014 at 12:39 am
Lowell (5/1/2014)
maybe someone else can take the ball and run with it form...
May 1, 2014 at 10:53 pm
Lowell (5/1/2014)
May 1, 2014 at 9:33 pm
A simple solution
😎
with p as
(
select 'asdf1234' as Delivery_Site union all
select 'asdf 1234' union all
select ' asdf asdf ' union all
select ''
)
,TXT_INFO AS
(
SELECT
...
May 1, 2014 at 11:54 am
Viewing 15 posts - 8,356 through 8,370 (of 8,697 total)