Display the SELECT statement for any table
Found this lovely T-SQL script to display the SELECT statement for any table.
2013-08-22 (first published: 2013-08-06)
3,211 reads
Select Query
Linked Server Issues with Oracle 8.1.7
Hi ,I have a scenario where I need to configure a linked server on SQL 2000 Ent. Edition which connects to a Oracle 8.1.7 database. The linked server will be used in distributed transactions as well.I have done Linked Server Setup, and it is working correctly. I am worried about few things in this.1. Will […]
2004-02-23
4 reads
RE: How to... Change a Filegroup for an Existing Table
Using EM? I was hoping for something similar to ORACLE, which allows you to move objects to new filegroups/tablespaces using the ALTER syntax for the given object type ie: table/index. Maybe Microsoft is changing this???Thanks everyone for your help ...
2004-02-20
RE: sp_spaceused tablename for each database
Thanks.. that is EXACTLY what I'm looking. Now my only issue is putting the info into a table. Every time I try an insert I get an error message that says Server: Msg 8164, Level 16, State 1, Line 1 An INSERT EXEC statement cannot be nested. Server: Msg 8164, Level 16, State 1, Line 1I've […]
2004-02-19
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers