Loop through string value t-sql - social.msdn.microsoft.com
Sep 9, 2013 · Put the values into a table variable (@table) and build a cursor WHILE for the logic.
how to disable SQL Server Agent Jobs using T-SQL
Oct 4, 2011 · Now i want ot disable those 300 jobs at once by using where name like 'admin%'
T-sql Script to reset the replication process
Feb 28, 2008 · i had configured a merge replication betwen 2 server and i was running fine. but due to network problems my network admin has changed the ip address and name of the …
Microsoft Query cannot run SQL code with a T-SQL variables in it?
Oct 17, 2011 · I am unable to use Microsoft Query to return data from a query that includes T-SQL variables. The weird thing is that Microsoft Query handles the data fine, but then has a …
Enterprise t-sql Stored Procs against tables -vs- Views
Sep 17, 2010 · Option 1 - Be sure to optimize your Database design so your application will only require at most 6 joins and used stored procs for queries using proper indexs to gain the most …
Converting Reserved Words to Upper Case
Jun 25, 2008 · I am using SQL 2005. As I write a procedure/function/etc, I want the Reserved Words to get converted to Capital letters (upper case) automatically. How do I set that.
how to disconnect and clear the user in sys.sysprocesses?
Mar 9, 2012 · Question 0 Sign in to vote SELECT db_name (dbid) as DatabaseName, count (dbid) as NoOfConnections, loginame as LoginName FROM sys.sysprocesses WHERE dbid > …
Permissions within SQL Server Agent jobs
Oct 24, 2011 · You cannot create a SQL Server Agent proxy to execute the job because for T-SQL job step it will not use any SQL Server Agent proxy. For a Transact-SQL job step, by …
Running PL/SQL Syntax on Microsoft SQL Server 2008
Jan 20, 2011 · Is it possible to run PL/SQL procedure on Microsoft SQL 2008. I develop crystal report templates for a number of customers. While the majority use Oracle databases some …
Querying Informix - TSQL syntax is used
Dec 12, 2008 · It is taking your named query, using it as a nested statement within a SELECT statement it assembles which uses the 2000 t-SQL syntax. The only workaround there may be …