Viewing 15 posts - 1,081 through 1,095 (of 1,479 total)
I was looking for an option that will say that the query will cause an error (because of the missing group by) but I didn’t find one. I ignored...
March 18, 2009 at 2:34 am
You cannot compare null with the an equal sign (=). When you check for null you have to use the is null or is not null operators. Take...
March 18, 2009 at 2:28 am
Krishna (3/17/2009)
March 17, 2009 at 7:00 am
Here is one way of doing so:
select noo, namee, min(SourceName)
from (
select distinct noo, namee, 'a' as SourceName
from samm
union
select distinct noo, namee, 'b'
from sammM) dt
group by noo, namee
I...
March 17, 2009 at 6:51 am
AshaRRichardson2nd (3/16/2009)
this should actually be an add column datetime with a defaulte setting of getdate().Also, how do I specify no check constraint?
If you want to add a new column with...
March 16, 2009 at 11:31 pm
After your last message, I looked for more information instead of using my memory, and I have to say, that you might be correct. When windows 2000 is used,...
March 16, 2009 at 9:02 am
I think that I understand you now. Instead of using one update statement that updates all the records, you are looping through the records and updating each record with...
March 16, 2009 at 8:12 am
parth83.rawal (3/16/2009)
March 16, 2009 at 7:43 am
If I understand you correctly, both instances are not configured to use awe. If this is the case, none of them will be able to use more then 2GB....
March 16, 2009 at 7:33 am
Triggers don’t get fired for each record, they get fired for each statement. This means that if you ran one update statement, the trigger will be executed exactly one...
March 16, 2009 at 7:13 am
If you are not using the 64 bit edition, you can’t use more the 2GB without configuring the server to use awe. If you are not using Enterprise edition,...
March 16, 2009 at 6:08 am
If you don’t have a backup of this database, you can modify the files’ names, then create a new database with the same name and files’ structure as the old...
March 15, 2009 at 9:32 am
You query the data the exact same way that you query a database that has only one MDF file. When you issue any SQL Statement you don’t have to...
March 15, 2009 at 9:07 am
You can find an explanation here – http://msdn.microsoft.com/en-us/library/ms191516(SQL.90).aspx
Adi
March 15, 2009 at 9:01 am
The permissions that users have in the DB are stored in the user database and not on the server level. There is no need to script those permissions if...
March 15, 2009 at 6:45 am
Viewing 15 posts - 1,081 through 1,095 (of 1,479 total)