Viewing 15 posts - 9,781 through 9,795 (of 15,381 total)
According to BOL it should be db_ddladmin.
December 21, 2012 at 12:07 pm
Lowell (12/21/2012)
reminds me of horrors like this:
CREATE TABLE [SELECT]([SELECT] INT IDENTITY(1,1) NOT NULL PRIMARY KEY )
SELECT [SELECT].[SELECT] FROM [SELECT] WHERE [SELECT] = 1
OMG my eyes are bleeding!!! That is an...
December 21, 2012 at 10:18 am
ncurran217 (12/21/2012)
Ok I have never used an IDENTITY column or created one. What would be the SQL command to create that column?
Here is an example of using...
December 21, 2012 at 10:15 am
laurie-789651 (12/21/2012)
This has been covered here quite recently, & the consensus seems to be that...
December 21, 2012 at 9:57 am
ncurran217 (12/21/2012)
December 21, 2012 at 9:53 am
There are two major points here.
1) Think about why the names can't be the same. Consider the following.
select * from Demo
exec Demo
Is the select referring to the proc or...
December 21, 2012 at 9:47 am
sqlfriends@sql.com (12/21/2012)
I have the clarification in date comparision in previos dates , in One condition need To check Where my Typ_id is 01 and 02 Then date can...
December 21, 2012 at 9:40 am
The point that Laurie is making is that cursors are absolutely awful for performance. There are a few times when they are needed (maintenance scripts) but your example is not...
December 21, 2012 at 9:29 am
Bhuvnesh (12/20/2012)
Bhuvnesh (12/20/2012)
Sean Lange (12/20/2012)
pr.price <> 9999.99
Try making this a SARGable predicate by removing the <> and replacing with > OR <
pr.price < 9999.99 OR pr.price > 9999.99
new learning...
December 21, 2012 at 8:14 am
mozturk 92000 (12/20/2012)
T-SQL :Select * from Gecoserv where typeOfEcosystem IN (:typeNameList) AND service IN (:serviceNameList)
That is the same thing you posted originally. It seems you want some help with...
December 21, 2012 at 7:45 am
David92595 (12/20/2012)
I am trying to run a SQL job or maintenance plan on the startup (restart) of a SQL Server.
I’m trying to automate...
December 20, 2012 at 2:16 pm
pr.price <> 9999.99
Try making this a SARGable predicate by removing the <> and replacing with > OR <
pr.price < 9999.99 OR pr.price > 9999.99
December 20, 2012 at 8:50 am
andrew gothard (12/20/2012)
They're not a...
December 20, 2012 at 8:42 am
With the extremely limited amount of details nobody can do much here but speculate. It seems that having 3 or more tables all with the same basic data is overkill....
December 20, 2012 at 8:39 am
$w@t (12/19/2012)
I have two stored procedures which return dynamic columns as result sets.
is there any way to combine both resultsets???????
after searching for solution i got to know that it...
December 20, 2012 at 8:37 am
Viewing 15 posts - 9,781 through 9,795 (of 15,381 total)