[VIEWED 6843
TIMES]
|
SAVE! for ease of future access.
|
|
|
neo-reactive-poet
Please log in to subscribe to neo-reactive-poet's postings.
Posted on 07-25-19 9:55
PM [Snapshot: 61]
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
SELECT * FROM TABLENAME That will give you data. lol
|
|
|
|
smtzac
Please log in to subscribe to smtzac's postings.
Posted on 07-27-19 8:29
AM [Snapshot: 288]
Reply
[Subscribe]
|
Login in to Rate this Post:
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
Please log in to subscribe to phone's postings.
Posted on 07-28-19 8:41
AM [Snapshot: 438]
Reply
[Subscribe]
|
Login in to Rate this Post:
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
Please log in to subscribe to smtzac's postings.
Posted on 07-28-19 9:16
AM [Snapshot: 449]
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
No, I don't believe so.
Last edited: 28-Jul-19 09:22 AM
|
|
|
Jhilke_Bro
Please log in to subscribe to Jhilke_Bro's postings.
Posted on 07-29-19 11:00
AM [Snapshot: 543]
Reply
[Subscribe]
|
Login in to Rate this Post:
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
|
|
|