user353gre3's user avatar
user353gre3's user avatar
user353gre3's user avatar
user353gre3
  • Member for 10 years, 7 months
  • Last seen more than 2 years ago
21 votes
Accepted

How can I design a query to pause / sleep / wait for a specified amount of time?

5 votes
Accepted

Need help with SQL Server PIVOT

4 votes

SQL Query with optional WHERE clause parameter for date range?

4 votes
Accepted

Confused on how a value gets added with the DEFAULT constraint

4 votes
Accepted

Performance hit with column alias

4 votes

Using CREATE TYPE within Stored Procedure Call

3 votes
Accepted

Generic script for stored procedure rollback

3 votes
Accepted

Security Question

2 votes
Accepted

Backup and Restore Database Method

2 votes
Accepted

Please explain how this query generates a calendar table in MySQL

2 votes
Accepted

Return every instance of a string contains search

2 votes
Accepted

How to retrieve data of two columns from two tables?

2 votes
Accepted

How to get the dependent entities (referencing entities) for an User Defined Function (UDF)

1 vote

Reset Key Names to Defaults?

1 vote

Convert date and time

1 vote

SQL Server: CONVERT From ISO8601 To DateTime Within Query

1 vote

RaiseError on SQL Server stored procedures

1 vote
Accepted

Get the most present elements from many fields

1 vote

2 Date Ranges - How many days from one range excluding weekends overlap

1 vote
Accepted

convert update field second to time

1 vote

Get only future records

1 vote

Reasons to Backup (or not backup) QA and Dev Databases

1 vote

database size limitations

0 votes

Custom calendar for calculating workdays per month

0 votes

How to query for 'First showed up as'

0 votes

How to query for 'First showed up as'

0 votes

How to deal with circular foreign key

0 votes

Remove a period if it is the first character in a varchar column

0 votes

Dynamic Pivot with overlapping years

0 votes

Reading Data from SQL Server database