Topics
Started by
Posts
Last post
Hi there, Does anyone have any code that will guarentee to recompile all SPs, views and UDF'…
11 replies
Greetings everyone! I am working on a query to give access to a user based on the last name (KEY_NA…
5 replies
A simple stored procedure loops through all tables in a database as shown below. I'm stumped by the…
5 replies
Hi, I have a variable that holds a database name: set @databasename = '[' + 'databasename' + '…
2 replies
Hi all, I am running the below query and I need to the table row counts for EACH database on the se…
6 replies
created a user defined function in tsql that searches for strings within a text field, using the CH…
8 replies
Hi, I'm getting the error "Offset 282 is not in the range of available text, ntext, or image…
2 replies
Hi All, Here is a problem which I am at present facing please solve it and send as early as possibl…
2 replies
hi guys I am trying to import a flat file(txt) into sql. This flat file has got a datetime field wi…
4 replies
I'm looking for a T-SQL Solution to create dynamic fieldnames and values within a query. I've put s…
6 replies
Hi, Having a bit of trouble with a script. I have a table such as : AppNo |AppDate ------------…
3 replies
Hello All!I have a very small question but can't figure out how to deal with it I am importing the…
5 replies
Hi all, I have a table with 3 bit fields: A, B, C. I need to place a constraint so that when A, or …
4 replies
Hello All I had a fellow employee present me with the following syntax for a query. SELECT Col1 F…
1 replies
Hi, I was wondering if there is an easy way to search through a table for a match on Multiple …
5 replies
Viewing 15 topics - 5,806 through 5,820 (of 17,082 total)
You must be logged in to create new topics.