Topics
Started by
Posts
Last post
I've tables and rows as follow, declare @timerH table (idx smallint,troutehidx smallint,seq tinyint…
2 replies
You will quickly see I am not a developer, but somehow I have been sucked into this. Here is what I…
6 replies
hi i have text file which contains date field in format like 'Mar 12 2010 1215PM,Jan 1 1900 1200AM…
3 replies
Hi, I have a scenario where a document directory is recorded in a table in the DB (e.g. C:\DocStora…
4 replies
HI All, I'm trying to import MS Excel data into table using stored procedure. In the stored procedu…
5 replies
Hi all, We have a huge database sets, where members are given continuous running number from 1 t…
1 replies
Each of my clients has its own database with all of the same obects. I often have to query data for…
4 replies
I'm defined Date Only and Time Only data types as follow, create type Date from dateTime create ty…
6 replies
I am currently using a Start Date and and End Date as my parameters in a stored procedure. When I …
1 replies
Hi. How would I go about inserting multiple values into a table based on the results of the IN as b…
3 replies
Can i amend the following script to prompt a user for values when it is executed. Declare @FROM_DAT…
6 replies
Hi , Let say we have a heap table contains 10k records. as we know that according to sql server, St…
4 replies
I am currently need to format the contents of a column into a datetime. The format of the string is…
4 replies
I have the following sql statements to create an expected output. The output is what I would like t…
3 replies
Hi, It is possible to do something like this in SQL Server Triggers? If INSERT, do this; If UPDATE,…
2 replies
Viewing 15 topics - 4,096 through 4,110 (of 12,234 total)
You must be logged in to create new topics.