Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pramod21
Yak Posting Veteran
64 Posts |
 Posted - 2011-03-18 : 01:39:25
|
| Hi,I'm inserting a value in string variable.I have two tables abc and xyz.i'm inserting a data from abc table to xyz. my query is something like this;set qry="insert into xyz(a,update) select b,getdate()from abc"now my doubt is when it is inserting getdate() value in to update column, for all the rows it is showing the same date time.my question is time should be difference for atleast microsecond.but it is showing the same time. |
|
|
vaibhavktiwari83
Aged Yak Warrior
843 Posts |
Posted - 2011-03-18 : 03:39:57
|
| It depends upon number of records. If number of records are very large in amount then it will show difference after a set of records, which again will be of miliseconds.Vaibhav TIf I cant go back, I want to go fast... |
 |
|
|
alexdeva7
Starting Member
2 Posts |
|
|
|
|
|
inserting data into a string variable from table.