Viewing 15 posts - 46,831 through 46,845 (of 49,571 total)
ALTER TABLE <Table name>
ALTER COLUMN <Column name> DATETIME NULL
Make sure all the data in that column can be converted to date time, or you'll get some interesting error messges
April 22, 2008 at 3:17 am
A trigger fires when data in a table changes.
If you want to run something at a specific time, you need a job, set up within SQL agent. From the...
April 22, 2008 at 3:15 am
Express does not include SQL Agent, hence you cannot create or run jobs.
April 22, 2008 at 1:59 am
A trigger fires when a row is updated/inserted/deleted in a table.
From the sounds of it, you want to change data at a certain time. Is that correct?
I'm also not 100%...
April 22, 2008 at 12:20 am
Oberion (4/18/2008)
lastly, it ain't my job to baby sit developers or review all their code. I have other projects and bigger fish to fry.
Sorry, but I can not agree...
April 21, 2008 at 7:58 am
I'm not sure I follow.
Do you want the procedure to run at midnight? If so, you need a SQL job
April 21, 2008 at 6:27 am
A logon trigger is server wide. I'm not sure if at the point of login you can see what database the user is going to connect to. You'll have to...
April 21, 2008 at 6:15 am
View should be sufficient.
You'll be needing both CASE (the the not empty string) and ISNULL (for the NULLS)
Something like this (partial query only )
SELECT ...,
CASE WHEN ISNULL(CUST_NAME_RU,'') = '' THEN...
April 21, 2008 at 3:35 am
I can't see your hard drive. Image url - file:///h:/sql.bmp
Attach a jpg to your post.
SQL agent is installed and is running. Are you sysadmin on that server?
April 21, 2008 at 1:58 am
Are the queries written optimally?
Do you have appropriate indexes?
April 21, 2008 at 12:46 am
If the trace is still running, yuo won't be able to open the file. You'll have to stop the trace, or pause it and copy the trace file elsewhere, to...
April 21, 2008 at 12:40 am
What's the error you're getting?
I've never used Visual studio's database projects, so I can't be much help.
April 21, 2008 at 12:37 am
Jim Russell (4/18/2008)
But I'm hard to convince, and I see it as a huge flaw that a db server can be so vulnerable.
I don't see it as a vulnerability....
April 18, 2008 at 8:06 am
Move the subquery into the from clause and treat it as a derived table.
Something like
SELECT
[year],
...
April 18, 2008 at 6:46 am
I did.
DECLARE @sSQL NVARCHAR(100), @rowcount INT
SET @sSQL = 'select * from sysobjects'
EXEC sp_executesql @sSQL
SELECT @rowcount = @@ROWCOUNT
PRINT '@rowcount = ' + CAST(@rowcount AS VARCHAR(4))
Output in the messages tab -
(118...
April 18, 2008 at 6:15 am
Viewing 15 posts - 46,831 through 46,845 (of 49,571 total)