Script to return Rows count from table using sp_ExecuteSQL
Script to return Rows count from table using sp_ExecuteSQL
2008-09-26 (first published: 2008-07-20)
1,527 reads
2008-09-19 (first published: 2008-07-20)
1,479 reads
2008-09-08 (first published: 2008-07-20)
1,267 reads
2008-07-20
2,003 reads
2008-07-20
1,609 reads
2008-01-29 (first published: 2007-11-23)
1,960 reads
2008-01-28 (first published: 2007-12-03)
1,694 reads
Clear all the data from tables
This script will delete all rows from the database, except system tables.
2007-11-26 (first published: 2007-09-30)
1,699 reads
2007-11-16
3,282 reads
2007-11-08
2,891 reads
Blogs
Monday Monitor Tips: ServiceNow Integration
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Becoming a creator, my website experience
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
Forums
Cannot get KB959420
Hi, we lost our sever sql2000 To restore database to a new one we...
Do You Really Need HA?
Comments posted to this topic are about the item Do You Really Need HA?
The New Database CheckDB
Comments posted to this topic are about the item The New Database CheckDB
Question of the Day
The New Database CheckDB
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers