|
|
-
Hardik Doshi Liked 11 Months ago through Just Learned | 1 Point
There's no way to return a resultset and set variables using a single SELECT statement.
But there's one way to do it using a MERGE statement.
It's quite simple, you first declare a variable table which will be used to store some data.
You then use a...
|
-
Hardik Doshi Liked 11 Months ago through Just Learned | 1 Point
There's no way to return a resultset and set variables using a single SELECT statement.
But there's one way to do it using a MERGE statement.
It's quite simple, you first declare a variable table which will be used to store some data.
You then use a...
|
-
Hardik Doshi Liked 11 Months ago through Just Learned | 1 Point
A simple method to find out who altered/modified an object in SQL server using trace.
SELECT I.*
FROM
sys.traces T
CROSS Apply ::fn_trace_gettable(T.path, T.max_files) I
Join sys.trace_events E On I.eventclass = E.trace_event_i...
|
-
Hardik Doshi Liked 11 Months ago through Just Learned | 1 Point
A simple method to find out who altered/modified an object in SQL server using trace.
SELECT I.*
FROM
sys.traces T
CROSS Apply ::fn_trace_gettable(T.path, T.max_files) I
Join sys.trace_events E On I.eventclass = E.trace_event_i...
|
-
Hardik Doshi Liked 11 Months ago through Just Learned | 1 Point
You can see this from the result of this query that Sum of consecutive odd numbers starting from 1 is a perfect square
[code]select 1,1+3,1+3+5,1+3+5+7,1+3+5+7+9[/code]......
|
-
Hardik Doshi Liked 11 Months ago through Just Learned | 1 Point
You can see this from the result of this query that Sum of consecutive odd numbers starting from 1 is a perfect square
[code]select 1,1+3,1+3+5,1+3+5+7,1+3+5+7+9[/code]......
|
-
Hardik Doshi Liked 12 Months ago through Just Learned | 1 Point
Sometimes when SQL Server is configured to use some port other than default port number (1433), then you may not be able to connect directly in SSMS just by specifying the name of the server in the **Server Name** field in **Connection to Server** di...
|
-
Hardik Doshi Liked 12 Months ago through Just Learned | 1 Point
Sometimes when SQL Server is configured to use some port other than default port number (1433), then you may not be able to connect directly in SSMS just by specifying the name of the server in the **Server Name** field in **Connection to Server** di...
|
-
Hardik Doshi Liked 12 Months ago through Just Learned | 1 Point
Till Date I have been using Red Gate SQL compare tool for Schema comparison for databases.
Just came to know Microsoft Visual Studio2010 also provides an inbuilt tool for Data comparison & Schema Comparison for two databases.
Below are the steps for...
|
-
Hardik Doshi Liked 12 Months ago through Just Learned | 1 Point
Till Date I have been using Red Gate SQL compare tool for Schema comparison for databases.
Just came to know Microsoft Visual Studio2010 also provides an inbuilt tool for Data comparison & Schema Comparison for two databases.
Below are the steps for...
|