Viewing 15 posts - 406 through 420 (of 670 total)
The cast is only allowing numbers less than 10000, so increase the cast to 9,4 or 10,4, etc..
February 10, 2011 at 9:09 am
autoexcrement (2/7/2011)
February 9, 2011 at 2:41 pm
you can't change it to an identity column as is. you can rename the table, create a new one with the identity column and then insert the old records...
February 9, 2011 at 2:34 pm
What are you trying to do and why is this a poll? If you specify why, we can try to help. Foreign keys are in place to insure...
February 9, 2011 at 2:26 pm
what is the table definition? instead of running the update statement, select (100percentrecon/sumofvissits) *100 from the table to see what you get. If the 2 fields are integers,...
February 9, 2011 at 1:45 pm
dave,
I think your solution will skew the results since a memberid of A, B, and C will be split out into 3 rows even though the OP has substituted...
February 9, 2011 at 1:36 pm
Is the file actually present on the E drive. Sometimes I get this when a SAN volume goes offline.
February 9, 2011 at 1:15 pm
there are a couple of things wrong with your code. The first is when you are checking for the memberid in A,B,C you have an extra comma after C. ...
February 9, 2011 at 1:14 pm
When you inserted 2000 rows with SSMS, did you use the proc? What is the application doing? Is it opening and closing a transaction each time or are...
February 9, 2011 at 10:56 am
the where clause is looking for a column within the table specified in the from clause. I think you're trying to use the files from the master database to...
February 9, 2011 at 10:17 am
can you provide a little more information than that? How about table layouts, how much data are you inserting, indexes on tables, how is data being inserted (Bulk Insert,...
February 9, 2011 at 10:11 am
Rich,
the problem is with the where clause. You have where name = 'master like ... This won't work as you found out. Try this:
USE [master]
GO
--Drop the Database...
February 9, 2011 at 9:53 am
Rich, one more thing. I wouldn't make the column not null since any applications writing to it probably don't know of it's existence, so won't insert any data to...
February 9, 2011 at 9:23 am
Rich,
can you run the select within the exists statement? I had to add master.. in front of sysaltfiles
February 9, 2011 at 9:21 am
Viewing 15 posts - 406 through 420 (of 670 total)