Determine what user created objects in SQL Server
Aug 10, 2009 · As alluded to by @crokusek, for recent versions of SQL Server/Azure SQL database this doesn't work. The notes @crokusek link to state that "For databases upgraded …
SQL Server tables: what is the difference between @, # and
Feb 8, 2010 · ##table is a global temporary table and for the record in over 10 years of using SQL Server I have yet to come across a valid use case. I'm sure that some exist but the nature of …
sql server - How to create a table using "With" clause in SQL
Mar 20, 2017 · This is not valid syntax for sql server. you can either create a table using CREATE TABLE and specifying the column names and types, or you can do a SELECT INTO statement …
sql server - SQL: how to specify a date format on creating a table …
Dec 22, 2016 · You don't need to specify the format in the table definition as dates are stored in a binary format. CREATE TABLE APP( ID INT NOT NULL, DT DATE, ADDRESS NVARCHAR …
How to create a table from select query result in SQL Server 2008
May 22, 2013 · It can also be used to create a new table that contains data selected from a linked server. Example, SELECT col1, col2 INTO #a -- <<== creates temporary table FROM tablename
sql - What does ON [PRIMARY] mean? - Stack Overflow
Dec 4, 2015 · When you create a database in Microsoft SQL Server you can have multiple file groups, where storage is created in multiple places, directories or disks. Each file group can …
SQL drop table and re-create and keep data - Stack Overflow
Dec 13, 2013 · Using SQL Server Management Studio (SSMS), you can use it's table designer to specify the final condition of the table. Before saving the changes, have it generate the change …
sql server - what is '#' in create table statement? - Database ...
'#' denotes a temporary table. This tells SQL Server that this table is a local temporary table. This table is only visible to this session of SQL Server. When I close this session, the table will be …
Create SQL table with the data from another table
Aug 7, 2010 · Create the new table with a CREATE TABLE statement; Use INSERT based on a SELECT from the old table: INSERT INTO new_table SELECT * FROM old_table In SQL …
sql - Creating an index on a table variable - Stack Overflow
May 20, 2009 · The question is tagged SQL Server 2000 but for the benefit of people developing on the latest version I'll address that first. SQL Server 2014. In addition to the methods of …