Viewing 9 posts - 16 through 24 (of 24 total)
Do you know if SQL Express supports the key management TSQL functions? I couldn't find anything that said it didn't.
And do you think that would be an appropriate way to...
December 7, 2005 at 2:42 pm
Of course you can create the temp table and then run ALTER TABLE statements against it to add columns dynamically. This won't work with table variables though.
August 4, 2005 at 9:43 am
It sounds as though you'll need to query for each column separately, then use that to build your field list for a dynamic SQL statement.
Loop through fields
Is field sum 0
...
August 4, 2005 at 9:36 am
Using
SELECT * FROM Table_Name
WHERE DATEDIFF(d, Date_Field, GetDate()) = 0
gave me
Select, est. cost = 0.622
Clustered Index Scan, est. cost = 0.616
Est. row count = 2537
Both other methods were...
April 15, 2005 at 4:30 pm
I use UltraEdit (http://www.ultraedit.com) which is a handy app. It comes with some predefined hiliting, but you can edit those and it allows you to also define your own...
January 21, 2005 at 12:02 pm
You can also query the system tables depending on how you want to use it. Visually a diagram is often more helpful, but this can be handy if you need...
January 12, 2005 at 1:02 pm
I think you missed the point, he was asking about SQL Management Studio, not Enterprise Manager.
I encountered the same issue in looking at SQL 2003, being able to edit records in...
January 12, 2005 at 11:56 am
A couple of things I have noticed, some may just be due to the fact that it is in Beta. The first is that the results grid is not editable,...
December 9, 2004 at 12:19 pm
I think it's mainly personal preference, but I usually write out the JOIN so that it's more immediately obvious what's hapening in the query.
DELETE dbo.ProjectDemand
FROM dbo.ProjectDemand pd
JOIN dbo.CADFilePath cfp ON...
November 24, 2004 at 9:36 am
Viewing 9 posts - 16 through 24 (of 24 total)