SQL Server Table with data - Sajha Mobile
SAJHA MOBILE
SQL Server Table with data
Posts 5 · Viewed 5715 · Go to Last Post
neo-reactive-poet
· Snapshot 61
Like · Likedby · 0
SELECT * FROM TABLENAME
That will give you data. lol
smtzac
· Snapshot 288
Like · Liked by · 0
Right click on the Database, go to Generate skript, inside 'advanced' ( I believe) it says 'schema' and 'Schema and Data' select 'Schema and Data' one.
Or 
SELECT *
INTO newtable (it will create a new table)
FROM tableName (you want to create a table using this table data)

Hope it helps.




Last edited: 27-Jul-19 08:35 AM
phone
· Snapshot 438
Like · Liked by · 0
Hello smtzac,
Thank you for your reply.
Is there a query to generate a query as an alternative by going into the database>tasks>generate skript.......?

Thank you.
Last edited: 28-Jul-19 01:23 PM
smtzac
· Snapshot 449
Like · Liked by · 0
No, I don't believe so.
Last edited: 28-Jul-19 09:22 AM
Jhilke_Bro
· Snapshot 543
Like · Liked by · 0
Copy the result set from the following query and patch with INSERT INTO dbo.DestinationTable(ColumnA,ColumnB)
SELECT 'SELECT '+ ''+ColumnA+''+','+''+ColumnB+''+' UNION ALL'
FROM dbo.TableName

Please log in to reply to this post

You can also log in using your Facebook
View in Desktop
What people are reading
Visitor from US is reading SQL Server Table with data
Visitor from CN is reading भए पुग्छ !
Visitor is reading म बाँदर पुच्छर नभको
Visitor is reading Asylum in USA
Visitor is reading Has Anyone renewed their DRIVER LICENCE IN HOUSTON RECENTLY
Visitor is reading नक्कली नोट छाप्ने मिसिन
Visitor is reading Fuchhe King Zindabad
Visitor from US is reading You Know You Are a Nepali When
Visitor is reading Status adjust attorney
You might like these other discussions...
haal haal pandit » Sexy In Sari
Why Americans reverse park?
· Posts 5 · Viewed 524
Sajha Classifieds
Classifieds Summary: Jobs in MD,NV, Room/Apt in MA,VA
· Posts 1 · Viewed 90
NepalNews Sajha
News Summary from Nepal for Tuesday, May 7, 2024
· Posts 1 · Viewed 56
sajalshakya » sajalshakya
banking after NRN citizenship
· Posts 5 · Viewed 2404
IamDJ » ShreeRaam
TPS Re-registration case still pending ..
· Posts 72 · Viewed 16033 · Likes 15
Sameer 0177
Anyone from Atlanta
· Posts 1 · Viewed 146
NepalNews Sajha
News Summary from Nepal for Monday, May 6, 2024
· Posts 1 · Viewed 128
xkavrepalanchok » wakeyour_mind
They are openly permitting undocumented immigrants to participate in federal elections in Arizona now.
· Posts 16 · Viewed 2489 · Likes 3
Sajha Classifieds
Classifieds Summary: Room/Apt in MA
· Posts 1 · Viewed 164
NepalNews Sajha
News Summary from Nepal for Sunday, May 5, 2024
· Posts 1 · Viewed 147



Your Banner Here
Travel Partners
Travel House Nepal