--

--Create a new Database

CREATE DATABASE testPawan
GO

--Use the new database

USE testPawan
GO

--Create a new table in the new database

CREATE TABLE [dbo].[SplitStrings](
    [Id] [int] NULL,
    [Vals] [varchar](100) NULL
) ON [PRIMARY]
 
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[SplitStrings] ([Id], [Vals]) VALUES (1, N'a,b')
GO
INSERT [dbo].[SplitStrings] ([Id], [Vals]) VALUES (2, N'a')
GO
INSERT [dbo].[SplitStrings] ([Id], [Vals]) VALUES (3, N'b,3')
GO
INSERT [dbo].[SplitStrings] ([Id], [Vals]) VALUES (4, N'c,u')
GO


--

--

--CLONEDATABASE Command

DBCC CLONEDATABASE ( 'testPawan' , 'NewPawan' )
GO
                                    
--

--

Database cloning for 'testPawan' has started with target as 'NewPawan'.
Database cloning for 'testPawan' has finished. Cloned database is 'NewPawan'.
Database 'NewPawan' is a cloned database. A cloned database should be used for diagnostic purposes only and is not supported for use 
in a production environment. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
                                    
--

--

USE NewPawan
GO

SELECT * FROM NewPawan.dbo.SplitStrings



Id          Vals
----------- ----------------------------------------------------------------------------------------------------

(0 rows affected)
                                    
--

--

USE [Pawan]
GO
/****** Object:  Table [dbo].[SplitStrings]    Script Date: 1/7/2018 9:36:48 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SplitStrings](
	[Id] [int] NULL,
	[Vals] [varchar](100) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[SplitStrings] ([Id], [Vals]) VALUES (1, N'a,b')
GO
INSERT [dbo].[SplitStrings] ([Id], [Vals]) VALUES (2, N'a')
GO
INSERT [dbo].[SplitStrings] ([Id], [Vals]) VALUES (3, N'b,3')
GO
INSERT [dbo].[SplitStrings] ([Id], [Vals]) VALUES (4, N'c,u')
GO


--

--

CREATE OR ALTER PROC TestPawan
AS
BEGIN
		
	SELECT Id , Vals
	FROM [SplitStrings] 
	
END
GO
                                    
--

--

EXEC TestPawan

Id          Vals
----------- --------
1           a,b
2           a
3           b,3
4           c,u

(4 rows affected)

                                    
--

--

CREATE OR ALTER VIEW Vw_SplitString
AS
	SELECT Id , Vals
	FROM [SplitStrings] 
GO
                                    
--

--

SELECT * FROM Vw_SplitString

Id          Vals       
----------- ---------- 
1           a,b        
2           a          
3           b,3        
4           c,u        
                       
(4 rows affected)      
                 

                                    
--

--

CREATE OR ALTER FUNCTION fnSplitstring()
RETURNS INT
AS
BEGIN
   RETURN ( SELECT COUNT(1) FROM [SplitStrings] )
END;
GO
                                    
--

--

SELECT dbo.fnSplitstring()


-----------
4

(1 row affected)

                                    
--

--

CREATE OR ALTER TRIGGER trTest 
ON [SplitStrings] 
AFTER INSERT, UPDATE 
AS
 RAISERROR ('Pawan is Here - MSBISkills.com', 1, 10);
                                    
--

--

INSERT INTO [SplitStrings] VALUES
(5,'Alpha,Beta')

Pawan is Here - MSBISkills.com
Msg 50000, Level 1, State 10

(1 row affected)

                                    
--