HiI've had to do a project in SQL Server and, although I haven't encountered it yet, I'm curious. In MySQL you can say 'limit 50, 50' to start at the 50th record and return 50 records, i.e. returns records 50 - 100. How do you do the same with SQL Server? I know about top […]
2005-02-08
49 reads
2005-02-01
select * from table where DBDate between '01/28/2005' and '01/29/2005'You just have to remember that '01/28/2005' really means '01/28/2005 00:00:00.000' when compared to a datetime.Greg
2005-01-28
Please don't cross post. all forums are covered. Answered in other post.
2004-12-03
if you have small memory on your computer (server), the best solution is to adjust SQL Server memory and make it FIXEDso in Enterprise manager do this: 1- right clcick on your server and choose (properties) 2- go to memory tab 3- check on (use a fixed memory size) and alocate it in trackbar under […]
2004-10-05
Hey, Back online.I hope everything went just as smooth as you planned it. Seems good over here. Nice job.
2004-09-19
By Rob Sewell
Whether you’re a developer at an agency or an aspiring creator, you can trust...
“Could you help me, we deleted the database’s transaction log file and now that...
I had a couple of clients who were moving content from development catalogs to...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers