|
|
-
Madhivanan Learned 2 Years ago through Just Learned | 1 Point
You may be aware of the Code Snippet intoduced in SQL Server Denali as i posted for the same here, http://beyondrelational.com/blogs/paresh/archive/2011/06/06/code-snippets-in-sql-server-denali.aspx.
We can also create Custom Code Snippet in SQL Serv...
|
-
Madhivanan Liked 2 Years ago through Just Learned | 1 Point
You may be aware of the Code Snippet intoduced in SQL Server Denali as i posted for the same here, http://beyondrelational.com/blogs/paresh/archive/2011/06/06/code-snippets-in-sql-server-denali.aspx.
We can also create Custom Code Snippet in SQL Serv...
|
-
Madhivanan Liked 2 Years ago through Just Learned | 1 Point
You may be aware of the Code Snippet intoduced in SQL Server Denali as i posted for the same here, http://beyondrelational.com/blogs/paresh/archive/2011/06/06/code-snippets-in-sql-server-denali.aspx.
We can also create Custom Code Snippet in SQL Server
|
-
Madhivanan Liked 2 Years ago through Just Learned | 1 Point
Recently we had a very puzzling situation. The stored procedure worked fine from the two desktop applications, but failed when called from the middle tier dll in the web environment. My colleague spent quite an amount of time debugging this problem and fin
|
-
Madhivanan Commented 2 Years ago through Just Learned | 1 Point
jimbobmcgee, EXEC test..sp_who_new will execute the procedure available in test database. But EXEC test..sp_who will execute it in master database eventhough the same procedure is also available in test database....
|
-
Madhivanan Commented 2 Years ago through Just Learned | 1 Point
jimbobmcgee, EXEC test..sp_who_new will execute the procedure available in test database. But EXEC test..sp_who will execute it in master database eventhough the same procedure is also available in test database....
|
-
Madhivanan Commented 2 Years ago through Just Learned | 1 Point
jimbobmcgee, EXEC test..sp_who_new will execute the procedure available in test database. But EXEC test..sp_who will execute it in master database eventhough the same procedure is also available in test database....
|
-
Madhivanan Posted 2 Years ago through Just Learned | 5 Points
Refer these examples
[code]Use master
GO
create procedure sp_who_new
as
select 'from master database' as sp_test
[/code]
Create this procedure in test database
[code]
Use test
GO
create procedure sp_who_new
as
select 'from test database' as sp
|
-
Madhivanan Posted 2 Years ago through Just Learned | 5 Points
Refer these examples
[code]Use master
GO
create procedure sp_who_new
as
select 'from master database' as sp_test
[/code]
Create this procedure in test database
[code]
Use test
GO
create procedure sp_who_new
as
select 'from test database' as...
|
-
Madhivanan Posted 2 Years ago through Just Learned | 5 Points
Refer these examples
[code]Use master
GO
create procedure sp_who_new
as
select 'from master database' as sp_test
[/code]
Create this procedure in test database
[code]
Use test
GO
create procedure sp_who_new
as
select 'from test database' as...
|