- SQL Server
- SQL Azure
- SQLCMD
- SQL Server CE
- Adding Dates
- Create Database
- Creating and Using a Number Table
- Database Mail
- Linked Server
- SQL Server - Aggrigration of strings using TSQL
- SQL Server - IDENTITY
- SQL Server - MERGE Example
- SQL Server - Reading information from an XML document using OPENXML
- SQL Server - Resource governor
- SQL Server - User Defined Table Types
- SQL Server - Using Row Constructors
- SQL Server - Using the PIVOT operator
- SQL Server - Using the UNPIVOT Operator
- SQL Server - statistics
- SQL Server Backup
- SQL Server Common Table Expressions (CTEs)
- SQL Server DATE calculations
- SQL Server Mirroring
- SQL Server OPENDATASOURCE
- SQL Server OPENROWSET
- SQL Server Service Broker
- SQL Server Sparse Columns and Column Sets
- SQL Server Window Functions
- SQL Server XML Data Type Operations
- SQL Server XML Schema Collections
- Truncate TRN Log in SQL Server 2005/2000
Truncate TRN Log in SQL Server 2005/2000
Truncating Transaction Log in SQL Server 2005/2000
-- Database Name: NorthPole -- Log File Name: NorthPole_Log USE NorthPole GO BACKUP LOG NorthPole WITH TRUNCATE_ONLY DBCC SHRINKFILE(NorthPole_Log, 1)
Cant find the page you are looking for?
Help us to improve by adding the content that you are looking for.
Leave a feedback
We look forward to hear your comments and feedback.
Help us to improve by adding the content that you are looking for.
Leave a feedback
We look forward to hear your comments and feedback.
- 750 reads
Syndicate
Popular content
Today's:
- Search for a cheat sheet
- C#.NET - Read comma separated values from app.config
- SQL Server OPENROWSET
- SQL Server OPENDATASOURCE
- VB.NET - Dynamic Exceptions Handling with the Message Box
- SQLCMD
- SQL Server Cheat Sheet - FULL Backup
- VB.NET - Concatenate Multiple Files into single File
- SQL Server
- Database Mail
- SQL Server - Using the PIVOT operator
- SQL Server - User Defined Table Types
- MOSS 2007 - Get Users From SharePoint Group
- Cant find what you are looking for?
- VB.NET - LINQ query to get list of files and bind to DataGridView
- SQL Azure
- SQL Server - statistics
- SQL Server - Using the UNPIVOT Operator
- SQL Server Recursive Common Table Expressions (Recursive CTE)
- VB.NET - LINQ to SQL Count query results
- SQL Server DATE calculations
- SQL Server - Using Row Constructors
- SQL Azure - Connection to SQL Azure using OLEDB
- ASP.NET
- Vb.NET - IsDate() to check for valid date input validation
- SQL Azure - Using SQLCMD with SQL Azure
- SQL Server CE
- ASP.NET - Download file to client browser
- SQL Server - Reading information from a CSV file using OPENROWSET
- VB.NET - Working with Console Applications
All time:
About the author
