can somebody tell me why shoul i use tsql what are the advantages

Question

can somebody tell me why shoul i use tsql what are the advantages

teng84

Newbie

Points: 3
More actions
September 30, 2007 at 9:33 pm

#121722

can somebody tell me why should i use tsql what are the advantages

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Lester Policarpio SSCertifiable Points: 7109 More actions · Answer 1

Sometimes UPDATE,DELETE statements are better to be done in TSQL than Enterprise Manager. 1 good example is when you are deleting many rows in a certain table, when you use Enterprise Manager you would manually select the data then manually delete it. What if some data (not to be deleted) have been selected then has been deleted? Unlike in TSQL just use query then delete it automatically. Another thing is when your boss requested you to create a table then copy all the information (old table) to the new table? In EM (Enterprise Manager) you have to select the information manually and paste it in the new table. In TSQL all you have to do is make an INSERT statement

e.g.

INSERT INTO (new table) select * from (old table)

and that will solve you problem

Another example (base on my experience)

My first time restoring databases in a server took me more time than restoring using TSQL. When using EM i need to manually restore databases 1 by 1 (30+ databases) I have to monitor the database once it is done restoring then proceed to the next database. But my experience in TSQL is far more different than EM, I just made a restore script of all our databases (30+ databases) execute the query then wait for all the databases to be restored.

So for the summary, using TSQL gives you

1. Data Protection

2. Saves a lot of time

"-=Still Learning=-"

Lester Policarpio

teng84 Newbie Points: 3 More actions · Answer 2

can you please give me a good link where i can start learning T-SQL

🙂

Sergiy SSC Guru Points: 110206 More actions · Answer 3

{F1} on your keyboard.

_____________
Code for TallyGenerator

Lester Policarpio SSCertifiable Points: 7109 More actions · Answer 4

Got this URL in 1 of the old topics here in sqlservercentral

http://www.mssqlserver.com/tsql/

"-=Still Learning=-"

Lester Policarpio

teng84 Newbie Points: 3 More actions · Answer 5

thanks for the links that was cooool 😎 I really want to learn T-SQl so with this i guess i can have a good start again thanks

I been using sql for years to deal with my programming but i always thought that my coding is poor due to the lines it takes just to retrieve the right data. I believe T-SQl will help me to have my code cleaner and shorter

am i right with that?

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 6

TSQL is only a tool. It is as good as the one using it.