SQL开发利器SQL Prompt 5.1完全破解+使用教程

SQL Prmopt 5.1——Write,edit and explore SQL effortlessly

3) 覆盖RedGate.SQLPrompt.SSMSUI.dll和RedGate.SQLPrompt.VSUI.dll文件

在覆盖这两个dll文件之前，请先做好备份。

Red GateSQL Prompt 5RedGate.SQLPrompt.SSMSUI.dll"

Test
Test
CREATE TABLE Employees

<span style="color: gray;">(

Id <span style="color: blue;">INT IDENTITY PRIMARY KEY<span style="color: gray;">,EmployeeName <span style="color: blue;">NVARCHAR<span style="color: gray;">(100<span style="color: gray;">),EntryDate <span style="color: blue;">DATE

<span style="color: gray;">)

<span style="color: blue;">GO
CREATE TABLE Users

<span style="color: gray;">(

Id <span style="color: blue;">INT IDENTITY PRIMARY KEY<span style="color: gray;">,UserName <span style="color: blue;">NVARCHAR<span style="color: gray;">(100<span style="color: gray;">),Gender <span style="color: blue;">CHAR<span style="color: gray;">(1<span style="color: gray;">),Birhdate <span style="color: blue;">DATETIME<span style="color: gray;">,EmployeeId <span style="color: blue;">int

<span style="color: gray;">)

<span style="color: blue;">GO
SELECT u<span style="color: gray;">.UserName<span style="color: gray;">,e<span style="color: gray;">.EmployeeName <span style="color: blue;">FROM dbo<span style="color: gray;">.Users u

<span style="color: gray;">INNER JOIN dbo<span style="color: gray;">.Employees e <span style="color: blue;">ON e<span style="color: gray;">.Id <span style="color: gray;">= u<span style="color: gray;">.EmployeeId


Test
Test
CREATE TABLE Employees

<span style="color: gray;">(

Id <span style="color: blue;">INT IDENTITY

PRIMARY KEY <span style="color: gray;">,EntryDate <span style="color: blue;">DATE

<span style="color: gray;">)

<span style="color: blue;">GO
CREATE TABLE Users

<span style="color: gray;">(

Id <span style="color: blue;">INT IDENTITY

PRIMARY KEY <span style="color: gray;">,Birhdate <span style="color: blue;">DATETIME <span style="color: gray;">,EmployeeId <span style="color: blue;">INT

<span style="color: gray;">)

<span style="color: blue;">GO
SELECT  u<span style="color: gray;">.UserName <span style="color: gray;">,e<span style="color: gray;">.EmployeeName

<span style="color: blue;">FROM    dbo<span style="color: gray;">.Users u

<span style="color: gray;">INNER JOIN dbo<span style="color: gray;">.Employees e <span style="color: blue;">ON e<span style="color: gray;">.Id <span style="color: gray;">= u<span style="color: gray;">.EmployeeId




















Show History






Using SQL Prompt with Visual Studio
SQL Prompt can be integrated with Visual Studio 2005,2008 and 2010. SQL Prompt only works in Database projects and SQL Server projects.









                        
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!