What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-02-22 17:20:02
get value comma separated sql server
DECLARE @UserMaster TABLE( UserID INT NOT NULL, UserName varchar(30) NOT NULL ); INSERT INTO @UserMaster VALUES (1,'Rakesh') INSERT INTO @UserMaster VALUES (2,'Ashish') INSERT INTO @UserMaster VALUES (3,'Sagar') SELECT * FROM @UserMaste... Add solution -
SQL 2021-10-16 13:44:06
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
-- Option #3 : Use OPENROWSET DECLARE @StudentGrades TABLE ( [StudentID] INT, [StudentName] VARCHAR(100), [Grade] DECIMAL(4, 1) ) INSERT INTO @StudentGrades ( [StudentID], [StudentName], [Grade] ) SELECT A.* FROM OPENRO... Add solution