Need to integrate valuable information from XML files into your SQL Server database? SSIS offers a powerful solution! Here’s a simplified guide: 1. Build your SSIS package: Launch SSIS and create a new project. Drag and drop these components: XML…
Query Navigation and Editing: F5/Ctrl + E: Execute the current query. Ctrl + L: Clear the results pane. Ctrl + F5: Execute the current query and keep the results pane hidden. Alt + Break: Cancel a running query. Ctrl +…
Index fragmentation is when the data in an index is not stored in a continuous order. This can happen when data is added, deleted, or changed in a table. If an index is fragmented, it can take longer for SQL…
In this blog post, we will guide you through the process of creating a SQL user in Microsoft SQL Server using the graphical user interface (GUI) provided by SQL Server Management Studio (SSMS). The user will have access to only…
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
SELECT ct.name as NatureOfCall, u.FirstName + ' ' + u.LastName as Employee, convert(date, (convert(datetime, switchoffset(c.CreateDatetime, datepart(tzoffset, c.CreateDatetime at time zone 'Central Standard Time'))))) as DateOfCall, convert(char(8), (convert(datetime, switchoffset(c.CreateDatetime, datepart(tzoffset, c.CreateDatetime at time zone 'Central Standard Time')))), 108) as TimeOfCall, a.HouseNumber + a.prefixdirectional + a.streetname + a.streettype + a.qualifier + ' / ' + a.xprefixdirectional + a.xstreetname + a.xstreettype + ', ' + a.city as AddressOfCall, c.CallNumber as CADNumber FROM [Call] c INNER JOIN Address a ON c.CurrentAddressID = a.AddressID INNER JOIN [CallType] ct on c.CallTypeID=ct.CallTypeID INNER JOIN Users u ON c.CreateUser = u.UserId WHERE c.CreateDatetime BETWEEN DATEADD(DAY, -1, GETDATE()) AND GETDATE() ORDER BY c.CreateDatetime FOR XML PATH('IncidentData'), ROOT('root') |
This is a SELECT statement in SQL that is used to retrieve data from multiple tables in a database. The statement begins by selecting a number of columns from the tables specified in the FROM clause. The first column…
Server-level roles There are database-level roles and server-level roles. Server-level roles lets you manage the permissions on a server. The following are fixed server-level roles:sysadmin, serveradmin, securityadmin, processadmin, bulkadmin diskadmin, dbcreator, and public. Every SQL server login belongs to the…
Creating a new user in Microsoft SQL Server is a common task that can be accomplished using a variety of methods, including Transact-SQL statements, SQL Server Management Studio, and the SQL Server Management Objects (SMO) .NET library. To create a…