New answers tagged

0 votes

Restrict access for Windows administrator

Enable Sql authentication and then disable user login. Security => logins right click on sa click on properties then click on status then restart the sql server services. before you move on to the ...
  • 101
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
-1 votes

Reset the numbering at the tabs of the Microsoft SQL Server Management Studio

select * from sys.dm_exec_sessions will return all of the sessions open on that particular sql server The tab # is the # of your own session. Other user will receive their own session #.
  • 1
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.6k

Top 50 recent answers are included