Viewing 15 posts - 541 through 555 (of 8,416 total)
Chrissy321 (5/24/2012)
How embarassing! Sorry to be a nuisance.
Not at all. We've all done it.
May 24, 2012 at 5:57 pm
Chrissy321 (5/24/2012)
I was expecting to get consistent results between these two select statements. Am I misunderstanding something?
The data does not match between the table and hard-coded statement :unsure:
CREATE TABLE #Test...
May 24, 2012 at 4:13 pm
tobinare (5/24/2012)
I'm very new to SQL Server and am programming a front end to a database using c++ and ADO.
If this is classic ADO, you won't be able to use...
May 24, 2012 at 2:37 pm
tobinare (5/24/2012)
I'm using SQL Server 2008 Express. And @@SCOPE_IDENTITY() is not recognized.
It was a typo by SGT_squeequal; the function name is SCOPE_IDENTITY().
May 24, 2012 at 2:25 pm
adonetok (5/24/2012)
I think that the problem is in my code below:.Parameters.Add(New SqlParameter("@Comments", SqlDbType.VarChar, 255)).Value = _comments
I set @comments as 255 but in SQL table is 8000
That would be it, yes...
May 24, 2012 at 2:13 pm
tobinare (5/24/2012)
I've noticed that while submitting a SELECT query to the database while actively Inserting into the data the records returned from the query are inconsistent.
The behaviour of SQL Server...
May 24, 2012 at 2:09 pm
Sean Lange (5/24/2012)
Second, and possibly more of an issue is you are using @@IDENTITY. This will return the most recent identity for ANY connection.
Yikes, no. You're thinking of IDENT_CURRENT;...
May 24, 2012 at 1:58 pm
adonetok (5/24/2012)
I set one column as varchar(8000) but user still complain that some input was cut off.Does varchar(8000) really store 8000 characters?
Yes.
DECLARE @String varchar(8000);
SET @String = REPLICATE('ABCDEFGH', 1000);
SELECT DATALENGTH(@String);
If you...
May 24, 2012 at 1:40 pm
Sean Lange (5/24/2012)
This gets the number of months since the "0" date or 1/1/1900. As of today's posting that is 1,348.
Just to emphasise, the reason it works is that this...
May 24, 2012 at 1:30 pm
Explained in this Books Online entry: Considerations for Merge Replication
May 24, 2012 at 3:38 am
Are you able to alter the query to produce well-formed XML?
DECLARE @t TABLE
(
ID INT IDENTITY,
key1 CHAR(10),
val1...
May 24, 2012 at 3:15 am
villanueva.jonel (5/24/2012)
I would like the result of AVG between the 2 dates to have 2 decimal places. kindly please take a look my query.
Looked at the query. Did you...
May 24, 2012 at 2:35 am
Jeff Moden (5/24/2012)
Pro Tip: Reading the existing replies to a thread can help prevent posting duplicate information.
Regarding this point. You know yourself that you often rock up to a...
May 24, 2012 at 2:00 am
Jeff Moden (5/24/2012)
May 24, 2012 at 1:50 am
You don't have to use EXCEPT, there are many ways to do this:
SELECT *
FROM dbo.Table1 AS t1
RIGHT OUTER JOIN dbo.Table2 AS t2 ON
t2.ID = t1.ID
WHERE...
May 24, 2012 at 12:51 am
Viewing 15 posts - 541 through 555 (of 8,416 total)