Viewing 15 posts - 46 through 60 (of 63 total)
In that case the very purpose of constraints itself is questioned, each time you have to see in the lookup table means even you can avoid the constraint as a...
October 15, 2003 at 2:17 am
Are all agreeing that there is no structured exception handling in SQL?
October 14, 2003 at 8:32 am
Thank you all for overwhelming response to my somewhat foolish question, But if some one knows what exactly the DUMP and LOAD (SQL 6.5 ) statements where doing ,What ever...
October 14, 2003 at 8:01 am
Let me clarify the topic once again
I am not doing anything with the data just inserting from one table to another
Like
Insert into Table1 (po_no,po_date...
July 8, 2003 at 11:12 pm
One curious error we are getting in the procedure 3,its in an insert statement which is includes a select statement date time out of range.
The interesting thing is there is...
July 8, 2003 at 8:47 am
SQL server supports altering a numeric colum to increase size ?,I cant drop the table even for minutes
john
July 5, 2003 at 10:13 am
raiserror('Invalid Plant Allocation',16,2 )
the system failes in the the ,conditional statement not in the raiserror()
Will one cast in the in if () will solve the problem ,
Problem is serious...
July 1, 2003 at 3:15 am
Normally such operations are required for data warehousing sort of applications. But even there we can better represent information using some statistical ideas like summing, frequency table etc. If you...
June 25, 2003 at 4:01 am
If any one have got references to problems with SQLSrver upgrading please share with me,In our case it seems to be a never ending process ,correcting errors one bye...
June 22, 2003 at 11:57 pm
ReallyReally I wrote something with out seeing the actual question ,
In general if you want to add more columns go for joins ,
Why all are complicating elementary things (including...
June 20, 2003 at 9:00 am
With the following assumptions I am trying to answer the nikels question ,
Accounts table is some thing like
Cretate table Accounts
(
acccountid int ,
cc_type ...
June 20, 2003 at 12:38 am
With the following assumptions I am trying to answer the nikels question ,
Accounts table is some thing like
Cretate table Accounts
(
acccountid int ,
cc_type ...
June 20, 2003 at 12:28 am
Dear friend
Let me know one thing, are you trying for client side cursors or disconnected record sets. In that case I better suggest the use of DB library...
May 29, 2003 at 10:03 am
Hay dear ones,
Cursors are really easy to understand, but for queries taking ours together to complete may create problem, through out this time we have to block our users in...
May 26, 2003 at 10:15 am
Viewing 15 posts - 46 through 60 (of 63 total)