RE: How to get sequence number?
There are several ways to do this. Most folks will just create a temp table with an IDENTITY column and insert the data, or add an IDENTITY column to the current table.
2003-06-03
1 reads
PowerShell
RE: Thank you, Status Dormant ?
From the MS Website: Status Meaning Background: SPID is performing a background task. Sleeping: SPID is not currently executing. This usually indicates that the SPID is awaiting a command from the application. Runnable: SPID is currently executing. Dormant: Same as Sleeping, except Dormant also indicates that the SPID has been reset after completing an RPC […]
2003-06-02
1 reads
RE: How to keep and restore the deleted records?
a5xo3z1 use a "status" field ( I add also a timestamp , and a user field ). But adding a column on a production table sometimes it's not possible, but useful on critical DBs.It's also good check if this additional processing will have "side effects" in operation .
2003-05-29
1 reads
RE: Import from Excel Problem
Importation from Excel yields also another kind of problem. Since the data sampling is beeing done with the first 8 rows of data sometimes unwanted results can arise. For example if there is only one column in the excel sheet containing AlphaNumerics in the first rows and some rows with a number in it, the […]
2003-05-28
2 reads
RE: Query to get all logins and access info
Hi JMeyers32, sp_helpprotect should do what you need This is taken from BOL: A. List the permissions for a table This example lists the permissions for the titles table. EXEC sp_helprotect 'titles' B. List the permissions for a user This example lists all permissions that user Judy has in the current database. EXEC sp_helprotect NULL, […]
2003-05-28
RE: scheduling sql script
Create a job, copy and paste your script into job step and schedule the job to run at time you like.
2003-05-27
RE: Problem in Replication for Tables with trigger
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-05-26
RE: help need
If I understand, you are getting the criteria from a list box from a screen. My suggestion is: create procedure [dbo].[query] @ProgramType char(1), @AccountName char(1), @ProgramStatus char(1) as select ProgramId ProgramType AccountName ProgramName ProgramBudget ProgramStatus from <table> where ProgramType like @ProgramType and AccountName like @AccountName and ProgramStatus like @ProgramStatus If in your list box you […]
2003-05-20
RE: cast varchar as datetime
CREATE FUNCTION MyStrip(@v varchar(50)) RETURNS DateTime AS BEGIN Declare @vv Varchar(50) Set @vv=Right(@v,DataLength(@v)-CharIndex(' ',@v)) RETURN Cast(Left(@vv,DataLength(@vv)-CharIndex(' ',Reverse(@vv))) as DateTime) END Select dbo.MyStrip('Fri, 06 Dec 2002 14:52:26 -0500') Select dbo.MyStrip('Fri, 6 Dec 2002 15:08:59 EST')
2003-05-17
1 reads
RE: Other databases
quote: MySQL has its fans though personally I suspect the MySQL vs other open source databases is the VHS vs Betamax thing again. ...and then there were Picture Discs, and now we have DVD Cheers, Frank
2003-05-15
Blogs
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
EightKB 2024 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...
Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory
By Steve Jones
I had a customer that was looking to document a restore that had occurred...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers