Viewing 15 posts - 256 through 270 (of 345 total)
I had some time to play. Try this out, thbaig1.
create table test (ID int, col1 bit, col2 bit);
insert into test (ID, col1, col2)
select 1, 1, 1 union all select 2,...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
May 5, 2011 at 8:02 am
If you have such a bad design to your database that you are adding columns to a table dynamically, then you won't care about more bad code.
It's pretty easy...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
May 4, 2011 at 12:48 pm
Can you work in the frozen banana stand this weekend?
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
May 3, 2011 at 3:41 pm
Ninja's_RGR'us (5/3/2011)
How can you NOT use SSMS?Do you mean SSMS import wizard?
HAHA! Acronym confusion levels maxed! By SSMS, I meant SQL Server Migration Assistant for Access that calvo had referenced.
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
May 3, 2011 at 10:20 am
Ninja's_RGR'us (5/3/2011)
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
May 3, 2011 at 9:53 am
Let your migration script become your design document. Create a .sql script that creates the database, creates the tables, indexes, views, procedures, everything . Use something like OPENROWSET to grab...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
May 3, 2011 at 7:03 am
QQ-485619 (4/29/2011)
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 29, 2011 at 9:00 am
calvo (4/28/2011)
ColdCoffee (4/28/2011)
toddasd (4/28/2011)
@WayneS
: You write some great code.I totally concur 🙂 he is awesome, like how The Miz in WWE says, Wayne is awesome 🙂
lol...love it. You just worked...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 28, 2011 at 2:20 pm
Seriously?
njdevils39 (4/28/2011)
DECLARE @test-2 TABLE
...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 28, 2011 at 1:45 pm
Your quotes are off, I don't see how that runs at all.
This works for me:
declare @ip_newuser varchar(100);
declare @sql varchar(max);
set @ip_newuser = 'new_user';
--begin tran srvr;
set @sql =' create login ' +...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 28, 2011 at 8:11 am
I didn't notice they were firing the same job. Do this:
if Exists (select 1 where 1=1)
and
not Exists (select 1 where 1=0)
and
not Exists (select 1 where 1=0)
exec...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 27, 2011 at 3:30 pm
if Exists (select 1 ...)
begin
exec ...
end
else
if Exists (select 1 ...)
begin
exec ...
end
else
if Exists (select 1 ...)
begin
exec ...
end
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 27, 2011 at 3:21 pm
What is difficult today becomes trivial tomorrow. Or so I hope. 😛
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 27, 2011 at 2:52 pm
Sure thing. But the question lingers: why generate the delete statements like this? Why not just delete for the year? I'm very curious to your reasoning. :unsure:
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 27, 2011 at 2:21 pm
Select FirstCommunityChoice, Count(FirstCommunityChoice) as 'Community Count'
From dbo.tblApplicationCommunities
Group By FirstCommunityChoice
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 27, 2011 at 2:05 pm
Viewing 15 posts - 256 through 270 (of 345 total)