Hi Guys I'm new to SQL Server 2000 and am trying to convert some of my php code that previously used MySQL. Here's the query I'm having trouble with: SELECT *,UNIX_TIMESTAMP(lastlogin) as lastlogindate from user WHERE confirmed='1' and approved='1' and login = 'blah' AND password = PASSWORD('blah'); SQL Server doesnt like the UNIX_TIMESTAMP conversion, or […]
2005-01-05
2 reads
Yup....post the code so that we can examine it.....and get rid of the cursor.If you don't know why I'm advocating the latter route....search here for 'good performance' and 'cursor'.....the 2 phrases rarely go together!99.99% of SQL actions can be done without cursors....with a (noticable)performance boost 99.99% of the time.....
2005-01-05
2 reads
I was trying to use DTS to solve this problem, because DTS can deal with this issue, but I'm a hackboy and DTS is way over my head to automate.I could use bulk insert if I could get past one problem. My CSV data files are garbage, and I have no control over the vendor.Lets […]
2005-01-04
5 reads
I'm a hackboy. I can get some stuff done in SQL Server, but I'd probably have an easier time learning to speak German than understand DTS, LOL. Actually, I could use bulk insert if I could get past one problem. My CSV data files are garbage, and I have no control over the vendor.Lets say it […]
2005-01-04
Thanks for the help guys...yu were right on the mark with the suggested code I didnt know i could do a join like that!!I hadnt considered that I was changing the primary key, but have had a good look, and in this case, it wont have any adverse affects on the dataThanks again!Ben
2005-01-04
1 reads
sorry (duh) yep, it's the order() fn. Wrt the fn, you'll obviously not want to break the hierarchy (ie don't use Bdesc or Basc) and if you have a numeric key or a sort column (put in as member prop) this could make it easier to do the sort.if the members are all sorted OK in […]
2005-01-04
Adding the BEGIN TRAN..COMMIT isn't a big deal should be easy and BOL has decent examples.What you could do is in the SP that is being called write the information out using the @TABLE to whatever logging table you want and RETURN(@@ERROR). This should throw you down the failure path where you can exit gracefully...
2005-01-04
rockmouse thanks for the link for bcp out ... I need that for another task, this mkeast solution for this parsing issue is slick
2005-01-03
IMHO, Yoda already gave the solution to your problem. Why make things harder and more difficult than they need to be? I think you should follow the way of the Yedi
2004-12-04
Check the following location on your server/machine to see whether you can find AdventureworksDB files. If they are there attach them manually.C:\Program Files\Microsoft SQL Server\90\Tools\Samples\1033\awdb\AdventureWorks_Data.mdfC:\Program Files\Microsoft SQL Server\90\Tools\Samples\1033\awdb\AdventureWorks_Log.ldf
2004-11-25
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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