|
|
|
|
-
|
|
Someone in the forums asked about the internal storage of the temporary table. The questioner was complaining that the table was not stored in the database
Let us consider this example
create table #t(i int)
Now check the existance of the table in information_schema.tables view
select * from......
|
|
-
|
|
"How do I find Nth maximum value?" is one of the most asked questions Here are some methods
I explain how to find 5th Maximum value
declare @number table(num integer)
Insert into @number values(3456)
Insert into @number values(846)
Insert into @number values(1456)
Insert into @number va......
|
|
-
|
|
When viewing the existing table structures, I noticed that one table has a column with datatype defined as VARCHAR(1). I generally do not see this being used.
Given that you need to use a character datatype of maximum length of 1, the question is "Is V...
|
|
-
|
|
One of my friends asked me if it is possible to load multiple resultsets returned from a stored procedure into a temporary table for some analysis purpose. The answer is "It depends". If all the resultsets return same number of columns then it is possib...
|
|
-
|
|
Following up Question of the month December 2012 - Why is last comma ignored in CREATE TABLE statement? , here is same question on TABLE VARIABLE
The last comma in permenant and temporary tables are ignored when you run the followingCREATE TABLE emp(emp...
|
|
-
|
|
In Query Analyser, set the result mode to Text (Press CTRL+T), execute the following code and see the result. set nocount on
select
space(total-len(replicate(char(characters),no)))+ replicate(char(characters),no*2-1)
from
(
...
|
|
-
|
|
I have started a series on Exploring SSIS where I will explain various features available. In this post, we will see the usage of Execute SQL task in Control flow Execute SQL task is primarily used to execute SQL statements and stored procedures with o...
|
|
-
|
|
SQL Server Integration Services (SSIS) is one of the tools that can be effectively used to transfer data to various destinations. In versions prior to 2005, we had Import/Export wizard which was part of Database Engine and a package would be created bas...
|
|
-
|
|
Pinal Dave (Blog|Twitter), Blogger,Author, Evangelist and Speaker, posted a blog post about Reseting Identity Values for All Tables. He has used the undocumented system stored procedure to perform this. As you know sp_MSForEachTable is undocumented and ...
|
|