2
votes
Accepted
conversion failed when converting date and/or time from character string only on one of the server
when i enter date manually like '01/06/2023' it shows data in table but whenever i enter getdate() function to get current date automatically it shows no data
GETDATE() returns the current system ...
- 29.5k
1
vote
Best approach for populating date dimension table
Here is a single SELECT query that uses the WITH RECURSIVE statement. It does not require loops, procedures etc.
A RECURSIVE SQL common table expression (CTE) is a query that continuously references a ...
- 111
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
sql-server-2008 × 3910sql-server × 2367
sql-server-2008-r2 × 343
performance × 210
t-sql × 207
sql-server-2012 × 185
sql-server-2005 × 149
index × 127
replication × 111
backup × 106
stored-procedures × 95
restore × 93
database-design × 92
ssis × 88
security × 79
ssms × 73
query-performance × 67
permissions × 59
mirroring × 55
linked-server × 52
transaction-log × 49
ssrs × 44
trigger × 39
deadlock × 39
query × 38