Topics
Started by
Posts
Last post
Is there a way to script all Triggers in a Database to a text file? Thanks
2 replies
This might not be the right place for this, wasn't sure exactly where to post this question. I have…
1 replies
/****** Object: StoredProcedure [dbo].[spQMS_FetchStrataSummary] Script Date: 8/4/2013 9:05:25 …
1 replies
I'm not a DBA. I'm a programmer trying to do things with SQL Server. I call this a "dynamic" functi…
5 replies
SELECT DATEDIFF (day, Convert(Varchar(11),DATEADD(d,-(DAY(getdate())-1),getdate()),110), Convert(va…
2 replies
I'm trying to understand EXECUTE AS SELF/security contexts. In all the documentation I have found, …
1 replies
Have there been any changes, even minor ones, to ownership chaining in SQL 2012? I have a problem w…
7 replies
I have tried and tried to post this question in the MSDN forums but keep getting an irritating erro…
6 replies
Hi! I have a query where I want a group id every x rows. Here is some sample data of what I'm worki…
2 replies
I have a computer A which has sql installed in it and i have the sql file which has a code now i ha…
1 replies
Is this an effective way to find median? CREATE TABLE #T (i TINYINT); GO INSERT INTO #T SELECT ABS…
13 replies
First a bit of background. I recently started a job with a somewhat complicated setup for a 50 TB …
16 replies
I've spent a fair bit of time searching, but can't seem to find a succinct answer...is there a more…
7 replies
Hi, I would like to create a global variable that I can reference multiple times and here is the sc…
15 replies
Hi there, I have the following script - SELECTDATEPART(WW, JOB.created_date) AS [Created Calendar…
8 replies
Viewing 15 topics - 4,726 through 4,740 (of 4,979 total)
You must be logged in to create new topics.