Aug 27, 2011

Insert Into Select Query Sample - Use for Insert Multiple Transaction Entries

'Use for Insert Multiple Transaction Entries

INSERT INTO abd_emp_degree
(deg_emp_userid,
deg_name,
deg_display,
deg_addedby,
deg_addedon)
SELECT 'AW999000',
VALUE,
'Y',
'AW999000',
Getdate()
FROM dbo.Split('CC,PS', ',')
By

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

What is the use of n-tier architecture and 3-tier architecture?

how to implement 3-tier architecture in asp.net using c#. 3-Tier architecture is also called layered architecture. Some people called it ...