Removing time part in an SQL Datetime field
Here is a quick and easy way for removing time component from datetime SQL fields. Read more…
Posts tagged SQL
Locking Hints in SQL 2005
I was recently working on a stored procedure with a Transact-SQL statement that looked like this. UPDATE table.foo SET fooName = b.Name FROM table.fah b WITH (NOLOCK) JOIN table.foo a WITH (NOLOCK) AND a.fooId = b.fooId WHERE b.fooCategory = ‘X’ this was running concurrently with another procedure with the SQL looking like this. UPDATE table.foo [...]
Recent Posts
- Amazon starts taking pre-orders on the Kindle DX
- Apple figures out the source of IPhone 4′s weak signal (It’s what everyone knew all along)
- Interesting fix to IPhone antenna flaw
- Testing out wordpress for Blackberry
- A lesson from playing games
WP Cumulus Flash tag cloud by Roy Tanck and Luke Morton requires Flash Player 9 or better.