CREATE TABLE MyTable ( ID INT, Data varchar(max) ) GO INSERT INTO MyTable VALUES ( 4, 'This is stuff' ), ( 6, 'This is more stuff' ) GO SELECT * FROM MyTable GO -------- -- Adding IDENTITY property -------- SELECT * INTO #MyTempTable FROM MyTable GO TRUNCATE TABLE MyTable GO ALTER TABLE MyTable ADD ID_II INT IDENTITY(1,1) GO ALTER TABLE MyTable DROP COLUMN ID GO ALTER TABLE MyTable ALTER COLUMN ID_II INT NOT NULL GO EXEC sp_rename 'MyTable.ID_II', 'ID', 'COLUMN' GO SET IDENTITY_INSERT MyTable ON GO INSERT INTO MyTable ( ID, Data ) SELECT t.ID, t.Data FROM #MyTempTable t GO SET IDENTITY_INSERT MyTable OFF GO INSERT INTO MyTable ( Data ) VALUES ( 'This is the last stuff' ) GO DROP TABLE #MyTempTable GO SELECT * FROM MyTable GO EXEC sp_help MyTable GO -------- -- Removing IDENTITY property -------- -- Drop FKs/UKs/PKs/Indexes that reference the Column being changed. ALTER TABLE MyTable ADD ID_II INT GO UPDATE MyTable SET ID_II = ID GO ALTER TABLE MyTable DROP COLUMN ID GO ALTER TABLE MyTable ALTER COLUMN ID_II INT NOT NULL GO EXEC sp_rename 'MyTable.ID_II', 'ID', 'COLUMN' GO -- Recreate FKs/UKs/PKs/Indexes that referenced the Column being changed. SELECT * FROM MyTable GO EXEC sp_help MyTable GO --Adding IDENTITY property to a Column DROP TABLE MyTable GO
Declare @pSortParam varchar(35) Select @pSortParam = 'BfsXpLogID'; with a as ( Select * from dbo.BfsXpLog a with (nolock) ) Select * from (Select top 10 * from a where @pSortParam = 'CreateDate' order by CreateDate) as b union all Select * from (Select top 10 * from a where @pSortParam = 'BfsXpLogID' order by BfsXpLogID) as b
WE BELIEVE
YOUNG MEN
YOUNG WOMEN
WE SEEK AFTER THESE THINGS
LEADER SUPPORT
- Christ organized the Church (Eph 4:11-14)
- The true church must bear the name of Jesus Christ (Eph 5:23)
- The true church must have a foundation of Apostles and Prophets (Eph 2:19-20)
- The true church must have the same organization as Christ's Church (Eph 4:11-14)
- The true church must claim divine authority (Heb 5:4-10)
- The true church must have no paid ministry (1 Cor 9:16-18; Acts 20:33-34; John 10:11-13)
- The true church must baptize by immersion (Matt 3:13-16)
- The true church must bestow the gift of the Holy Ghost by the laying on of hands (Acts 8:14-17)
- The true church must practice divine healing (Mark 3:14-15)
- The true church must teach that God and Jesus are separate and distinct individuals (John 17:11; 20:17)
- The true church must teach that God and Jesus have bodies of flesh and bone (Luke 23:36-39; Acts 1:9-11; Heb 1:1-3)
- The officers must be called by God (Heb 4:4; Ex 28:1; 40:13-16)
- The true church must claim revelation from God (Amos 3:7)
- The true church must be a missionary church (Matt 28:19-20)
- The true church must be a restored church (Acts 3:19-20)
- The true church must practice baptism for the dead (1 Cor 15:16&29)
- "By their fruits ye shall know them." (Matt 7:20
Categories
- Android (2)
- Backpacking (5)
- BBQ (3)
- Bikes (3)
- Boy Scouts (6)
- Breakfast (2)
- Cars (1)
- Chinese (2)
- CMD (8)
- eBooks (1)
- ELL (1)
- Family (13)
- Favorite Poetry (6)
- Flame (1)
- Fun (29)
- Instructables (4)
- Joannie (38)
- LDS Church (12)
- Men's Health Lists (2)
- Oracle (2)
- Pixar (1)
- PowerShell (4)
- Productivity (1)
- Projects (8)
- Recipe (46)
- Reign (2)
- RV (1)
- Scouting (7)
- Security (1)
- Shopping (7)
- Smoking (3)
- Softball (7)
- Sports (6)
- SQL Server (61)
- Stealth (1)
- Tools (58)
- Video (23)
- Visual Studio (5)
- Webelos (2)
Recent Posts
Archives
-
►
2014
(2)
- ► 04/20 - 04/27 (1)
- ► 03/30 - 04/06 (1)
-
►
2013
(9)
- ► 11/24 - 12/01 (3)
- ► 10/06 - 10/13 (1)
- ► 09/08 - 09/15 (1)
- ► 08/18 - 08/25 (2)
- ► 06/09 - 06/16 (1)
- ► 04/28 - 05/05 (1)
-
►
2012
(12)
- ► 06/24 - 07/01 (1)
- ► 06/03 - 06/10 (3)
- ► 05/27 - 06/03 (1)
- ► 05/20 - 05/27 (2)
- ► 04/22 - 04/29 (1)
- ► 03/18 - 03/25 (3)
- ► 03/04 - 03/11 (1)
-
▼
2011
(84)
- ► 12/11 - 12/18 (1)
- ► 10/30 - 11/06 (2)
- ► 10/16 - 10/23 (1)
- ► 10/09 - 10/16 (1)
- ► 09/04 - 09/11 (1)
- ► 08/28 - 09/04 (1)
- ► 07/10 - 07/17 (4)
- ► 07/03 - 07/10 (2)
- ► 06/26 - 07/03 (6)
- ► 06/12 - 06/19 (2)
- ► 05/29 - 06/05 (1)
- ► 04/17 - 04/24 (1)
- ► 04/10 - 04/17 (2)
- ► 04/03 - 04/10 (2)
- ► 03/13 - 03/20 (1)
- ► 03/06 - 03/13 (1)
- ► 02/27 - 03/06 (1)
- ► 02/20 - 02/27 (1)
- ► 02/13 - 02/20 (5)
- ► 02/06 - 02/13 (1)
- ► 01/30 - 02/06 (41)
- ▼ 01/23 - 01/30 (4)
- ► 01/09 - 01/16 (1)
- ► 01/02 - 01/09 (1)
-
►
2010
(56)
- ► 12/26 - 01/02 (1)
- ► 12/12 - 12/19 (4)
- ► 12/05 - 12/12 (2)
- ► 11/28 - 12/05 (1)
- ► 11/14 - 11/21 (6)
- ► 10/31 - 11/07 (4)
- ► 10/24 - 10/31 (4)
- ► 10/17 - 10/24 (1)
- ► 10/10 - 10/17 (2)
- ► 10/03 - 10/10 (4)
- ► 09/26 - 10/03 (3)
- ► 09/19 - 09/26 (1)
- ► 09/12 - 09/19 (9)
- ► 08/08 - 08/15 (1)
- ► 06/20 - 06/27 (1)
- ► 04/04 - 04/11 (1)
- ► 03/14 - 03/21 (1)
- ► 02/21 - 02/28 (3)
- ► 02/07 - 02/14 (3)
- ► 01/31 - 02/07 (2)
- ► 01/03 - 01/10 (2)
-
►
2009
(58)
- ► 12/20 - 12/27 (1)
- ► 09/20 - 09/27 (7)
- ► 09/06 - 09/13 (1)
- ► 07/26 - 08/02 (1)
- ► 07/12 - 07/19 (1)
- ► 06/14 - 06/21 (1)
- ► 06/07 - 06/14 (4)
- ► 05/31 - 06/07 (2)
- ► 05/24 - 05/31 (4)
- ► 05/17 - 05/24 (5)
- ► 05/10 - 05/17 (9)
- ► 05/03 - 05/10 (12)
- ► 04/26 - 05/03 (10)
Favorite Links
Favorite Tunes
Pronounced
![](http://cache.lexico.com/g/d/speaker.gif)
![](http://cache.lexico.com/dictionary/graphics/luna/thinsp.png)
![](http://cache.lexico.com/g/d/dictionary_questionbutton_default.gif)
![](http://cache.lexico.com/dictionary/graphics/luna/thinsp.png)
![](http://cache.lexico.com/g/d/dictionary_questionbutton_default.gif)
–noun
Fishing
.
of or pertaining to the period in which a fisherman must leave to go fishing. |
–adjective
Computers
.
of or pertaining to applications in which the computer must respond as rapidly as required by the user or necessitated by the process being controlled. |