SQL Server update statement is used used to modify an existing records in a table, you can also update records in table based on some… Read More »How to Update from Select Statement in SQL
1,832 total views, 14 views today
Sometimes you need to format a date in specific format such as format a date time string YYYY-MM-DD hh:mm:ss. mmm to date MM:DD:YY. SQL Server… Read More »Date and Time Conversions in SQL Server
1,770 total views, 14 views today
Detaching and attaching a SQL database, is helpful in case in case when you want to move to move a database to a different SQL Server instance. So Bascially, first we detach database from SQL Server and move those files to another SQL Server and then attach files.
879 total views, 2 views today
SQL Detach Database, when you detach a database from SQL Server, database is removed from the instance of SQL Server but kept the database intact within its data files and transaction log files.
958 total views, 2 views today