Joined
Last Seen
0 Reputation Points
0% Quality Score
- Upvotes Received
- 0
- Posts with Upvotes
- 0
- Upvoting Members
- 0
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
0 Endorsements
Ranked #54.9K
~269 People Reached
Favorite Forums
Databases
x
1
Hi I have a text file which has the following: 'username=sonia\n', 'password=password' I want to split sonia and place it in a variable called username. I was able to accomplish the following but could not remove the new line characters. text = 'username=sonia\n', 'password=password' text[0].split('=')[1] This returns 'sonia\n' So now … |
|
Hi does anyone know how to update a datepart? update table set datepart(dd, tablename) = '30' where ?? What I want to do is udpate records date data but only the day so where all of the records > '2009-07-25 00:00:00.000' are updated to 30 i.e. 2009-07-30, I want to … |