Add a database reference to master
:
- Under the project, right-click References.
- Select Add database reference….
- Select System database.
- Ensure master is selected.
- Press OK.
Note that it might take a while for VS to update.
More Related Contents:
- How can I do an UPDATE statement with JOIN in SQL Server?
- Not equal != operator on NULL
- How can I select the first day of a month in SQL?
- Subquery using Exists 1 or Exists *
- Most efficient T-SQL way to pad a varchar on the left to a certain length?
- Is it possible to specify condition in Count()?
- Update records in table from CTE
- Dynamic Pivot Columns in SQL Server
- Selecting N rows in SQL Server
- how can I Update top 100 records in sql server
- How can I INSERT data into two tables simultaneously in SQL Server?
- SQL “select where not in subquery” returns no results
- How can a LEFT OUTER JOIN return more records than exist in the left table?
- Count Number of Consecutive Occurrence of values in Table
- “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
- SQL query to find Nth highest salary from a salary table
- Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
- T-SQL: How to use parameters in dynamic SQL?
- Get the records of last month in SQL server
- Merge overlapping date intervals
- I want to use CASE statement to update some records in sql server 2005
- Access to Result sets from within Stored procedures Transact-SQL SQL Server
- alternatives to REPLACE on a text or ntext datatype
- Split words with a capital letter in sql
- SQL poor stored procedure execution plan performance – parameter sniffing
- How to return a incremental group number per group in SQL
- SQL – How do I get only the numbers after the decimal?
- How to retrieve records for last 30 minutes in MS SQL?
- Group consecutive rows of same value using time spans
- Why do SQL Server Scalar-valued functions get slower?