|
|
|
|
-
Raj Acharya worked 6 Months ago through Scripts
Many IT departments use pre-created ghost images to quickly setup development and quality assurance environments. When they change the name of the server after restoring the image, the SQL Server instance name remains unchanged. Here's a script to chang...
|
-
Raj Acharya liked 6 Months ago through Scripts
Many IT departments use pre-created ghost images to quickly setup development and quality assurance environments. When they change the name of the server after restoring the image, the SQL Server instance name remains unchanged. Here's a script to chang...
|
-
Raj Acharya Commented 1 Years ago through Blogs
this one is useful when my colleague ask me the question somewhat like to update column with same value and need to update only top 5 values and i tried and i have tried this one and it's works gr8 ....good one ...keep it up...
|
-
Raj Acharya Liked 1 Years ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
-
Raj Acharya Learned 1 Years ago through Just Learned
We can insert all the default values in tables without specifiying values while insert in table, how? See here we have tables defined all columns with default,
[code]
CREATE TABLE defaultval(
id int default 0,
name varchar(10)
de...
|
-
Raj Acharya Liked 1 Years ago through Just Learned
We can insert all the default values in tables without specifiying values while insert in table, how? See here we have tables defined all columns with default,
[code]
CREATE TABLE defaultval(
id int default 0,
name varchar(10)
de...
|
-
Raj Acharya Learned 1 Years ago through Just Learned
We can insert all the default values in tables without specifiying values while insert in table, how? See here we have tables defined all columns with default,
[code]
CREATE TABLE defaultval(
id int default 0,
name varchar(10)
de...
|
-
Raj Acharya Liked 1 Years ago through Just Learned
We can insert all the default values in tables without specifiying values while insert in table, how? See here we have tables defined all columns with default,
[code]
CREATE TABLE defaultval(
id int default 0,
name varchar(10)
de...
|
-
Interview questions and answers on various SQL Server areas such as Database Administration, TSQL Development, BI etc....
|