Viewing 15 posts - 34,366 through 34,380 (of 49,552 total)
I know that MSDE requires a lot more effort to learn than Ms-Access. I am ready to spend whatever the time it requires. I believe you all will guide me.
Start...
January 28, 2010 at 7:47 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 28, 2010 at 7:47 am
Leon Orlov-255445 (1/27/2010)
So just out of curiosity... how many database server do you support and how many databases?
Could you please post new questions in a new thread in future, rather...
January 28, 2010 at 7:43 am
You're missing the relationship between the table being updated and the subquery. You need to say which row should be updated with which value. That's currently missing.
UPDATE Test SET [CourseName]...
January 28, 2010 at 7:40 am
jcrawf02 (1/28/2010)
Have to say, that makes it even harder to understand why SQL Injection is such a problem.
SQL injection happens when a user can inject a value that they pass...
January 28, 2010 at 7:35 am
hbujar (1/28/2010)
SELECT @count = COUNT(*)
FROM events e
WHERE e.eventtime>DATEADD(dd ,-1 ,GETDATE())
AND e.eventtime<GETDATE()
...
January 28, 2010 at 6:46 am
jcrawf02 (1/28/2010)
... that I'm still just directly concatenating the user input into my SQL.
No you're not. There's no concatenation anywhere in that piece of code. Concatenation means combining a...
January 28, 2010 at 6:37 am
Please post new questions in a new thread in future.
How much memory do these servers have? x86 or x64?
What are the symptoms? If you query sys.dm_exec_requests, what are the queries...
January 28, 2010 at 1:59 am
mike 57299 (1/27/2010)
How do I get the values from the select statement into vars that can be work with so that I can return a single amount?
What are you trying...
January 28, 2010 at 1:55 am
Also maybe worth looking here: http://sqlinthewild.co.za/index.php/category/sql-server/execution-plans/
and at these
January 28, 2010 at 1:53 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic854934-147-1.aspx
January 28, 2010 at 1:51 am
AndrewSQLDBA (1/27/2010)
I did not see anything in the SQL BOL, and I have also looked in the 2008 BOL. I see nothing about this going away.
Exactly. There's no deprecation...
January 27, 2010 at 1:11 pm
Then use a server-side trace. It's profiler without the Gui.
January 27, 2010 at 1:09 pm
shaunspad (1/27/2010)
Could you explain as it seems they are similar ways to accomplish the same thing.
Because they are two ways to accomplish the same thing.
Pre-SQL 2005, the only database that...
January 27, 2010 at 12:57 pm
Viewing 15 posts - 34,366 through 34,380 (of 49,552 total)