Viewing 15 posts - 91 through 105 (of 238 total)
I think you need to use the BIGINT datatype. To enforce >0 and <4,294,967,295 rule you need to put a constraint on the column. Otherwise just let it accept any...
March 4, 2003 at 6:14 pm
A constraint is added to the column definition like this:
CREATE TABLE table_name (
abc int NOT NULL
CONSTRAINT constraint_name UNIQUE CLUSTERED
)
An index is created separately from the table definition...
March 4, 2003 at 6:04 pm
Look for functions to manipulate with strings in SQL Server Books Online. There are functions like substring, left, right, replace, stuff, etc.
March 4, 2003 at 5:05 pm
I do the same thing as David Burrows describes. I script all tables, vies, indexes, triggers, procedures, UDF, UDT, etc, etc. and store it all in VSS.
February 28, 2003 at 10:23 am
Coma does not make any difference here. What error message are you getting?
February 27, 2003 at 5:47 pm
Dear Competitor (yes, I am also working with schools, teachers, classes and scores in my DB):
I think you should take results of your first query, put it into a temp...
February 26, 2003 at 5:52 pm
quote:
I've always disliked the use of the singular object. You can end up with syntax such as "Employee.Employee".
February 26, 2003 at 5:31 pm
Billy
I think there are several ways. One would be to go through Import wizard, create a job from it and call that job programmatically.
Another way is to use sp_helptext to...
February 26, 2003 at 12:19 pm
I home you are using version 7 or 2000. Then go to your database in Enterprise Manager, expand it and find the Diagrams icon. Right-click on it and click on...
February 26, 2003 at 11:50 am
It seems you want something like this:
select @id = MAX( field1 ) from tableName
, @row_count = 1
while @row_count > 0
begin
select top 1 @id...
February 26, 2003 at 11:26 am
Tomi, it surely is a screen shot (part of the screen, of course) from a diagram one can make with the SQL Server itself. It is unlikely a third-party tool...
February 26, 2003 at 11:13 am
I would not recommend going this route. It is "tricky" and not "clean".
If you need special behavior in the trigger for the updated records, create a flag column in your...
February 26, 2003 at 10:54 am
Dan, run SELECT @@SERVERNAME to find the name of your server. If in contains dash, put the name into square brakets: [server_name]. Finally, create a table on the destination server...
February 24, 2003 at 11:45 pm
Of course. Just qualify your names fully:
FROM server_name.db_name.owner_name.table_name
where server_name will include the instance specification.
February 24, 2003 at 12:53 pm
Here is an idea for you. It will output 1 or 0 depending on whether spouse or child exists or not. It is up to you, of course, to replace...
February 24, 2003 at 12:48 pm
Viewing 15 posts - 91 through 105 (of 238 total)