Group items tagged
T-SQL: search by tags - 0 views
DECLARE @filter TABLE (id INT IDENTITY, data nvarchar(32)) insert into @filter (data) values ('sql,performance') insert into @filter (data) values ('profiler') insert into @filter (data) values ...
T-SQL: find SQL TCP port number - 0 views
--SQL 2000/2005 Version set nocount on go DECLARE @SqlPort Nvarchar(10) DECLARE @instance_name Nvarchar(30) DECLARE @reg_key Nvarchar(500) Declare @value_name Nvarchar(20) if left(CAST(SERVERPROP...
Dynamic Search Conditions in T-SQL - 0 views
Ten SQL Server Functions That You Hardly Use But Should - 0 views
T-SQL: list files in folder - 1 views
create table #Files ( FullName nvarchar(255) null ) insert #Files exec master..xp_cmdshell 'DIR C:*.csv /B /S' select right(FullName, patindex('%%', reverse(FullName)) - 1) as ShortFileName ...
T-SQL: disk free space alert - 0 views
USE [msdb] GO EXEC msdb.dbo.sp_add_alert @name=N'Disk Free Space on Drive E', @message_id=0, @severity=0, @enabled=1, @delay_between_responses=0, @include_event_description_in=0, ...
T-SQL: last day of the month, round dates - 0 views
SELECT DAY(DATEADD(d, -DAY(DATEADD(m,1,GETDATE())),DATEADD(m,1,GETDATE())))
T-SQL: disk free space alert - 0 views
Error Handling in SQL - 0 views
Input Note - 0 views
set nocount on declare @SqlInstanceName varchar(128), @SqlServiceName varchar(128), @Cmd varchar(8000), @TempDbLoc varchar(255), @SysDbLoc varchar(255), @UserDbDataLoc varchar(255), @U...
SQL Server Programming Hacks - 0 views
Simple vs Searched CASE statements-SSAS - 0 views
-
Simple vs Searched CASE statements
1 - 15 of 15
Showing 20▼ items per page