Topics
Started by
Posts
Last post
Hi, Is it best to use varchar or char for small text columns, max 5 to 10 chars? An example is curr…
9 replies
Hi guys, Need help in sql query, Let me let you what i need, during the S.P i want to like to use …
3 replies
Hi All, I am querying the system tables to get SQL Agent Jobs and schedules information. One field …
11 replies
This is a strange. I had a TVP field name that was very close to the table field name. It took me …
2 replies
I need to create a Directory table for a project within an institute. How shall I implement a prim…
2 replies
Hi I have something like this and the tables have no foreign keys. I am using date in where clause …
2 replies
How to create table by using select command return data. Export utility not possible to create anot…
9 replies
I have a stored procedure that uses "WITH EXECUTE AS" to allow the querying of some system views, t…
4 replies
Hi all I have a datetime column in my DB and I am trying to fetch all records from yesterday using …
12 replies
I have a table with data. I need a query that need to insert only new rows instead of whole data. S…
5 replies
I have a datetime column which has lots of these values: 2012-10-29 00:00:29.000 2011-10-15 00:00:2…
3 replies
I have a dataset with DateTime and Rowcount. I need to select rows only if 7 days or more have ela…
4 replies
Something like this select join_alias.col11, join_alias.col21 from (table1 a INNER JOIN table2 b ON…
4 replies
Hello, Here's my issue, I need to execute a procedure which needs a parameter, that parameter needs…
1 replies
given data like this: PatientID, StartDate, EndDate 1, 2012-10-15 10:00:00, 2012-10-17 08:59:00 Any…
9 replies
Viewing 15 topics - 4,906 through 4,920 (of 10,638 total)
You must be logged in to create new topics.