Viewing 15 posts - 106 through 120 (of 138 total)
Thanks dwain eventually find out what was needed.
September 25, 2012 at 10:02 pm
I found out that user_seek means number of times when the user issues the command like select fname from emp
and user_scan means the number of time the user issue...
September 25, 2012 at 8:42 pm
anthony.green (9/18/2012)
back the data you want up into another tablesomething like this
select * into tablename_backup from tablename where somecol = 1000
Hi since i am newbie in SQL Server, This solution...
September 18, 2012 at 2:21 am
rhythmk (9/14/2012)
Hi Shadab,
Try this.
SELECT t.name AS tablename, c.name AS columnname,d.name AS datatype
FROM sys.tables t inner join sys.columns c ON t.object_id=c.object_id
inner join sys.types d ON d.system_type_id = c.system_type_id
To have a clear...
September 14, 2012 at 1:21 am
subbareddy542 (9/13/2012)
PLS TRY BELOW CODE..SELECT TABLE_NAME,COLUMN_NAME,DATA_TYPE,CHARACTER_MAXIMUM_LENGTH,NUMERIC_PRECISION,NUMERIC_SCALE FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME
IN(SELECT name FROM sys.tables)
ORDER BY TABLE_NAME
Thanks Subbareddy for the solution. But i am trying to learn SQL Server. So like to...
September 13, 2012 at 11:17 pm
Thanks to all for suggesting the solution
September 6, 2012 at 6:25 am
Eugene Elutin (9/5/2012)
Again, I would advise to simply search for objects interested and then do manual review of code.
Hi,
I think that would be next to impossible 🙂 .
September 5, 2012 at 11:30 pm
XMLSQLNinja (9/5/2012)
-- pass the query text as search string variable
DECLARE @query varchar(1000)
SET @query =' INSERT ...
September 5, 2012 at 11:28 pm
Robert klimes (9/5/2012)
you could replace all spaces with wildcards
SELECT o.nameFROM sys.sql_modules m
JOIN sys.objects o ON m.object_id = o.object_id
where definition like replace('%select * from table1 where id=5%',' ','%')
Thaks for the solution...
September 5, 2012 at 11:26 pm
Luis Cazares (9/5/2012)
Here's one way to do it http://www.sqlservercentral.com/Forums/FindPost821209.aspx
You might need to replace char(9), char(10) and char(13) as...
September 5, 2012 at 11:24 pm
Mark-101232 (9/5/2012)
Shadab Shah (9/5/2012)
Mark-101232 (9/5/2012)
SELECT name
FROM sys.objects
WHERE type='P' AND OBJECT_DEFINITION(object_id) LIKE '%myquery here%'
Your solution works only when every thing exact is pasted in myquery area in the above query. By...
September 5, 2012 at 11:07 pm
Robert klimes (9/5/2012)
you can also use the sys.sql_modules view.
With sql_modules i found this query but it also as the same problem as specified aboveSELECT o.name
FROM sys.sql_modules m
JOIN sys.objects o ON...
September 5, 2012 at 9:10 am
Mark-101232 (9/5/2012)
SELECT name
FROM sys.objects
WHERE type='P' AND OBJECT_DEFINITION(object_id) LIKE '%myquery here%'
Your solution works only when every thing exact is pasted in myquery area in the above query. By the word exact...
September 5, 2012 at 9:03 am
Viewing 15 posts - 106 through 120 (of 138 total)