Topic profile page for Bigint.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Bigint.
Topic "Bigint" was discussed 1,047 times on 138 sites in last 3 months
Started 2 weeks, 6 days ago (2009-10-23 11:02:00)
by karti
Hi, We are changing all our identity/primary coloums to BIGINT from existing INT data type. when we try to change, because of some Foreign key/constraints its not updating and asking to drop the table and Re-create it again. Kindly let me know what are the approch to be followed.
Started 2 weeks, 6 days ago (2009-10-22 16:06:00)
by aspfun
I used code below but do not work as expected. test data: A.CLAIMNO = 200910228450002, nvarchar data type declare @c bigint set @c = cast((select distinct A.CLAIMNO from a) as bigint)+1 print @c // print out as 200910228450003 that is correct declare @d nvarchar set @d = cast(@c as nvarchar(50)) print @d //print out as 2, not correct, should be 200910228450003 How to code to make @d = ...
Started 3 weeks, 1 day ago (2009-10-21 10:43:00)
by Domenico Barile
We would create a table with a clustered primary key formed by a bigint and a datetime value. In the datetime value we would save System.DateTime.Now but sometimes we have a primary key error. Here is the code for creating table /****** Oggetto: Table [dbo].[Errori] Data script: 10/21/2009 12:37:48 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_...
Started 4 weeks ago (2009-10-14 12:59:00)
by soujanya554
Hi, I am not able to handle the bigint data type to vbscript. any ideas? Moved by Reed Kimble Wednesday, October 14, 2009 2:37 PM VB Script (From:Visual Basic Language)
Started 3 days, 2 hours ago (2009-11-09 09:06:00)
by nimesh
Hello Everyone I have a dimension called DIM_REFERER_MASTER with following columns referer_id bigint referer nvarchar(2048) referring_term nvarchar(1024) Here referer_id is the key column and referer is the name column. referring_term is an attribute. referring_term is a substring extracted from referer For eg: If referer is http://www.google.com/search?q=travel then referring_term = travel...
Started 3 days, 2 hours ago (2009-11-09 09:15:00)
by nimesh
Hello Everyone I have a dimension called DIM_REFERER_MASTER with following columns referer_id bigint referer nvarchar(2048) referring_term nvarchar(1024) Here referer_id is the key column and referer is the name column. referring_term is an attribute. referring_term is a substring extracted from referer For eg: If referer is http://www.google.com/search?q=travel then referring_term = ...
Started 1 week ago (2009-11-05 08:48:00)
by Steven J Jowett
I have 2 tables, Products and Receipts. In need to select all rows in the Products table and link it to the Receipts tables where the ReceiptId equals a given value. Products Table --------------- ProductId BIGINT Receipts Table -------------- ReceiptId BIGINT ProductId BIGINT Quantity DECIMAL( 15 , 4 ) If I execute a SELECT query on the products table I get 126 rows returned If I ...
Started 1 day, 1 hour ago (2009-11-11 09:28:00)
by mjackson11
We have very large tables of price data that need to be searched efficiently. The table consists of id - bigint (Primary Key w/ clustered index) iCurve - bigint - links to a small table defining price curves dtFwdDate - forward date dtEffDate - effective date fValue - price The usual search is SELECT fValue FROM table WHERE iCurve = 1 AND dtFwdDate='01/01/2010' AND dtEffDate='11/11/2009' I...
Started 3 days, 2 hours ago (2009-11-09 08:59:00)
by Nimesh Shah
Hello Everyone I have a dimension called DIM_referer_MASTER with following columns referer_id bigint referer nvarchar(2048) referring_term nvarchar(1024) Here referer_id is the key column and referer is the name column. referring_term is an attribute. referring_term is a substring extracted from referer For eg: If referer is http://www.google.com/search?q=travel then referring_term = ...
Started 1 day, 17 hours ago (2009-11-10 17:24:00)
by TatyanaS
The Data Collection jobs which uploads the Query Statistics information errors continually due to a bigint calculation which leads to "Arithmetic overflow error converting expression to data type int." The data collector log has the following messages: SSIS error. Component name: DFT - Create Interesting Queries Last Snapshot, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: ...
Started 1 day, 22 hours ago (2009-11-10 12:24:00)
by nimesh
Hello Everyone I have a dimension called DIM_REFERER_MASTER with following columns referer_id bigint referer nvarchar(2048) referring_term nvarchar(1024) Here referer_id is the key column and referer is the name column. referring_term is an attribute. referring_term is a substring extracted from referer...
Started 1 day, 22 hours ago (2009-11-10 12:25:00)
by nimesh
Hello Everyone I have a dimension called DIM_REFERER_MASTER with following columns referer_id bigint referer nvarchar(2048) referring_term nvarchar(1024) Here referer_id is the key column and referer is the name column. referring_term is an attribute. referring_term is a substring extracted from referer...
Started 1 week ago (2009-11-05 06:12:00)
by funsize999
Hi, I've got a bit of a strange problem. First, a little background. I've written a class bigInt that is a pointer to a linked list. I've written quite a few functions for it, but the two in question are: Code: void bigInt::readBigInt() { int number; string digitString; cin >> digitString; makeEmpty(firstp); for(unsigned int i = 0; i < digitString.length(); i++) ...
Started 5 days, 10 hours ago (2009-11-07 00:23:00)
by saperlipopeye
Je sais c'est bizarre au vu des limites des bigint ... normalement il n ya pas d'erreur dans mon code puisque c'est quelque chose de redondant(je l'utilise la fonction 4 fois au dessus et ça marche puis à la cinquieme sa bloque sur ce chiffre) voici un bout de ce code en sql Code : mysql_query ( 'SELECT id_categorie FROM categorie WHERE id_categorie > 99999999 AND id_categorie< ...
