Training Day 3

SQL 2005+ –> xml is a regular data type
xml–> w3school–> xml is all about format
Select Produ…..
From Prod….
FOR XML RAW(‘Product’), ROOT(‘Products’), element, xmlschema
google–>Invent Data–> actually xml
Proper formated xml file in a text file:
Save your SELECT query results in XML file to Text File
Dump XML into SQL
 .query = select xml
google—> Q316005
google—-> 15Seconds xml dml
google—> XML Data Modification Language Workbench
:::::::::::::::::::::::VIEWS:::::::
View all permissions:
google—> sp_depends — do it before drop any view
Hardcoded View criteria:
where groupname like ‘Manu%’
Stored Procedure 
google—> IMPERSONATE—-Permission to user
Execute as login===OS level
Execute as user::::: SQL user level
SELECT SUSER_NAME(), USER_NAME();
REVERT; ==== bock to one level….
Advertisements
By simplemsexchange Posted in SQL 2008

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s