SQL Server Table with data - Sajha Mobile
SAJHA MOBILE
SQL Server Table with data
Posts 5 · Viewed 5675 · 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 is reading 9/11 is over, get over it : Tom Friedman's article
Visitor is reading for fun
Visitor is reading Looking for Potential Match
Visitor from US is reading how u feel
Visitor from US is reading २०२१ , २२ मा घर किन्नेहरु कटौरामा भिक् माग्ने स्तिथिमा
Visitor is reading PRISMS--by SITARA
Visitor is reading Join my chat
Visitor is reading tamu lohsar Sydney 2010
You might like these other discussions...
furke
Trasiting through Istanbul, Turkey
· Posts 1 · Viewed 97
xkavrepalanchok » Tesla guy
They are openly permitting undocumented immigrants to participate in federal elections in Arizona now.
· Posts 3 · Viewed 741 · Likes 2
xkavrepalanchok » Tesla guy
They deserve priority due to their language barrier. But whose fault is that? Entering the country illegally knowing English is essential.
· Posts 2 · Viewed 206
kale dai » Tesla guy
lost $3500 on penny stocks !!!
· Posts 8 · Viewed 815 · Likes 1
xkavrepalanchok » Sexy In Sari
Obama Illinois federal judge --- rules illegal migrants can carry guns legally !
· Posts 4 · Viewed 314
xkavrepalanchok
If the democrats didn't have double standards, they'd have no standards at all.
· Posts 1 · Viewed 130
Sajha Classifieds
Classifieds Summary: Room/Apt in CO,VA
· Posts 1 · Viewed 102
NepalNews Sajha
News Summary from Nepal for Sunday, April 28, 2024
· Posts 1 · Viewed 90
Lucky_Nepali » chicagoan
TPS advance parole Travel document i-131, Class of Admission ?
· Posts 8 · Viewed 859
wakeyour_mind » wakeyour_mind
These Student Protests Against Israel Are the Most Important Political Movement of Our Lifetime
· Posts 5 · Viewed 538



Your Banner Here
Travel Partners
Travel House Nepal