Top Articles in microsoft.public.sqlserver.programming
Attempt to fetch logical page in database92041 (7/29/2010 8:37:33 AM) Hi,
I am working on sql server 2008.
I am getting a error that says:
Attempt to fetch logical page(1:2986) in database 2 failed. It belongs to
allocation unit 64.......not to 53........
If i run that ... HP
How to determine the number of decimal places in a number?151427 (12/17/2009 12:46:06 PM) Hi,
Is there an idiomatic way of determining the number of decimal places
in a number (i.e. 0.123 = 3, 0.123456 = 6 etc.)?
Other than converting the number to a string and using string
functions to pull t... Frank
UNION ALL operator must have equal number of expressions33478 (1/4/2010 9:05:25 PM) Hello,
I have a query with a UNION ALL expression. The second select statement has less fields to pull than the first, so I am getting the following error:
"All queries in an SQL statement containing a UN... Lauren
Invalid length parameter passed to the SUBSTRING function31856 (11/25/2009 5:08:42 PM) Hi there,
I'm using SQL Server 2005 and when I do this
Declare @ContactName varchar(50)
Set @ContactName = 'This is a long description - Use Fee'
Select LEFT (@ContactName, CHARINDEX('-', @ContactName) ... Ed
How to check record exists before INSERT multiple records82071 (6/22/2010 10:57:23 AM) Hi
Im a SQL Server newbie and am a bit confused by the number of different
methods I have seen posted on the web about approaching this problem.
I am using SQL Server 2005 and I have about 500 records de... jonjack
WIndows Authentication Connection String51933 (1/13/2010 8:01:19 PM) I need to be able to connect to a database on a remote SQL Server from
a .NET client using ODBC and Windows Authentication. I need to be able
to specify a Domain username and password to connect where the dom... Joe
Q;re Descriptive stats21969 (3/5/2010 9:40:36 AM) Hi
Suppose I have the following data in a column (if is sample data, but
the DB I am working with has some specific values to indicate other data
properties - I fully accept that there may well be better... Simon
Changing Collation on Columns22075 (3/23/2010 9:23:01 PM) Hi,
I am working with a datbase where some tables have different columns using
different collations.
I am trying to make all the columns using the same collation, but some
tables haves constraints and... Utf
COUNT(DISTINCT xx) with OVER PARTITION42092 (1/6/2010 9:09:09 PM) I have a table of Visits and wanted to return a subset of all visits in the
table along with the distinct count of clients per employee within that
subset of rows. I can do it with a subquery or maybe a CT... David
Force Close and Drop Database?22361 (2/2/2010 8:08:06 PM)
I have a database that a misbehaving process puts into single-user
mode. I am trying to come up with a "bulletproof" way in TSQL only to
do the GUI equivalent of
Forcibly taking control of the database -... SnapDive