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 |
|
DENIZ3E
Yak Posting Veteran
56 Posts |
 Posted - 2005-01-14 : 17:47:23
|
| HOW I USE DATEFIRST IN WIEW? |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2005-01-14 : 19:53:32
|
| What do you want to do with it?create view MyViewasselect @@DateFirstHTH=================================================================Scriptures, n. The sacred books of our holy religion, as distinguished from the false and profane writings on which all other faiths are based.-Ambrose Bierce, writer (1842-1914) [The Devil's Dictionary] |
 |
|
|
DENIZ3E
Yak Posting Veteran
56 Posts |
Posted - 2005-01-15 : 17:25:00
|
| -----create view V1AS@@DATEFIRST DATEFIRST 1SELECT DATEPART(WW,GETDATE())--------OK? |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2005-01-15 : 17:49:01
|
quote:
Originally posted by DENIZ3E
-----create view V1AS@@DATEFIRST DATEFIRST 1SELECT DATEPART(WW,GETDATE())--------OK?
No, it's not OK. |
|
|
|
DENIZ3E
Yak Posting Veteran
56 Posts |
Posted - 2005-01-15 : 18:01:32
|
| PLEASE HELPHOW I CAN USE |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2005-01-15 : 19:42:42
|
| You can't. See the syntax in SS help. |
|
|
|
DENIZ3E
Yak Posting Veteran
56 Posts |
Posted - 2005-01-16 : 08:38:12
|
| CREATE VIEW V1AS SELECT DATEPART(WW,GETDATE()),* FROM TABLE----------------SET DATEFIRST 6SELECT * FROM V1 IS OK? |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2005-01-16 : 09:25:49
|
quote:
Originally posted by DENIZ3E
SET DATEFIRST 6SELECT * FROM V1 IS OK?
Yes. |
|
|
|
DENIZ3E
Yak Posting Veteran
56 Posts |
Posted - 2005-01-16 : 13:34:42
|
| thank you |
|
|
|
|
|
|
DATEFIRST