Viewing 5 posts - 16 through 20 (of 20 total)
Dont Work Both Query
SELECT
N'
UPDATE ' + QUOTENAME(s.NAME) + N'.' + QUOTENAME(t.name) + N'
SET ' + QUOTENAME(c.name) +...
January 17, 2012 at 12:26 am
#1434435
Hi SSC Rookie
Thanks For Reply 😉
I dont Test your Query yet
January 17, 2012 at 12:04 am
#1434429
Is This True ??
USE TestDb;
DECLARE @Table NVARCHAR(MAX),
@Col NVARCHAR(MAX)
DECLARE Table_Cursor CURSOR
FOR
SELECT a.name, --table
...
January 16, 2012 at 11:50 pm
#1434425
For every Column Data Type Is "Bit"
Example :
select * from syscolumns where xtype = 104 --: bit
January 16, 2012 at 11:25 pm
#1434414
For All Table in the Data Base
I have many Table , No one Table
January 16, 2012 at 11:11 pm
#1434408