Posts
 
Reputation
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
~269 People Reached
Favorite Forums
Favorite Tags
Member Avatar for sonial8

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 …

Member Avatar for sonial8
-1
152
Member Avatar for sonial8

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 …

Member Avatar for sknake
0
117