Showing posts with label How declare table variable in sql. Show all posts
Showing posts with label How declare table variable in sql. Show all posts

Tuesday, 27 September 2016

How declare table variable in sql


Declare a table variable
DECLARE @t table
( 
    id        INT Identity, 
    column1   VARCHAR(200)
)

insert value to the table 
insert into @t(a)
     select 'aa'
     union
     select 'bb'
     union
     select 'cc'
     union
     select 'dd'

Run select query
select * from @t
 
 
1       aa
2       bb
3       cc
4       dd 

Python Tutorial: Conditional Statements

Python Tutorial: Conditional Statements Python is a smart language , compare to other programing language python code is so smart that it ma...