SQL Server 2008 and using Transact SQL (TSQL)

http://www.sqlserver2008tutorial.com/

If you want to be good at working with databases, strong knowledge of TSQL is a must. In this important video, we start off with AdventureWorks2008. We start with SELECT statement which is used to return data. We move to the INSERT statement using the Person table in the database. The next two statements are UPDATE and DELETE which are very powerful. Using a where clause is extremely important here. We show you how to change data in Person table.

Visit our other sites:

http://www.learningcomputer.com/
http://www.learningsqlserver2008.com/
http://www.sqlazuretutorials.com/
http://compare-insurance-car.com/compare-car-insurance.html
http://www.mycar-insurance.net/
http://datatechnologyllc.com/search-engine-optimization/Dallas-SEO.html

Category:

Howto & Style

Tags:

• sql server
• select SQL
• update query
• Update records
• sqL delete
• SQL Server 2008
• using Transact SQl
• insert statement
• Insert (SqL)
• Update (SQL)
• Delete (SQL)

[ddsharper]

How do you turn on intellisense? How do you turn on transactional sql? thank you.

[baghul]

@ddsharper For Intellisense, you need SQL server 2008. Not sure about the second question. You can run transact sql in any version.

[baghul]

Are you trying to upgrade 2005 express to 2008 express? I believe you can use the Upgrade Advisor to do this.

[ddsharper]

WHY CAN'T I READ THE TEXT IN THE DBO TABLES IN SQL MANAGER OR NAVICAT? seems to be encoded or something. imported a xml file, delivered and done in UTF8 and went through the import wizard of navicat.

[leotakesleo]

how to connect sqr server to visual studio ....or express...?it either gives an error for upgrading sqr server 2005...while i have 2008 express..>!

and sometimes it gives an error for user instance.......:(...

i have been trying it for over few days...:(