tsql Archives - IT Nursery

I am trying to execute this query: declare @tablename varchar(50) set @tablename="test" select * from @tablename This produces the following error: Msg 1087, ...

May 31, 2022
0 Comments

Programming, sql-server

IT Nursery

Alter column, add default constraint

I have a table and one of the columns is “Date” of type datetime. We decided to add a default constraint to that ...

May 31, 2022
0 Comments

Programming, sql

IT Nursery

Is SQL or even TSQL Turing Complete?

This came up at the office today. I have no plans of doing such a thing, but theoretically could you write a compiler ...

May 31, 2022
0 Comments

Programming, sql

IT Nursery

SQL JOIN vs IN performance?

I have a case where using a JOIN or an IN will give me the correct results… Which typically has better performance and ...

May 30, 2022
0 Comments

Programming, sql

IT Nursery

Multi-statement Table Valued Function vs Inline Table Valued Function

A few examples to show, just incase: Inline Table Valued CREATE FUNCTION MyNS.GetUnshippedOrders() RETURNS TABLE AS RETURN SELECT a.SaleId, a.CustomerID, b.Qty FROM Sales.Sales ...

May 30, 2022
0 Comments