2008-08-05 (first published: 2008-06-12)
3,461 reads
2008-08-05 (first published: 2008-06-12)
3,461 reads
T-SQL function to takes a string and produce an integer hashcode matching what is produced by the Java String.hashCode() method.
2008-08-04 (first published: 2008-06-11)
1,393 reads
This is an addition to Jim Rea's "Get record count for a specific database". I modified it to loop through all databases and provide counts.
2008-08-01
1,212 reads
Grant permissions to specific objects in Database using dynamic SQL.
2008-08-01 (first published: 2008-06-08)
2,693 reads
2008-08-01
873 reads
2008-07-29 (first published: 2008-06-08)
1,325 reads
2008-07-28 (first published: 2008-05-28)
4,396 reads
This script is a quick throw together that tells you which rows in a table have the most data
2008-07-25 (first published: 2008-06-10)
881 reads
Quick way to get all users on all Databases
2008-07-24 (first published: 2008-06-06)
1,713 reads
2008-07-23
499 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
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