Using the dynamic query as below:Create Procedure tableProc( @tblName varchar(20) = 'tbl_Products')As Begin declare @strSQL as varchar(1000)set...
When we save changes in job steps, SQL Server check whether all steps are used or not. This is to avoide any any issue if we have miss any step by...
Does the following query fulfill your requirement:select * from mytest where (id = 1 and col = 'test' ) or (id = 2 and col = 'test1') Regards,...
Hello Saravanang, There is no sp or script to search DTSs. The best way is: 1. Save all DTSs as Visual Basic Script file (.bas) in a folder. You...
Hello Femi, Remove the brackets from @[Email Address] and @[Post Code] and write these variables like @Email_Address, @Post_Code. Remove the comma...
Hello Jaykumar, In documents there is no size or record count limit for table variable but in practice table variable are good only if record count...
Separate names with a comma.
