Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rushad
Starting Member
3 Posts |
 Posted - 2012-08-01 : 00:18:48
|
| Hi Team,I have a simple question for you guys... I ran this below query into my principals database and I want to know if it did any damage to the database. If yes then how do I re-correct it. Hope you understand that I am a biginner.Declare @mystring varchar(100)Select @mystring = 'my_filename.pdf'SELECT @mystring = Substring(@mystring, 1, (len(@mystring) - 4) )Thanks in advance...Thanks,RS |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-08-01 : 00:38:59
|
The Query merely remove the last 4 chars from @mystring. It does not update to any table at all.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
Rushad
Starting Member
3 Posts |
Posted - 2012-08-01 : 05:16:08
|
| Thanks KH... |
|
|
|
|
|
|
About @mystring