\u00d6ncelikle A\u015fa\u011f\u0131daki kodu \u00e7al\u0131\u015ft\u0131rarak prosed\u00fcr olu\u015ftural\u0131m<\/p>\n
CREATE PROC SearchAllTables<\/p>\n
<\/p>\n
(
\n@SearchStr nvarchar(100)
\n)
\nAS
\nBEGIN
\nCREATE TABLE #Results (TableName NVARCHAR(370),ColumnName nvarchar(370), ColumnValue nvarchar(3630))<\/p>\n
SET NOCOUNT ON<\/p>\n
DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)
\nSET @TableName = ”
\nSET @SearchStr2 = QUOTENAME(‘%’ + @SearchStr + ‘%’,””)<\/p>\n
WHILE @TableName IS NOT NULL
\nBEGIN
\nSET @ColumnName = ”
\nSET @TableName =
\n(
\nSELECT MIN(QUOTENAME(TABLE_SCHEMA) + ‘.’ + QUOTENAME(TABLE_NAME))
\nFROM INFORMATION_SCHEMA.TABLES
\nWHERE TABLE_TYPE = ‘BASE TABLE’
\nAND QUOTENAME(TABLE_SCHEMA) + ‘.’ + QUOTENAME(TABLE_NAME) > @TableName
\nAND OBJECTPROPERTY(
\nOBJECT_ID(
\nQUOTENAME(TABLE_SCHEMA) + ‘.’ + QUOTENAME(TABLE_NAME)
\n), ‘IsMSShipped’
\n) = 0
\n)<\/p>\n
WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)
\nBEGIN
\nSET @ColumnName =
\n(
\nSELECT MIN(QUOTENAME(COLUMN_NAME))
\nFROM INFORMATION_SCHEMA.COLUMNS
\nWHERE TABLE_SCHEMA = PARSENAME(@TableName, 2)
\nAND TABLE_NAME = PARSENAME(@TableName, 1)
\nAND DATA_TYPE IN (‘char’, ‘varchar’, ‘nchar’, ‘nvarchar’)
\nAND QUOTENAME(COLUMN_NAME) > @ColumnName
\n)<\/p>\n
IF @ColumnName IS NOT NULL
\nBEGIN
\nINSERT INTO #Results
\nEXEC
\n(
\n‘SELECT ”’ +@TableName+ ”’, ”’ + @TableName + ‘.’ + @ColumnName + ”’, LEFT(‘ + @ColumnName + ‘, 3630)
\nFROM ‘ + @TableName + ‘ (NOLOCK) ‘ +
\n‘ WHERE ‘ + @ColumnName + ‘ LIKE ‘ + @SearchStr2
\n)
\nEND
\nEND
\nEND<\/p>\n
SELECT * FROM #Results<\/p>\n
END<\/p>\n
<\/p>\n
*******************************<\/p>\n
** \u00a0 \u00d6rnek Kullan\u0131m \u015eekli \u00a0 \u00a0 \u00a0 \u00a0 \u00a0**<\/p>\n
*******************************<\/p>\n
** \u00a0exec SearchAllTables ALI \u00a0 **<\/p>\n
*******************************<\/p>\n","protected":false},"excerpt":{"rendered":"
\u00d6ncelikle A\u015fa\u011f\u0131daki kodu \u00e7al\u0131\u015ft\u0131rarak prosed\u00fcr olu\u015ftural\u0131m CREATE PROC SearchAllTables<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-1392","post","type-post","status-publish","format-standard","hentry","category-sql-server-tsql"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1392","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=1392"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1392\/revisions"}],"predecessor-version":[{"id":1393,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1392\/revisions\/1393"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=1392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=1392"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=1392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}