Top "Tsql" questions

What is the difference between SQL, PL-SQL and T-SQL?

What is the difference between SQL, PL-SQL and T-SQL? Can anyone explain what the differences between these three are, and …

sql tsql plsql

How do I create a foreign key in SQL Server?

I have never "hand-coded" object creation code for SQL Server and foreign key decleration is seemingly different between SQL Server …

sql sql-server tsql

T-SQL split string

I have a SQL Server 2008 R2 column containing a string which I need to split by a comma. I have …

sql sql-server tsql sql-server-2008 split

Remove the last character in a string in T-SQL?

How do I remove the last character in a string in T-SQL? For example: 'TEST STRING' to return: 'TEST STRIN'

sql sql-server tsql

Using RegEx in SQL Server

I'm looking how to replace/encode text using RegEx based on RegEx settings/params below: RegEx.IgnoreCase = True RegEx.Global = …

sql-server regex sql-server-2008 tsql

Need to list all triggers in SQL Server database with table name and table's schema

I need to list all triggers in SQL Server database with table name and table's schema. I'm almost there with …

sql sql-server database tsql triggers

SELECT DISTINCT on one column

Using SQL Server, I have... ID SKU PRODUCT ======================= 1 FOO-23 Orange 2 BAR-23 Orange 3 FOO-24 Apple 4 FOO-25 Orange I want 1 FOO-23 Orange 3 …

sql sql-server tsql distinct

how can I Update top 100 records in sql server

I want to update the top 100 records in SQL Server. I have a table T1 with fields F1 and F2. …

sql sql-server tsql sql-update

How do I obtain a Query Execution Plan in SQL Server?

In Microsoft SQL Server how can I get a query execution plan for a query / stored procedure?

sql sql-server performance tsql sql-execution-plan

Table name as variable

I am trying to execute this query: declare @tablename varchar(50) set @tablename = 'test' select * from @tablename This produces the following …

sql sql-server tsql variable-names tablename