Viewing 15 posts - 1,051 through 1,065 (of 1,999 total)
S_Kumar_S (6/8/2012)
But my where clause is not doing comparision with NULL. it is doing comparision with 0.And since NULL is not a zero, those records should come logically.
no - not...
June 8, 2012 at 4:51 am
anthony.green (6/8/2012)
the N specifies that the following string is a NVARCHAR stringN'\\XXXXXXXX\W$\LOG_BACKUP\XXXXXXXX_tlog_201206072000.TRN'
Your actually backing up to \\XXXXXXXX\W$\LOG_BACKUP\, not the N drive
Edit
Mike beat me to it again
lol - my kung fu...
June 8, 2012 at 4:48 am
jblovesthegym (6/8/2012)
BACKUP failed to complete the command BACKUP LOG [XXXXXXXX] TO DISK = N'\\XXXXXXXX\W$\LOG_BACKUP\XXXXXXXX_tlog_201206072000.TRN' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
This is odd as...
June 8, 2012 at 4:46 am
have a look through books online - or google "NULL EVALUATION SQL SERVER"
http://stackoverflow.com/questions/1843451/why-does-null-null-evaluate-to-false-in-sql-server
http://msdn.microsoft.com/en-us/library/ms172138(v=vs.80).aspx
basically (in simplest terms) NULL does not evaluate: you cannot say =NULL or <> NULL
you can use the...
June 8, 2012 at 4:42 am
If this was a geography forum, you would be the flat earth kid:w00t:
Since you don't know anything about RDBMS, then get a copy of the simplest intro book...
June 8, 2012 at 4:38 am
+1 phil - you beat me to it by 1 minute
also possibly a synonym???
June 8, 2012 at 4:29 am
i'm sure you've already checked , but can you run the query from your database and make sure you specify the schema name (but not the db)
ie select x,y,z from...
June 8, 2012 at 4:28 am
a couple of things here
IF @NextOrderNo is null
begin
SET @OrderNo = (SELECT NextNo FROM NxNo (Nolock))
update NxNo set NextNo = NextNo @increasevalue
end
1) remember to use the WITH statement for your...
June 8, 2012 at 4:23 am
derek.colley (6/8/2012)
Sounds like the view is doing an implicit conversion of the VARCHAR column to INT.
Please post structure of...
June 8, 2012 at 4:13 am
tbraithwaite (6/8/2012)
I have a table that has a column [unique_name] defined as Varchar(64) and this contains ID numbers some of which have...
June 8, 2012 at 4:12 am
balasach82 (6/1/2012)
We are using sp_OACreate, sp_OAGetErrorInfo, sp_OAMethod, sp_OAGetProperty, sp_OADestroy.
Error occurs only for some of the records which satisfies a particular condition and not for all records. Even though, we get...
June 6, 2012 at 4:05 am
i also had to count out loud the alphabet then decided ASCII('a') and ASCII('z') gave me the numbers i needed
June 1, 2012 at 9:44 am
looks like you could use a TVP (table value parameter)
it's bets not to pass delimeted strings in as parameters
try the following - (example code only)
CREATE TYPE xtype as TABLE(id int)
GO
create...
June 1, 2012 at 9:40 am
and how many connections are currently open on your server (perhaps your application is not closing connections properly - it's not unheard of!!!)
also - how much RAM on the box...
June 1, 2012 at 9:29 am
what is your max worker threads setting?
June 1, 2012 at 9:28 am
Viewing 15 posts - 1,051 through 1,065 (of 1,999 total)