sql-server Archives - Page 6 of 39

Programming, sql

IT Nursery

How to calculate age (in years) based on Date of Birth and getDate()

I have a table listing people along with their date of birth (currently a nvarchar(25)) How can I convert that to a date, ...

May 29, 2022
0 Comments

Programming, sql

IT Nursery

In SQL, how can you “group by” in ranges?

Suppose I have a table with a numeric column (lets call it “score”). I’d like to generate a table of counts, that shows ...

May 29, 2022
0 Comments

Programming, sql-server

IT Nursery

How to see query history in SQL Server Management Studio

Is the query history stored in some log files? If yes, can you tell me how to find their location? If not, can ...

May 29, 2022
0 Comments

Programming, sql

IT Nursery

is it possible to select EXISTS directly as a bit?

I was wondering if it’s possible to do something like this (which doesn’t work): select cast( (exists(select * from theTable where theColumn like ...

May 29, 2022
0 Comments

C#, Programming

IT Nursery

How do I perform an insert and return inserted identity with Dapper?

How do I perform an insert to database and return inserted identity with Dapper? I’ve tried something like this: string sql = "DECLARE ...

May 29, 2022
0 Comments

Programming, sql-server

IT Nursery

SQL Server 2008 can’t login with newly created user

I’m using using Windows Vista and I’m having trouble logging in with a newly created user. I open SQL Server Management Studio. I ...

May 29, 2022
0 Comments

Programming, sql-server

IT Nursery

How do I escape a percentage sign in T-SQL?

This question also has the answer, but it mentions DB2 specifically. How do I search for a string using LIKE that already has ...

May 29, 2022
0 Comments

Programming, sql

IT Nursery

Best way to do nested case statement logic in SQL Server

I’m writing an SQL Query, where a few of the columns returned need to be calculated depending on quite a lot of conditions. ...

May 29, 2022
0 Comments

Programming, sql

IT Nursery

Most efficient T-SQL way to pad a varchar on the left to a certain length?

As compared to say: REPLICATE(@padchar, @len - LEN(@str)) + @str 20 Answers 20

May 29, 2022
0 Comments

Programming, sql-server

IT Nursery

How to alter SQL in “Edit Top 200 Rows” in SSMS 2008

In SQL Server 2008 Management Studio, when I right click on a database table and choose “Select Top 100 Rows“, I can then ...

May 28, 2022
0 Comments