skip to main | skip to sidebar

Yes/No MsgBox

Tuesday, March 24, 2009

preparing Insert statement for the ros exst in table -sql server

Declare @qt as varchar(1000)
set @qt = ''''
print @qt
select 'insert into program values ',ProgramID, ',', ProgramCode ,',', @qt+ Description + @qt from program
Posted by akella at 2:15 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2010 (2)
    • ►  July (2)
  • ▼  2009 (22)
    • ►  November (4)
    • ►  September (3)
    • ►  June (1)
    • ►  May (3)
    • ▼  March (8)
      • Nth Highest salary and Fetching column values for ...
      • preparing Insert statement for the ros exst in tab...
      • Regular expression for a Foramt 'XX99999X'
      • Expand/Collapse GV
      • options for a Question and Tips of DataTable and ...
      • searching for a word in a column
      • Restoring the Quick Launch Bar in Web Part Pages
      • SPSite and SPWeb
    • ►  February (2)
    • ►  January (1)
  • ►  2008 (3)
    • ►  May (2)
    • ►  April (1)

About Me

akella
View my complete profile