Viewing 15 posts - 47,416 through 47,430 (of 49,571 total)
*sigh* Users... 😉
Suggest to him that he scripts the data structure out and then uses BCP to export non-sensitive data. He can then send you the scripts and the exported...
February 12, 2008 at 2:27 am
Not without using dynamic SQL.
The other option is that you can use one of the split functions that are in the script library here to split the string apart into...
February 12, 2008 at 1:29 am
GermanDBA (2/12/2008)
So the performance winner with select 1 is that the server doesn't take the hit for column checks.
That's what I understood from Conor's post. It's probably a very, very...
February 12, 2008 at 1:15 am
In a where clause, yes. As part of an IN, no. What are you trying to acheive?
Coalesce is used as follows:
WHERE SomeColumn = Coalesce(@Param1, @Param2, @Param3,0)
If @Param1 is not null,...
February 12, 2008 at 1:02 am
Please don't cross post. It wastes people's time and fragments replies. I answered your other post.
Replies to the following thread please - How to do Coalesce
February 12, 2008 at 12:56 am
I'm not sure what you're trying to do with Coalesce. Coalesce just returns the first non-null expression from the arguments passed to it. So
Coalesce('1,2',idcol) will return '1,2' always, since it's...
February 12, 2008 at 12:48 am
My database seems to be somehow encrypted by the software I used
What software are you using?
February 11, 2008 at 11:35 pm
Nisha (2/11/2008)
Gail, do you mean the syntax is incorrect in SS 2k5?
It's ambiguous. It isn't clear what you mean. Try this one
SELECT DISTINCT FirstName as Name, LastName as Name
FROM Person.Contact
ORDER...
February 11, 2008 at 11:24 pm
Thanks for been honest about it being homework.
Show us what you've done so far and what problems you are having and someone will help.
We don't do homework assignments for...
February 11, 2008 at 11:22 pm
If the server you're connecting to is SQL 2000 or the adventureworks DB you're using is in compatability mode 80, the query will work fine.
Against a SQL 2005 server with...
February 11, 2008 at 3:40 am
What do you mean by 'producion support level'?
February 11, 2008 at 2:36 am
It's possible that this will be allowed in SQL 2008, as one of the changes in 2008 is to allow passing of table variables to stored procedures.
February 11, 2008 at 2:36 am
Check the sys.dm_exec_requests DMV. What are the long running queries waiting on?
Have you rebuilt indexes recently?
Does recompiling the procedure make any difference? (EXEC sp_recompile 'StoredProcName')
February 10, 2008 at 5:42 am
Whe SQL deletes a row, it doesn't overwrite the entry on the data page, it just marks the space as available (pretty much same thing as on a file system...
February 10, 2008 at 5:36 am
Shrinking databases is generally a bad idea. A database needs some space in it for normal operation.
How long is a question that's very hard to answer. It depends on the...
February 10, 2008 at 5:31 am
Viewing 15 posts - 47,416 through 47,430 (of 49,571 total)