|
|
-
SenOvi Liked 8 Months ago through Blogs
Updating string data in-place - while there are lots of options, SQL Server always has something new. The .WRITE clause in the UPDATE statement provides partial data update, and promises to be a great alternative to REPLACE and STUFF depending upon the ...
|
|
|
-
SenOvi Learned 8 Months ago through Just Learned
Copy And paste Query
Create table #temp1
(
id int ,
Name varchar(50),
City varchar(50)
)
Create table #Staging_temp2
(
id int,
Name varchar(50),
City varchar(50)
)
insert into #temp1
...
|
-
SenOvi Liked 8 Months ago through Just Learned
Copy And paste Query
Create table #temp1
(
id int ,
Name varchar(50),
City varchar(50)
)
Create table #Staging_temp2
(
id int,
Name varchar(50),
City varchar(50)
)
insert into #temp1
...
|
-
SenOvi Liked 1 Years ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
-
SenOvi Liked 1 Years ago through Blogs
In November 2011, I wrote a post titled SQL Server – Performance – Best Practice – Create Index Before or After a data insert?. The post dealt with answering the question - which method was better – whether to create an index before or after a bulk-inse...
|
-
SenOvi Learned 1 Years ago through Just Learned
Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement
[code]DROP table test1,test2,test3[/code]......
|
-
SenOvi Liked 1 Years ago through Just Learned
Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement
[code]DROP table test1,test2,test3[/code]......
|
-
SenOvi Learned 1 Years ago through Just Learned
Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement
[code]DROP table test1,test2,test3[/code]......
|
-
SenOvi Liked 1 Years ago through Just Learned
Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement
[code]DROP table test1,test2,test3[/code]......
|