Viewing 15 posts - 1,621 through 1,635 (of 2,463 total)
Match the column's datatype in both destination and source tables
June 11, 2010 at 4:45 am
First of all very less descripttion provided. Anyways use
DML insert trigger
June 10, 2010 at 1:17 am
cfradenburg (6/7/2010)
I would try creating an index on table1 for nme including recognizer. On table2 index recognizer, value_nme and include char_value.
i do agree with it
June 10, 2010 at 12:12 am
Which would be the better option ?
1. USE ALTER TABLE ....ALTER COLUMN approach
2. Create new table and then push the exisitng table's data into it.
and does sql...
June 9, 2010 at 11:29 pm
no that columns dont contain any data
June 9, 2010 at 10:38 pm
GilaMonster (6/7/2010)
you need to understand what both are and not worry about how they're linked.
that is golden point ...thanks 🙂
June 7, 2010 at 6:16 am
GilaMonster (6/7/2010)
Fragmentation is related to the physical and logical ordering of the pages of an index within the data file
yes got the point but whenever we have DML...
June 7, 2010 at 5:50 am
sqlguy-549681 (6/7/2010)
I have a problem with Disks (Read\Write)
whats resolution have you made for it ?
June 7, 2010 at 4:26 am
guruprasadurs (6/4/2010)
I want know how to do backup task in remote location
exec master..xp_cmdshell ' COPY source path + file name destination path' better google for same command.
June 7, 2010 at 12:45 am
clucasi (6/4/2010)
June 4, 2010 at 2:16 am
Nils Gustav Stråbø (6/3/2010)
June 4, 2010 at 2:11 am
PradeepVallabh (6/3/2010)
June 4, 2010 at 1:53 am
malachyrafferty (6/3/2010)
as you say its done line by line
DML triggers work on per line basis
June 3, 2010 at 10:52 pm
first copy the bak file on local drive then move it to desired location by "COPY" Command Prompt command
June 3, 2010 at 6:27 am
malachyrafferty (6/3/2010)
June 3, 2010 at 6:18 am
Viewing 15 posts - 1,621 through 1,635 (of 2,463 total)