|
|
-
abhIShek BandI Liked 5 Months ago through Just Learned | 1 Point
Generally we write "insert into" to insert the data into a table.
When we use "Insert" also the statement will execute perfectly.
create table #tbl(id int)
go
insert into #tbl
select 1
go
insert #tbl
select 2
go
...
|
-
abhIShek BandI Learned 5 Months ago through Just Learned | 1 Point
Generally we write "insert into" to insert the data into a table.
When we use "Insert" also the statement will execute perfectly.
create table #tbl(id int)
go
insert into #tbl
select 1
go
insert #tbl
select 2
go
...
|
-
abhIShek BandI Posted 5 Months ago through Just Learned | 5 Points
Generally we write "insert into" to insert the data into a table.
When we use "Insert" also the statement will execute perfectly.
create table #tbl(id int)
go
insert into #tbl
select 1
go
insert #tbl
select 2
go
s...
|
-
abhIShek BandI Liked 5 Months ago through Just Learned | 1 Point
**Hold Control and shift key while Clicking on Program icon**.
**For example:** You want to open visual studio with administrator rights then **Ctrl + Shift + Click on visual studio icon**...
|
-
abhIShek BandI Learned 5 Months ago through Just Learned | 1 Point
**Hold Control and shift key while Clicking on Program icon**.
**For example:** You want to open visual studio with administrator rights then **Ctrl + Shift + Click on visual studio icon**...
|
|
|
-
abhIShek BandI Liked 5 Months ago through Just Learned | 1 Point
Both `SP_who` and `SP_who2` provides information about the current processes/sessions/users in an SQL servert instance.
- `SP_WHO`:
`SP_WHO` provides information like Session ID, Logged in User id , Host name, session status, blocki...
|
-
abhIShek BandI knew 5 Months ago through Just Learned | 1 Point
Both `SP_who` and `SP_who2` provides information about the current processes/sessions/users in an SQL servert instance.
- `SP_WHO`:
`SP_WHO` provides information like Session ID, Logged in User id , Host name, session status, blocki...
|
-
abhIShek BandI Liked 5 Months ago through Just Learned | 1 Point
Whenever you have a filtered index you just might find that it's not used when its columns are compared to a variable.
The thing is, SQL Server will always make an Excecution Plan that would work with any values for those variable (including the valu...
|
-
abhIShek BandI Learned 5 Months ago through Just Learned | 1 Point
Whenever you have a filtered index you just might find that it's not used when its columns are compared to a variable.
The thing is, SQL Server will always make an Excecution Plan that would work with any values for those variable (including the valu...
|