 |
MSGROUPS.NET |
 Search |
 Post Question |
 Groups |
 Stream |
 About |
 Register
|
Stats Updating... 5/25/2013 11:04:22 PM Top Users in microsoft.public.sqlserver.programming  link285 (3) 1 Articles, 2 Replies, 3 Points
Top Articles in microsoft.public.sqlserver.programming  Attempt to fetch logical page in database  9
 2041 (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? 15
1427 (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 expressions 3
3478 (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 function 3
1856 (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 records 8
2071 (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 String 5
1933 (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 stats 2
1969 (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 Columns 2
2075 (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 PARTITION 4
2092 (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? 2
2361 (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 -... SnapDiveStatistics Last Updated: 5/4/2013 12:00:00 AM |
5 followers. 