****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP 1000 [tp_SiteID]
,[tp_ID]
,[tp_DomainGroup]
,[tp_SystemID]
,[tp_Deleted]
,[tp_SiteAdmin]
,[tp_IsActive]
,[tp_Login]
,[tp_Title]
,[tp_Email]
,[tp_Notes]
,[tp_Token]
,[tp_ExternalToken]
,[tp_ExternalTokenLastUpdated]
,[tp_Locale]
,[tp_CalendarType]
,[tp_AdjustHijriDays]
,[tp_TimeZone]
,[tp_Time24]
,[tp_AltCalendarType]
,[tp_CalendarViewOptions]
,[tp_WorkDays]
,[tp_WorkDayStartHour]
,[tp_WorkDayEndHour]
,[tp_Mobile]
,[tp_Flags]
FROM [WSS_Content_2010_Solar_Test_181213].[dbo].[UserInfo]
SELECT TOP 1000 [tp_SiteID]
,[tp_ID]
,[tp_DomainGroup]
,[tp_SystemID]
,[tp_Deleted]
,[tp_SiteAdmin]
,[tp_IsActive]
,[tp_Login]
,[tp_Title]
,[tp_Email]
,[tp_Notes]
,[tp_Token]
,[tp_ExternalToken]
,[tp_ExternalTokenLastUpdated]
,[tp_Locale]
,[tp_CalendarType]
,[tp_AdjustHijriDays]
,[tp_TimeZone]
,[tp_Time24]
,[tp_AltCalendarType]
,[tp_CalendarViewOptions]
,[tp_WorkDays]
,[tp_WorkDayStartHour]
,[tp_WorkDayEndHour]
,[tp_Mobile]
,[tp_Flags]
FROM [WSS_Content_2010_Solar_Test_181213].[dbo].[UserInfo]
No comments:
Post a Comment