Mega Code Archive
Count table row in dynamic sql
<![CDATA[
3> CREATE TABLE Orders (
4> OrderID int IDENTITY (1, 1) NOT NULL ,
5> CustomerID nchar (5) NULL ,
6> EmployeeID int NULL ,
7> OrderDate datetime NULL ,
8> RequiredDate datetime NULL ,
9> ShippedDate datetime NULL ,
10> ShipVia int NULL ,
11> Freight money NULL DEFAULT (0),
12> ShipName nvarchar (40) NULL ,
13> ShipAddress nvarchar (60) NULL ,
14> ShipCity nvarchar (15) NULL ,
15> ShipRegion nvarchar (15) NULL ,
16> ShipPostalCode nvarchar (10) NULL ,
17> ShipCountry nvarchar (15) NULL
18> )
19> GO
1>
2> DECLARE @schemaname AS NVARCHAR(128), @tablename AS NVARCHAR(128);
3> SET @schemaname = N'dbo';
4> SET @tablename = N'Orders';
5>
6> DECLARE @objectname AS NVARCHAR(517);
7> SET @objectname = QUOTENAME(@schemaname) + N'.' + QUOTENAME(@tablename);
8> EXEC(N'SELECT COUNT(*) FROM ' + @objectname + N';');
9> GO
-----------
0
1>
2> drop table orders;
3> GO
]]>