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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-30 : 09:34:30
|
| Sherry writes "I use DTS import wizard to import table and data between 2 SQL Server db. All of the tables & data can complete transfer from one to another without any problem. But the user view in source db is also transfered into destination db table space. it looks like a table instead of view now. How do I transfer view from source view location into the destination view location?Thanks for your July 18 reply. Following your instruction, I add default value in my "LoginDate" field with "convert(char(8),getdate(),112)". I got the date only. Great! But I add default value in my "LoginTime" field with "convert(varchar(8), getdate(), 108)", I got "1/1/1900 954:55 AM". I need time only. How can I do it? Both of "LoginDate" and "LoginTime" have "datetime" data type with length 8. Thanks a lot.Sherry" |
|
|
|
|
|
DTS and Time conversion question