I’ve started using LinqPad. In addition to being more lightweight than SSMS, you can also practice writing LINQ queries- way more fun than boring old TSQL!
More Related Contents:
- Subquery in select not working in SQL Server
- Get first day of week in SQL Server
- What is the significance of 1/1/1753 in SQL Server?
- How to create jobs in SQL Server Express edition
- Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
- How to delete large data of table in SQL without log?
- Insert Update trigger how to determine if insert or update
- SQL Server: UPDATE a table by using ORDER BY
- What is the best way to truncate a date in SQL Server?
- Do I really need to use “SET XACT_ABORT ON”?
- What is a Trusted Connection?
- Understanding SQL Server LOCKS on SELECT queries
- Do while loop in SQL Server 2008
- How to find the port for MS SQL Server 2008?
- How do I create a multiple-table check constraint?
- How to convert number of minutes to hh:mm format in TSQL?
- Stored Procedure and Permissions – Is EXECUTE enough?
- What happens if you don’t commit a transaction to a database (say, SQL Server)?
- Dynamically assign filename to excel connection string
- SQL Server Group by Count of DateTime Per Hour?
- Temporarily disable all foreign key constraints
- How to import a DBF file in SQL Server
- SQL Server Dependencies
- SQL Server: Filter output of sp_who2
- How can I insert binary file data into a binary SQL field using a simple insert statement?
- Why do I get the error “Xml data type is not supported in distributed queries” when querying a linked server for non-xml data?
- Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
- Date range overlapping check constraint
- SQL Server error “Implicit conversion of because the collation of the value is unresolved due to a collation conflict.”
- How to choose the clustered index in SQL Server?