|
Dan_P wrote:
I'm not sure if MSDE has this same service, it might have?
AFAIK, SQL Server Agent is present in MSDE, but I think I'll have to create the backup plan by hand. I remember seeing an article in MSDN but I can't find it.
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
Hi,
I backup my SQL server database to deploy it to another computer. But i don't know that how to restore it on the other computer. What r the steps.
Kindly help me in this regard.
Bye
EsHbAn BaHaDuR
|
|
|
|
|
* Copy the backup file on to the other computer
* In Enterprise Manager, open the tree on to the SQL Server instance running on the other computer (you may have to register the other SQL Server with your local Enterprise Manager if it is not already there - alternatively go to the Enterprise Manager on the other computer)
* Right click on the databases folder icon in Enterprise manager and select All Tasks-->Restore Database
My: Blog | Photos | Next SQL Presentation
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
You went to Action/All Tasks/Backup Database to back it up, just underneath Backup Database, it says Restore Database. 
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
How get error description (message) associated with @@Error
When i use the FORMATMESSAGE function it's allways returns NULL.
Any ideas ???
------------------------------------
To study, study and only to study
|
|
|
|
|
You can lookup the sysmessages table with the errorID
|
|
|
|
|
However how can i know the details of the error such where it occurs in which line. I need something like i get in sql query analyzer.
------------------------------------
To study, study and only to study
|
|
|
|
|
I'm trying to bind a picture box to my access 2002 Db in vb.net
Here is my code
Dim b As Binding = New Binding("Image", dsComics, "comiclist.ComicCover")<br />
AddHandler b.Format, AddressOf ConvertPicture<br />
Me.picCover.DataBindings.Add(b)<br />
<br />
<br />
<br />
Public Sub ConvertPicture(ByVal Sender As Object, ByVal e As ConvertEventArgs)<br />
Dim b() As Byte = e.Value<br />
Dim ms As MemoryStream = New MemoryStream<br />
ms.Write(b, 0, b.Length)<br />
Dim bmp As Bitmap = New Bitmap(ms)<br />
ms.Close()<br />
e.Value = bmp<br />
<br />
<br />
End Sub
The line in bold is where it bombs, any ideas
BINARY
BINARY
|
|
|
|
|
What is the error message ?
|
|
|
|
|
An unhandled exception of type 'System.ArgumentException' occurred in system.drawing.dll
Additional information: Invalid parameter used.
BINARY
|
|
|
|
|
Are you sure it doesn't bomb on ms.Close().
The docs for the Bitmap(Stream stream) constructor say:
You must keep the stream open for the lifetime of the Bitmap object.
|
|
|
|
|
It may bomb there as well but I haven't gotten that far
BINARY
|
|
|
|
|
Hello,
I have the following stored procedure:
DECLARE @@Cuenta int;
SELECT @@Cuenta = COUNT(*) FROM Recibos_Reimpresiones GROUP BY ID_recibo HAVING (ID_recibo = @ID_recibo);
SET @@Cuenta = @@Cuenta + 1;
INSERT INTO dbo.Recibos_Reimpresiones (ID_recibo, Reimpresion, ID_sesion, FechaHora)
VALUES (@ID_recibo, @@Cuenta, @ID_sesion, GETDATE())
UPDATE Recibos
SET Reimpresiones = (@@Cuenta)
WHERE (ID_recibo = @ID_recibo)Basically what it's trying to do is to get the number of reprintings from the Recibos_Reimpresiones table. If should contain no rows (for a receipt) if it has only been printed once.
When I try to reprint a receipt, a record should be added to this table, stating the number of receipt, and the reprinting number (the first reprinting being one.) Also, the reprint count in the receipt record in Recibos should be updated.
But when I try to run this stored procedure, I get an error saying that the Reimpresion field of the Recibos_Reimpresiones table does not allow NULLs and that the record could not be inserted. That means that @@Cuenta is NULL, and it should be an integer.
So, anyone knows what's happening here? Does COUNT(*) return NULL instead of 0 if no records are present? Ideas on how to fix it?
Thanks!
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
You're assuming too much here. I'd be running the first two lines, and then see what your count value is. No, COUNT does not return NULL for 0. Figure out what the count value is, then figure out what the value of your variable is ( I don't see how they could differ ), then keep adding a line at a time, and check to see what each line is doing.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Actually it was returning NULL. So, I fixed it adding this:
IF @@Cuenta IS NULL
SET @@Cuenta = 0;
SET @@Cuenta = @@Cuenta + 1;and now everything works as expected.
At the time I had not a single record in the table, but now that I have some records, I try with a receipt number that has not been reprinted, and it still returns NULL.
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
Luis Alonso Ramos wrote:
GROUP BY ID_recibo HAVING (ID_recibo = @ID_recibo);
This looks a bit odd to me. When looking for a single return value with an aggregate I've never used a GROUP BY because that is likely to return multiple values. Of course, the HAVING clause will reduce that back to one or zero results.
It would be better to say:
SELECT @@Cuenta = COUNT(*)
FROM Recibos_Reimpresiones
WHERE ID_recibo = @ID_recibo because this is guaranteed to return exactly one result every time, even if there are no records. This would mean that you could get rid of your IF statement that checks if @Cuenta is NULL
Does this help?
My: Blog | Photos | Next SQL Presentation
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
Colin Angus Mackay wrote:
This looks a bit odd to me.
I'm using Access to design most of my stored procedures, and using GROUP BY is the only way I know of using aggregate functions with Access UI (of course, you can always write the SQL code yourself.)
But as this project I'm working in right now grows, I'm writing more and more complex stored procedures, mainly thanks to your teachings here!! thanks!
I just tried your code and it seems to work fine. Thanks again!
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
|
i fail to install mysql coz of this
how to solve this??
make all-recursive
make[1]: Entering directory `/root/mysql-3.23.54a'
Making all in include
make[2]: Entering directory `/root/mysql-3.23.54a/include'
make all-am
make[3]: Entering directory `/root/mysql-3.23.54a/include'
make[3]: Nothing to be done for `all-am'.
make[3]: Leaving directory `/root/mysql-3.23.54a/include'
make[2]: Leaving directory `/root/mysql-3.23.54a/include'
Making all in Docs
make[2]: Entering directory `/root/mysql-3.23.54a/Docs'
make all-am
make[3]: Entering directory `/root/mysql-3.23.54a/Docs'
make[3]: Nothing to be done for `all-am'.
make[3]: Leaving directory `/root/mysql-3.23.54a/Docs'
make[2]: Leaving directory `/root/mysql-3.23.54a/Docs'
Making all in readline
make[2]: Entering directory `/root/mysql-3.23.54a/readline'
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory `/root/mysql-3.23.54a/readline'
Making all in libmysql
make[2]: Entering directory `/root/mysql-3.23.54a/libmysql'
source='libmysql.c' object='libmysql.lo' libtool=yes \
depfile='.deps/libmysql.Plo' tmpdepfile='.deps/libmysql.TPlo' \
depmode=gcc3 /bin/sh ../depcomp \
/bin/sh ../libtool --mode=compile gcc
-DDEFAULT_CHARSET_HOME="\"/usr/local/mysql\""
-DDATADIR="\"/usr/local/mysql/var\""
-DSHAREDIR="\"/usr/local/mysql/share/mysql\"" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c -o libmysql.lo `test -f libmysql.c || echo
'./'`libmysql.c
rm -f .libs/libmysql.lo
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\"
-DDATADIR=\"/usr/local/mysql/var\"
-DSHAREDIR=\"/usr/local/mysql/share/mysql\" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c libmysql.c -MT libmysql.lo -MD -MP -MF
.deps/libmysql.TPlo -fPIC -DPIC -o .libs/libmysql.lo
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\"
-DDATADIR=\"/usr/local/mysql/var\"
-DSHAREDIR=\"/usr/local/mysql/share/mysql\" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c libmysql.c -MT libmysql.lo -MD -MP -MF
.deps/libmysql.TPlo -o libmysql.o >/dev/null 2>&1
mv -f .libs/libmysql.lo libmysql.lo
source='net.c' object='net.lo' libtool=yes \
depfile='.deps/net.Plo' tmpdepfile='.deps/net.TPlo' \
depmode=gcc3 /bin/sh ../depcomp \
/bin/sh ../libtool --mode=compile gcc
-DDEFAULT_CHARSET_HOME="\"/usr/local/mysql\""
-DDATADIR="\"/usr/local/mysql/var\""
-DSHAREDIR="\"/usr/local/mysql/share/mysql\"" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c -o net.lo `test -f net.c || echo './'`net.c
rm -f .libs/net.lo
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\"
-DDATADIR=\"/usr/local/mysql/var\"
-DSHAREDIR=\"/usr/local/mysql/share/mysql\" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c net.c -MT net.lo -MD -MP -MF .deps/net.TPlo
-fPIC -DPIC -o .libs/net.lo
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\"
-DDATADIR=\"/usr/local/mysql/var\"
-DSHAREDIR=\"/usr/local/mysql/share/mysql\" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c net.c -MT net.lo -MD -MP -MF .deps/net.TPlo -o
net.o >/dev/null 2>&1
mv -f .libs/net.lo net.lo
source='password.c' object='password.lo' libtool=yes \
depfile='.deps/password.Plo' tmpdepfile='.deps/password.TPlo' \
depmode=gcc3 /bin/sh ../depcomp \
/bin/sh ../libtool --mode=compile gcc
-DDEFAULT_CHARSET_HOME="\"/usr/local/mysql\""
-DDATADIR="\"/usr/local/mysql/var\""
-DSHAREDIR="\"/usr/local/mysql/share/mysql\"" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c -o password.lo `test -f password.c || echo
'./'`password.c
rm -f .libs/password.lo
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\"
-DDATADIR=\"/usr/local/mysql/var\"
-DSHAREDIR=\"/usr/local/mysql/share/mysql\" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c password.c -MT password.lo -MD -MP -MF
.deps/password.TPlo -fPIC -DPIC -o .libs/password.lo
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\"
-DDATADIR=\"/usr/local/mysql/var\"
-DSHAREDIR=\"/usr/local/mysql/share/mysql\" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c password.c -MT password.lo -MD -MP -MF
.deps/password.TPlo -o password.o >/dev/null 2>&1
mv -f .libs/password.lo password.lo
source='get_password.c' object='get_password.lo' libtool=yes \
depfile='.deps/get_password.Plo' tmpdepfile='.deps/get_password.TPlo' \
depmode=gcc3 /bin/sh ../depcomp \
/bin/sh ../libtool --mode=compile gcc
-DDEFAULT_CHARSET_HOME="\"/usr/local/mysql\""
-DDATADIR="\"/usr/local/mysql/var\""
-DSHAREDIR="\"/usr/local/mysql/share/mysql\"" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c -o get_password.lo `test -f get_password.c
|| echo './'`get_password.c
rm -f .libs/get_password.lo
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\"
-DDATADIR=\"/usr/local/mysql/var\"
-DSHAREDIR=\"/usr/local/mysql/share/mysql\" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c get_password.c -MT get_password.lo -MD -MP -MF
.deps/get_password.TPlo -fPIC -DPIC -o .libs/get_password.lo
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\"
-DDATADIR=\"/usr/local/mysql/var\"
-DSHAREDIR=\"/usr/local/mysql/share/mysql\" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c get_password.c -MT get_password.lo -MD -MP -MF
.deps/get_password.TPlo -o get_password.o >/dev/null 2>&1
mv -f .libs/get_password.lo get_password.lo
/bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -rdynamic -o
libmysqlclient.la -rpath /usr/local/mysql/lib/mysql -version-info
10 libmysql.lo net.lo violite.lo password.lo get_password.lo
errmsg.lo my_init.lo my_static.lo my_malloc.lo my_realloc.lo
my_create.lo my_delete.lo mf_tempfile.lo my_open.lo mf_casecnv.lo
my_read.lo my_write.lo errors.lo my_error.lo my_getwd.lo my_div.lo
mf_pack.lo my_messnc.lo mf_dirname.lo mf_fn_ext.lo mf_wcomp.lo
typelib.lo safemalloc.lo my_alloc.lo mf_format.lo mf_path.lo
mf_unixpath.lo my_fopen.lo my_symlink.lo my_fstream.lo mf_loadpath.lo
my_pthread.lo my_thr_init.lo thr_mutex.lo mulalloc.lo string.lo
default.lo my_compress.lo array.lo my_once.lo list.lo my_net.lo
charset.lo hash.lo mf_iocache.lo my_seek.lo my_pread.lo mf_cache.lo
my_gethostbyname.lo my_port.lo getopt.lo getopt1.lo getvar.lo my_lib.lo
strmov.lo strxmov.lo strnmov.lo strmake.lo strend.lo strnlen.lo
strfill.lo is_prefix.lo int2str.lo str2int.lo strinstr.lo strcont.lo
strcend.lo bchange.lo bmove.lo bmove_upp.lo longlong2str.lo strtoull.lo
strtoll.lo llstr.lo ctype.lo dbug.lo -lz -lcrypt -lnsl -lm
rm -fr .libs/libmysqlclient.la .libs/libmysqlclient.*
.libs/libmysqlclient.*
gcc -shared libmysql.lo net.lo violite.lo password.lo get_password.lo
errmsg.lo my_init.lo my_static.lo my_malloc.lo my_realloc.lo
my_create.lo my_delete.lo mf_tempfile.lo my_open.lo mf_casecnv.lo
my_read.lo my_write.lo errors.lo my_error.lo my_getwd.lo my_div.lo
mf_pack.lo my_messnc.lo mf_dirname.lo mf_fn_ext.lo mf_wcomp.lo
typelib.lo safemalloc.lo my_alloc.lo mf_format.lo mf_path.lo
mf_unixpath.lo my_fopen.lo my_symlink.lo my_fstream.lo mf_loadpath.lo
my_pthread.lo my_thr_init.lo thr_mutex.lo mulalloc.lo string.lo
default.lo my_compress.lo array.lo my_once.lo list.lo my_net.lo
charset.lo hash.lo mf_iocache.lo my_seek.lo my_pread.lo mf_cache.lo
my_gethostbyname.lo my_port.lo getopt.lo getopt1.lo getvar.lo my_lib.lo
strmov.lo strxmov.lo strnmov.lo strmake.lo strend.lo strnlen.lo
strfill.lo is_prefix.lo int2str.lo str2int.lo strinstr.lo strcont.lo
strcend.lo bchange.lo bmove.lo bmove_upp.lo longlong2str.lo strtoull.lo
strtoll.lo llstr.lo ctype.lo dbug.lo -lz -lcrypt -lnsl -lm
-Wl,-soname -Wl,libmysqlclient.so.10 -o .libs/libmysqlclient.so.10.0.0
(cd .libs && rm -f libmysqlclient.so.10 && ln -s
libmysqlclient.so.10.0.0 libmysqlclient.so.10)
(cd .libs && rm -f libmysqlclient.so && ln -s libmysqlclient.so.10.0.0
libmysqlclient.so)
ar cru .libs/libmysqlclient.a libmysql.o net.o violite.o password.o
get_password.o errmsg.o my_init.o my_static.o my_malloc.o my_realloc.o
my_create.o my_delete.o mf_tempfile.o my_open.o mf_casecnv.o my_read.o
my_write.o errors.o my_error.o my_getwd.o my_div.o mf_pack.o
my_messnc.o mf_dirname.o mf_fn_ext.o mf_wcomp.o typelib.o safemalloc.o
my_alloc.o mf_format.o mf_path.o mf_unixpath.o my_fopen.o my_symlink.o
my_fstream.o mf_loadpath.o my_pthread.o my_thr_init.o thr_mutex.o
mulalloc.o string.o default.o my_compress.o array.o my_once.o list.o
my_net.o charset.o hash.o mf_iocache.o my_seek.o my_pread.o mf_cache.o
my_gethostbyname.o my_port.o getopt.o getopt1.o getvar.o my_lib.o
strmov.o strxmov.o strnmov.o strmake.o strend.o strnlen.o strfill.o
is_prefix.o int2str.o str2int.o strinstr.o strcont.o strcend.o
bchange.o bmove.o bmove_upp.o longlong2str.o strtoull.o strtoll.o
llstr.o ctype.o dbug.o
ranlib .libs/libmysqlclient.a
creating libmysqlclient.la
(cd .libs && rm -f libmysqlclient.la && ln -s ../libmysqlclient.la
libmysqlclient.la)
make[2]: Leaving directory `/root/mysql-3.23.54a/libmysql'
Making all in client
make[2]: Entering directory `/root/mysql-3.23.54a/client'
source='mysql.cc' object='mysql.o' libtool=no \
depfile='.deps/mysql.Po' tmpdepfile='.deps/mysql.TPo' \
depmode=gcc3 /bin/sh ../depcomp \
g++ -DUNDEF_THREADS_HACK -I. -I. -I.. -I./../include -I../include
-I./.. -I.. -I.. -O3 -DDBUG_OFF -fno-implicit-templates
-fno-exceptions -fno-rtti -c -o mysql.o `test -f mysql.cc || echo
'./'`mysql.cc
/bin/sh ../libtool --mode=link g++ -O3 -DDBUG_OFF
-fno-implicit-templates -fno-exceptions -fno-rtti -rdynamic -o mysql
mysql.o readline.o sql_string.o completion_hash.o
../readline/libreadline.a -lncurses ../libmysql/libmysqlclient.la -lz
-lcrypt -lnsl -lm
g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti
-rdynamic -o .libs/mysql mysql.o readline.o sql_string.o
completion_hash.o ../readline/libreadline.a -lncurses
../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm -Wl,--rpath
-Wl,/usr/local/mysql/lib/mysql
mysql.o(.text+0x189c): In function `com_source(String*, char*)':
: undefined reference to `errno'
collect2: ld returned 1 exit status
make[2]: *** [mysql] Error 1
make[2]: Leaving directory `/root/mysql-3.23.54a/client'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/root/mysql-3.23.54a'
make: *** [all] Error 2
|
|
|
|
|
I have three tables:
- Article
- Album
- linkArticleAlbum
I want get a list of all the albums and also have some way of determining whether it is linked to the currently selected article.
What I WANT to do is something like
SELECT
linkArticleAlbum.Article,
Album.ID,
Album.Title
FROM Album LEFT JOIN linkArticleAlbum ON linkArticleAlbum.Album = Album.ID
WHERE linkArticleAlbum.Article = 7 OR linkArticleAlbum.Article IS NULL
Here's what my sample data looks like
Album
------
| ID |
1
2
3
Article
-------
| ID |
7
8
9
linkArticleAlbum
------------------
| Article | Album
7 1
8 1
9 2
As you can see, I won't get a record with Album 2 since my WHERE clause eliminates it.
I'm stuck. Advise anything, including a redesign of my DB. I've apparently done something stupid and my murky brain can't figure it out right now.
········ to die is gain ········
|
|
|
|
|
Well, you haven't done anything clearly wrong in your database design, but your query needs some help. If you include a WHERE clause, only the rows that satisfy the condition will be listed, so LEFT JOINing won't help.
If it's really important to have the results indicate whether the album is linked to the selected article, this would probably do the trick:
SELECT <br />
al.ID, <br />
al.Title, <br />
l.Article, <br />
IIf([l].[Article] Is Not Null AND l.Article = [article ID],"Linked","Unlinked") AS IsLinked<br />
FROM <br />
Album AS al LEFT JOIN linkArticleAlbum AS l <br />
ON al.ID = l.Album;
Given your setup, where a single Album may be associated with many Articles, you should be aware that you may get multiple results for a single Album (from your example, Album 1 would appear twice in the results).
If you don't care about indicating in the results whether the Album is linked (i.e. you want to handle that in code) then the query is even shorter:
SELECT <br />
al.ID, <br />
al.Title, <br />
l.Article<br />
FROM <br />
Album AS al LEFT JOIN linkArticleAlbum AS l <br />
ON al.ID = l.Album;
Hope this helps.
The most exciting phrase to hear in science, the one that heralds the most discoveries, is not 'Eureka!' ('I found it!') but 'That's funny...’
|
|
|
|
|
Thanks for the help.
The example does help to some degree, but in one iteration of my attempts I achieved essentially the same thing.
To clarify, I would prefer to have each Album appear only once. With the current queries, each album shows up at least once, but will appear as many times as it is referenced in the linkArticleAlbum table.
Can I eliminate the duplicates while ensuring that I can test for l.Article = [article ID]???
|
|
|
|
|
Hi
I'm using access db and i want to get records that falls between spesific time period through VB. My sql does not work with time comparition.
..... WHERE sTime >= #8:30 AM# AND eTime < #10:30 AM#...
I also found that when i check the fields from VB, my time fields in DB do not show time but dates...
Please help me to solve the problem..
Thanks
Leelanga
|
|
|
|
|
You can transfer time into minutes using DATEPART function and use this value
As example:
DATEPART(month, GETDATE())
syntax: DATEPART ( datepart , date )
datepart name or abbreviation:
hour - hh
minute - mi, n
second - ss, s
millisecond - ms
You can use it that way:
WHERE DATEPART ( mi, sTime ) +DATEPART ( hh, sTime ) *60
>= DATEPART ( mi, #8:30 AM#) +DATEPART ( hh, #8:30 AM#) *60
AND
DATEPART ( mi, eTime ) +DATEPART ( hh, eTime) *60
<
DATEPART ( mi, #10:30 AM#) +DATEPART ( hh, #10:30 AM#) *60
Not a beatiful code, but it's works.
Also, You can use user-defined function to increase readability.
Hope, this helps.
Happy coding, Alexey.
|
|
|
|
|
Thanx Alexey...it's grate, i didn't know that before
Leelanga
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
