Last month Name and Year in a SSRS expression
Show the last month and year in a expression, based on a parameter called asofdate. Must format Date Month Year
2011-11-08 (first published: 2011-10-11)
9,203 reads
Scripts
Extract values from a string using a delimiter
There are many occasions in programs where you need to manipulate strings of characters that are delimited by a particular character, such as a comma, or a space. This function enables you to extract a substring from the string at a specified occurence of the delimter. declare @Data varchar(255) set @Data = 'A,B,C,D,E' print dbo.field(@data,',',2,2) […]
2011-11-07 (first published: 2007-08-03)
2,656 reads
Wait Time - Query\Client
Script helps to get the client and queries that generate longer waiting time.
2011-11-07 (first published: 2011-10-14)
1,551 reads
Compare 2 datasets and output delta in one TSQL statement
There are many ways 2 compare datasets to find differences, this is one of them.
2011-11-04 (first published: 2011-10-21)
2,348 reads
Check if Constraint is enabled or disabled
This is a script to find all constraints and check if they are enabled or disabled.
2011-11-03 (first published: 2011-10-12)
7,932 reads
2011-11-02 (first published: 2011-10-21)
1,803 reads
2011-11-01 (first published: 2011-10-18)
2,587 reads
2011-10-31 (first published: 2011-10-19)
2,297 reads
Proc to Rename a file
A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.
2011-10-28 (first published: 2008-05-13)
3,067 reads
Find and Replace a String in the Whole Database
Find and Replace a string in all string fields (char, varchar, etc) of all tables in the database.
2011-10-27 (first published: 2008-02-08)
3,474 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan Resmi BCA KCP Tanggul Hub/Wa. 0817-819-444
Jl. PB.Sudirman No.40, Tekoan, Tanggul Kulon, Kec. Tanggul, Kabupaten Jember, Jawa Timur 68155
Layanan BCA KCP Jajag Hub/Wa. 0817-819-444
Jl. YOS Sudarso No.49, Dusun Kp. Baru, Jajag, Kec. Gambiran, Kabupaten Banyuwangi, Jawa Timur...
Question of the Day
Adding Bits I
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers