Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
DECLARE @title XML SET @title = N'<?xml version="1.0" encoding="UTF-16" ?>' DECLARE @link XML SET @link = N'<?xml version = "1.0" encoding = "UTF-16"?><link>http://www.mydomain.com</link>' DECLARE @description XML SET @description = N'<?xml version = "1.0" encoding = "UTF-16"?><description>Current Real Estate Listings from My Domain Properties</description>' DECLARE @lastBuildDate XML SET @lastBuildDate = N'<?xml version = "1.0" encoding = "UTF-16"?><feedPublishDate>' + CONVERT (Varchar(10), getdate(), 101) + '</feedPublishDate>' DECLARE @language XML SET @language = N'<?xml version = "1.0" encoding = "UTF-16"?><language>en-us</language>' select --Non-Recurring header Section (Select @title), (Select @link), (Select @description), (Select @lastBuildDate), (Select @language), --Recurring Properties Section (select [listing_id] as 'Listing_ID', [property_type_id] as 'Property_Type_ID', [newspaper_id] as 'Newspaper_ID', null as 'House_Number', [House_Street] as 'House_Street', [Display_Address] as 'Display_Address', [ZIP] as 'ZIP', [rental_or_sale] as 'rental_or_Sale', [price] as 'Price', [Bedrooms_ID] as 'Bedrooms_ID', [Agent_ID], [Agent_Contact_1], [Agent_Phone_1], [Agent_Email_1], [Agent_Picture_1], [Comments] as 'description/CDATA', [Full_baths], [Acres], [Listing_Photo_1] as 'adImages/imges1', [Listing_Photo_2] as 'adImages/imges2', [Listing_Photo_3] as 'adImages/imges3', [Listing_Photo_4] as 'adImages/imges4', [Listing_Photo_5] as 'adImages/imges5', [Listing_Photo_6] as 'adImages/imges6', [Listing_Photo_7] as 'adImages/imges7' from dbo.vView for xml path('ad'), type, elements ) FOR XML path('export')
|insert query with value having 's||2||51|
|upgrade sql 2005 32bit to sql 2008 32 or 64bit on a server 2008 r2 box||6||64|
|Find results from sql within a time span||11||29|