Viewing 15 posts - 1,621 through 1,635 (of 2,462 total)
First of all very less descripttion provided. Anyways use
DML insert trigger
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 9, 2010 at 11:29 pm
no that columns dont contain any data
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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 ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 7, 2010 at 12:45 am
clucasi (6/4/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 4, 2010 at 2:16 am
Nils Gustav Stråbø (6/3/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 4, 2010 at 2:11 am
PradeepVallabh (6/3/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 3, 2010 at 6:27 am
malachyrafferty (6/3/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 3, 2010 at 6:18 am
you can do one thing
1. create a intermediate table
2. insert
SELECT @msg = ISNULL(@msg+CHAR(10),'')
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 3, 2010 at 6:15 am
Viewing 15 posts - 1,621 through 1,635 (of 2,462 total)