all groups > sql server (microsoft) > december 2006 > threads for december 1 - 7, 2006
Filter by week: 1 2 3 4 5
integer - beyond 2,147,483,647
Posted by User at 12/7/2006 12:41:58 AM
what happends if an auto number (identity column) of datatype "int" goes
beyond 2,147,483,647 ?
Does user have to go for 64 bit in this instance?
Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTI... more >>
Database change management process
Posted by Mehdi at 12/6/2006 10:02:31 PM
Dear
In our company, we use sql server 2000 as the database server for
softwares we produce. The problem is the way that we track the changes
in database and control the changes which every developer makes in db
(something like source safe that controls the code changes for our
source codes) . ... more >>
Q: missing parent
Posted by G .Net at 12/6/2006 11:47:37 AM
Hi
Can anybody tell me the sql query I need to find the following:
I have two tables A and B. A is a parent to B.
I need to find the rows in B which do not have a corresponding foreign key
value to a row in A.
Thanks in advance
G
... more >>
inserting "0" to all fields.
Posted by User at 12/5/2006 9:42:47 AM
Hi,
I have a table with 30 columns.
I want to insert a value of "0" into the columns
I do not wish to do a
insert into table (col1,col2,col3.....col3) values(0,0,0,0,0,0,......0)
as it is a very painful process. One comma missing and it's going to hurt my
eyes.
Are there any shor... more >>
Using MS SQL Server 2005 Enterprise Manager with MS SQL Server 2000
Posted by Alex at 12/5/2006 7:56:06 AM
Hi Everyone,
Most of our MS SQL Servers are still running on SQL 2000, but being I
will soon be upgrading my workstation to Vista Business I'd like to
install MS SQL 2005 Enterprise Manager to manage them all. When I
tried to install MS SQL 2000 Enterprise Manager on Vista, it gave me a
mess... more >>
Newbie how-to websites?
Posted by Walksalong at 12/5/2006 6:07:19 AM
Hello,
I am a newbie to SQL Server and I wanted to ask the group if they could
recommend some resources on how to do basic functions such as create a
data dump.
Thanks!
... more >>
Consecutive days attending
Posted by Mike Hoff at 12/4/2006 10:51:02 AM
Hello,
I am looking for a way to determine the maximum number of consecutive days
that each client has attended an event over a certain date range.
(consecutive being key, and my problem).
For example: Over the date range 1/1/06 - 12/31/06, Bob attended 42
consecutive, Jim 17 consecutive, Mar... more >>
|