Viewing 15 posts - 6,886 through 6,900 (of 13,469 total)
"not working properly" is really tough to diagnose without seeing the function itself,as well as how you are calling the function.
do you mean it doesn't return the expected results? wrong...
August 24, 2011 at 9:04 am
i believe the key is the anticipated WHERE statement;
take this as an example:
SELECT
contactId,
FirstName,
LastName,
From Contacts
Where Entitytblkey =77
the index's columns should match...
August 24, 2011 at 8:54 am
could it be something simple like this?
EVERY command changes the @@ROWCOUNT.
you need to capture the value immeditely after the updates or deletes, and compare the saved value right?
also, i don't...
August 24, 2011 at 7:07 am
skrilla99 (8/23/2011)
c:\>systeminfo /S serverName | find "System Model:"
Which could be readily put together in a batch for all servers.
I don't...
August 23, 2011 at 12:05 pm
Ninja's_RGR'us (8/23/2011)
August 23, 2011 at 11:53 am
you could do this:
ALTER DATABASE DBNAME SET RESTRICTED_USER
I think that will prevent any other connections from hitting the database unless they are a sysadmin...you don't have everyone logging inas...
August 23, 2011 at 11:49 am
you'll need to set up database mail, which is very simple to do, and you'll need a known SMTP server with a usnername and password, most likely.
the actual command is...
August 23, 2011 at 11:41 am
if you don't keep your datetimes in datetime columns, you run into wierdnesses like this.
here's one way to sort varchar representations of time the way you asked: ideally, you'd simply...
August 23, 2011 at 9:42 am
i don't think the collation is going to affect you at all, you should use the default server collation, you just have to use nvarchar columns everywhere instead of varchar,...
August 23, 2011 at 8:52 am
the function below returns all possible colaltions on your server ...much more than i care to digest .
the second query is just the collations currently in use.
hope that helps:
select *...
August 23, 2011 at 8:31 am
Frances L (8/23/2011)
I want to update one table field value according to other table value.
table a
ID Certfication
2 ACNS-BC
3 CCRN
if table a have...
August 23, 2011 at 8:17 am
Jnrstevej (8/23/2011)
@Lowell its just a portion of the SP I've created. You are completely right with your advise it has solved the problem:-) i...
August 23, 2011 at 8:03 am
in some cases, that's absolutely true; after answering the same posting question over and over again, some folks get jaded;
I myself got snarky a while back and when someone posted...
August 23, 2011 at 8:01 am
just a day or so ago someone asked for the same thing;
see this topic for the discussion and a working solution:
August 23, 2011 at 7:17 am
shouldn't your function return a datetime instead of a char(8)?
anyway, you just wrap it with the function you wrote:
here's two ways, depending on if you change the function to return...
August 23, 2011 at 7:05 am
Viewing 15 posts - 6,886 through 6,900 (of 13,469 total)