SQL Scripts Archives - Page 293 of 318 - SQL Authority with Pinal Dave

SQL SERVER – FIX : Error : msg 2540 – The system cannot self repair this error

August 25, 2007

SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Scripts

SQL SERVER – FIX : Error : msg 2540 – The system cannot self repair this error This is most annoying error. I have only faced this error twice so far. I solved this error restoring the database back up. Read here for additional help on SQL Backup And Restore.…

SQL SERVER – T-SQL Script to Attach and Detach Database

August 24, 2007

Pinal Dave

SQL Tips and Tricks

SQL Backup, SQL Data Storage, SQL Restore, SQL Scripts, SQL Server

Following script can be used to detach or attach the database. If the database is to be from one database to another database following script can be used to detach from old server and attach to a new server. Let us learn about how to Attach and Detach Database.

SQL SERVER – 2005 – Use of Non-deterministic Function in UDF – Find Day Difference Between Any Date and Today

August 23, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Error Messages, SQL Function, SQL Scripts

While writing few articles about SQL Server DataTime I accidentally wrote User Defined Function (UDF), which I would have not wrote usually. Once I wrote this function, I did not find it very interesting and decided to discard it. However, I suddenly noticed use of Non-Deterministic function in the UDF.…

SQL SERVER – T-SQL Script to Insert Carriage Return and New Line Feed in Code

August 22, 2007

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL String

Very simple and very effective. We use all the time for many reasons – formatting, while creating dynamically generated SQL to separate GO command from other T-SQL, saving some user input text to database etc. Let us learn about T-SQL Script to Insert Carriage Return and New Line Feed in Code.

SQL SERVER – 2005 – Create Script to Copy Database Schema and All The Objects – Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects

August 21, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Backup and Restore, SQL Constraint and Keys, SQL Cursor, SQL Download, SQL Function, SQL Index, SQL Scripts, SQL Stored Procedure, SQL Trigger

Update: This article is re-written with SQL Server 2008 R2 instance over here: SQL SERVER – 2008 – 2008 R2 – Create Script to Copy Database Schema and All The Objects – Data, Schema, Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects Following quick tutorial demonstrates…

SQL SERVER – Find Monday of the Current Week

August 20, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts, SQL Utility

Very Simple Script which find Monday of the Current Week SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0) MondayOfCurrentWeek Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – Find Last Day of Any Month – Current Previous Next

August 18, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts, SQL Utility

Few questions are always popular. They keep on coming up through email, comments or from co-workers. Finding Last Day of Any Month is similar question. I have received it many times and I enjoy answering it as well. I have answered this question twice before here: SQL SERVER – Script/Function…